Query 1.0.0.0: Unterschied zwischen den Versionen

Aus Stadtarchiv Butzbach
Wechseln zu: Navigation, Suche
Zeile 1: Zeile 1:
{{#cargo_query:
{{#cargo_query:
             tables = ARCHIUM_TABLE_sabu_signatur
             tables = ARCHIUM_TABLE_sabu_signatur
             |fields = CONCAT( '→',
             |fields = ARCHIUM_TABLE_sabu_signatur.ARCHIUM_PROPERTY_sabu_ebene1=e1,
                              ARCHIUM_TABLE_sabu_signatur.ARCHIUM_PROPERTY_sabu_ebene1, '.',
                      ARCHIUM_TABLE_sabu_signatur.ARCHIUM_PROPERTY_sabu_ebene2=e2,
                              ARCHIUM_TABLE_sabu_signatur.ARCHIUM_PROPERTY_sabu_ebene2, '.',
                      ARCHIUM_TABLE_sabu_signatur.ARCHIUM_PROPERTY_sabu_ebene3=e3,
                              ARCHIUM_TABLE_sabu_signatur.ARCHIUM_PROPERTY_sabu_ebene3, '.',
                      ARCHIUM_TABLE_sabu_signatur.ARCHIUM_PROPERTY_sabu_ebene4=e4,
                              ARCHIUM_TABLE_sabu_signatur.ARCHIUM_PROPERTY_sabu_ebene4,
                      ARCHIUM_PROPERTY_sabu_lfdnr=ln
                              '↔',
                              ARRAY_TO_STRING(ARRAY_SORT(ARRAY_AGG("ARCHIUM_PROPERTY_sabu_lfdnr")),','),
                              '←') = Result
             |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
Abgerufen von „https://stadtarchiv-butzbach.de/index.php?title=Query_1.0.0.0&oldid=95557“