Query 1.0.0.0: Unterschied zwischen den Versionen
Aus Stadtarchiv Butzbach
Zeile 1: | Zeile 1: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables = ARCHIUM_TABLE_sabu_signatur | tables = ARCHIUM_TABLE_sabu_signatur | ||
|fields = | |fields = ARCHIUM_TABLE_sabu_signatur.ARCHIUM_PROPERTY_sabu_ebene1=e1, | ||
ARCHIUM_TABLE_sabu_signatur.ARCHIUM_PROPERTY_sabu_ebene2=e2, | |||
ARCHIUM_TABLE_sabu_signatur.ARCHIUM_PROPERTY_sabu_ebene3=e3, | |||
ARCHIUM_TABLE_sabu_signatur.ARCHIUM_PROPERTY_sabu_ebene4=e4, | |||
ARCHIUM_PROPERTY_sabu_lfdnr=ln | |||
|default = - | |default = - | ||
|where = ARCHIUM_TABLE_sabu_signatur.ARCHIUM_PROPERTY_sabu_ebene1 = 1 | |where = ARCHIUM_TABLE_sabu_signatur.ARCHIUM_PROPERTY_sabu_ebene1 = 1 |
Version vom 23. Mai 2022, 14:26 Uhr
Error 42803: FEHLER: Spalte »cargo__ARCHIUM_TABLE_sabu_signatur.ARCHIUM_PROPERTY_sabu_lfdnr« muss in der GROUP-BY-Klausel erscheinen oder in einer Aggregatfunktion verwendet werden
ZEILE 1: ..._signatur"."ARCHIUM_PROPERTY_sabu_ebene4" AS "e4","ARCHIUM_P...
^
Function: CargoSQLQuery::run Query: SELECT "cargo__ARCHIUM_TABLE_sabu_signatur"."ARCHIUM_PROPERTY_sabu_ebene1" AS "e1","cargo__ARCHIUM_TABLE_sabu_signatur"."ARCHIUM_PROPERTY_sabu_ebene2" AS "e2","cargo__ARCHIUM_TABLE_sabu_signatur"."ARCHIUM_PROPERTY_sabu_ebene3" AS "e3","cargo__ARCHIUM_TABLE_sabu_signatur"."ARCHIUM_PROPERTY_sabu_ebene4" AS "e4","ARCHIUM_PROPERTY_sabu_lfdnr" AS "ln" FROM "cargo__ARCHIUM_TABLE_sabu_signatur" WHERE "cargo__ARCHIUM_TABLE_sabu_signatur"."ARCHIUM_PROPERTY_sabu_ebene1" = 1 GROUP BY "cargo__ARCHIUM_TABLE_sabu_signatur"."ARCHIUM_PROPERTY_sabu_ebene1",
"cargo__ARCHIUM_TABLE_sabu_signatur"."ARCHIUM_PROPERTY_sabu_ebene2", "cargo__ARCHIUM_TABLE_sabu_signatur"."ARCHIUM_PROPERTY_sabu_ebene3", "cargo__ARCHIUM_TABLE_sabu_signatur"."ARCHIUM_PROPERTY_sabu_ebene4" ORDER BY "cargo__ARCHIUM_TABLE_sabu_signatur"."ARCHIUM_PROPERTY_sabu_ebene1","cargo__ARCHIUM_TABLE_sabu_signatur"."ARCHIUM_PROPERTY_sabu_ebene2","cargo__ARCHIUM_TABLE_sabu_signatur"."ARCHIUM_PROPERTY_sabu_ebene3","cargo__ARCHIUM_TABLE_sabu_signatur"."ARCHIUM_PROPERTY_sabu_ebene4" LIMIT 250000