DFA-Bestandsordnung: Unterschied zwischen den Versionen

Version vom 15. Dezember 2019, 22:29 Uhr

Ordnung in Reihenfolge der Klassifikation

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT CONCAT("ARCHIUM_PROPERTY_maingroup_priority",'. ',"ARCHIUM_PROPERTY_maingroup_assignment") AS "Hauptgruppe",CONCAT( '',"_pageName", ' ', "ARCHIUM_PROPERTY_title", ' ',"ARCHIUM_PROPERTY_dateString", ' ') AS "Übersicht" FROM "cargo__ARCHIUM_TABLE_signature" "s" LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_title" "t" ON (("s"."_ID"="t"."_ID")) LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_maingroup" "mg" ON (("s"."_ID"="mg"."_ID")) LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_maingroup_priority" "mgp" ON (("s"."_ID"="mgp"."_ID")) LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_date_of_creation1" "d" ON (("s"."_ID"="d"."_ID")) LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_access_restriction" "r" ON (("s"."_ID"="r"."_ID")) WHERE s."_pageName" LIKE 'DFA-%' ORDER BY mgp."ARCHIUM_PROPERTY_maingroup_priority",s."ARCHIUM_PROPERTY_ID" LIMIT 500 Function: CargoSQLQuery::run Error: 42702 FEHLER: Spaltenverweis »_pageName« ist nicht eindeutig LINE 1: ...ngroup_assignment") AS "Hauptgruppe",CONCAT( '[[',"_pageName...

@@ Zeile 10: / Zeile 10: @@
 |join on=s._ID = mg._ID, s._ID = mgp._ID, s._ID = t._ID,s._ID = d._ID,s._ID=r._ID
 |fields=CONCAT("ARCHIUM_PROPERTY_maingroup_priority",'. ',"ARCHIUM_PROPERTY_maingroup_assignment")=Hauptgruppe,
-CONCAT( '[[',"ARCHIUM_PROPERTY_signature", '|231]] ', "ARCHIUM_PROPERTY_title", ' ',"ARCHIUM_PROPERTY_dateString", ' ')=Übersicht
+CONCAT( '[[',"_pageName", ']] ', "ARCHIUM_PROPERTY_title", ' ',"ARCHIUM_PROPERTY_dateString", ' ')=Übersicht
 |where=s."_pageName" LIKE 'DFA-%' {{#ifexpr:{{#expr:{{#UserAccessCheck:{{PAGENAME}}|{{#var:ARCHIUM_VAR_user_whitelist_{{#username:AnonymousNoname}}}}|{{#var:ARCHIUM_VAR_user_blacklist_{{#username:AnonymousNoname}}}}}}+{{#ifsysop:1|0}}+{{#ifeq: {{#cargo_query:tables=ARCHIUM_TABLE_access_restriction|fields=ARCHIUM_PROPERTY_access_restriction|no html|default=|where="_pageName"='DFA'}}|frei|1|0}}}}<1|AND r."ARCHIUM_PROPERTY_access_restriction" = 'frei'|}}
 |format=dynamic table