User:Earboxer/query: Difference between revisions
Created page with " # Devices you can call from {{#cargo_query: tables=Devices |fields=CONCAT( '',Manufacturer,' ',Name,'' )=Device,Codename,Architecture,StatusUsbnet=USB Net..." |
No edit summary |
||
Line 7: | Line 7: | ||
|format=table | |format=table | ||
|limit=9999 | |limit=9999 | ||
|where=Devices.Booting = 1 and Devices. | |where=Devices.Booting = 1 and Devices.Calls = 1 | ||
|more results text= | |more results text= | ||
}} | }} |
Revision as of 09:20, 17 September 2022
- Devices you can call from
Function: CargoSQLQuery::run Query: SELECT `cargo__Devices`.`_pageID` AS `cargo_backlink_page_id_Devices`,CONCAT( '',Manufacturer,' ',Name,'' ) AS `Device`,`Codename` AS `Codename`,`Architecture` AS `Architecture`,`StatusUsbnet` AS `USB Net`,`StatusFlashing` AS `Flashing`,`StatusTouch` AS `Touch`,`StatusScreen` AS `Screen`,`StatusWifi` AS `Wifi`,`StatusFde` AS `FDE`,`StatusBattery` AS `Battery`,`Status3d` AS `3D`,`StatusAccel` AS `IMU`,`StatusAudio` AS `Audio`,`StatusBluetooth` AS `Bluetooth`,`StatusCamera` AS `Camera`,`StatusGps` AS `GPS`,`StatusMobiledata` AS `Mobile Data`,`StatusSms` AS `SMS`,`StatusCalls` AS `Calls`,`StatusOtg` AS `USB-OTG`,`StatusNfc` AS `NFC` FROM `cargo__Devices` WHERE `cargo__Devices`.`Booting` = 1 and `cargo__Devices`.`Calls` = 1 ORDER BY `cargo__Devices`.`Manufacturer`,`cargo__Devices`.`Name` LIMIT 100