Pendenzen: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| Zeile 16: | Zeile 16: | ||
)=Betrag, | )=Betrag, | ||
person=Person(en), | person=Person(en), | ||
|where=pendenz > "", | |where=pendenz IS NOT NULL AND pendenz > "", | ||
|order by=bookings.pendenz | |||
|order by=bookings. | |||
|default=Keine Buchungen mit eingetragenen Problemen | |default=Keine Buchungen mit eingetragenen Problemen | ||
}} | }} | ||
Version vom 10. August 2024, 13:51 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`.`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