Pendenzen: Unterschied zwischen den Versionen

Version vom 10. August 2024, 13:52 Uhr

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', ORDER BY `cargo__bookings`.`_pageID`,`_pageName`,`pendenz` LIMIT 100' at line 1

Function: CargoSQLQuery::run Query: SELECT `cargo__bookings`.`_pageID` AS `cargo_backlink_page_id_bookings`,`_pageName` AS `Name`,`pendenz` AS `Pendenz` FROM `cargo__bookings` WHERE pendenz IS NOT NULL AND pendenz > "", ORDER BY `cargo__bookings`.`_pageID`,`_pageName`,`pendenz` LIMIT 100

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', ORDER BY `cargo__bookings`.`pendenz` LIMIT 100' at line 4

Function: CargoSQLQuery::run Query: SELECT `cargo__bookings`.`_pageID` AS `cargo_backlink_page_id_bookings`,`_pageName` AS `Buchung`,DATE_FORMAT(datum, "%e.%b") AS ` `,`itemtype` AS `Art`,`department` AS `Abt.`,LEFT(purpose,25) AS `Zweck`,CONCAT(IF(pound>0, CONCAT(pound,"lb ") ," "),

          IF(shilling>0,CONCAT(shilling,"ß "),"       "),
          IF(denar>0,    CONCAT(denar,    "dn"),"       ")
         ) AS `Betrag`,`person__full` AS `Person(en)`  FROM `cargo__bookings`    WHERE pendenz IS NOT NULL AND pendenz > "",  ORDER BY `cargo__bookings`.`pendenz` LIMIT 100

83 Einträge

@@ Zeile 2: / Zeile 2: @@
 {{#cargo_query:
    tables=bookings
-   |fields=_pageName=Name,  pendenz=Pendenz
+   |fields=_pageName=Name,  pendenz=Pendenz,
+  |where=pendenz IS NOT NULL AND pendenz > "",
 }}
 {{#cargo_query: