Jump to content

User:Earboxer/query: Difference between revisions

From postmarketOS Wiki
Earboxer (talk | contribs)
Created page with " # Devices you can call from {{#cargo_query: tables=Devices |fields=CONCAT( '',Manufacturer,' ',Name,'' )=Device,Codename,Architecture,StatusUsbnet=USB Net..."
 
Earboxer (talk | contribs)
No edit summary
Line 7: Line 7:
|format=table
|format=table
|limit=9999
|limit=9999
|where=Devices.Booting = 1 and Devices.StatusCalls = 1
|where=Devices.Booting = 1 and Devices.Calls = 1
|more results text=
|more results text=
}}
}}

Revision as of 09:20, 17 September 2022

  1. Devices you can call from
Error 1054: Unknown column 'cargo__Devices.Calls' in 'WHERE'

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