DFA-Bestandsordnung: Unterschied zwischen den Versionen
| Zeile 5: | Zeile 5: | ||
ARCHIUM_TABLE_title=t, | ARCHIUM_TABLE_title=t, | ||
ARCHIUM_TABLE_maingroup=mg, | ARCHIUM_TABLE_maingroup=mg, | ||
| − | ARCHIUM_TABLE_maingroup_priority=mgp | + | ARCHIUM_TABLE_maingroup_priority=mgp, |
| − | |join on=s._pageName = mg._pageName, s._pageName = mgp._pageName, s._pageName = t._pageName | + | ARCHIUM_TABLE_date_of_creation1=d |
| + | |join on=s._pageName = mg._pageName, s._pageName = mgp._pageName, s._pageName = t._pageName,s._pageName = d._pageName | ||
|fields=CONCAT( '[[', "ARCHIUM_PROPERTY_signature" ,']]' )=Signatur, | |fields=CONCAT( '[[', "ARCHIUM_PROPERTY_signature" ,']]' )=Signatur, | ||
ARCHIUM_PROPERTY_title=Titel, | ARCHIUM_PROPERTY_title=Titel, | ||
| − | ARCHIUM_PROPERTY_maingroup_assignment=Hauptgruppe | + | ARCHIUM_PROPERTY_maingroup_assignment=Hauptgruppe, |
| + | STRING_AGG("ARCHIUM_PROPERTY_dateString",';')=Laufzeiten | ||
|parent field=Hauptgruppe | |parent field=Hauptgruppe | ||
|where=s."_pageName" LIKE 'DFA-%' | |where=s."_pageName" LIKE 'DFA-%' | ||
| Zeile 19: | Zeile 21: | ||
}} | }} | ||
| − | <!--, | + | <!--, , |
--> | --> | ||
Version vom 6. Dezember 2019, 13:32 Uhr
Ordnung in Reihenfolge der Hauptgruppen
Query: SELECT CONCAT( '', "ARCHIUM_PROPERTY_signature" ,'' ) AS "Signatur","ARCHIUM_PROPERTY_title" AS "Titel","ARCHIUM_PROPERTY_maingroup_assignment" AS "Hauptgruppe",STRING_AGG("ARCHIUM_PROPERTY_dateString",';') AS "Laufzeiten" FROM "cargo__ARCHIUM_TABLE_signature" "s" LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_title" "t" ON (("s"."_pageName"="t"."_pageName")) LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_maingroup" "mg" ON (("s"."_pageName"="mg"."_pageName")) LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_maingroup_priority" "mgp" ON (("s"."_pageName"="mgp"."_pageName")) LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_date_of_creation1" "d" ON (("s"."_pageName"="d"."_pageName")) WHERE s."_pageName" LIKE 'DFA-%' ORDER BY mgp."ARCHIUM_PROPERTY_maingroup_priority",s."ARCHIUM_PROPERTY_ID" LIMIT 500 Function: CargoSQLQuery::run Error: 42803 FEHLER: Spalte »s.ARCHIUM_PROPERTY_signature« muss in der GROUP-BY-Klausel erscheinen oder in einer Aggregatfunktion verwendet werden LINE 1: ...n index.php@IndigenerNetzdiener */ CONCAT( '[[', "ARCHIUM_P...
^