DFA-Bestandsordnung: Unterschied zwischen den Versionen
| 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 | |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, | |fields=CONCAT("ARCHIUM_PROPERTY_maingroup_priority",'. ',"ARCHIUM_PROPERTY_maingroup_assignment")=Hauptgruppe, | ||
| − | CONCAT( '[[', | + | t."_pageName"=Link |
| + | CONCAT( '[[',"ARCHIUM_PROPERTY_signature",']] ', "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'|}} | |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 | |format=dynamic table | ||
| − | |details fields=Übersicht | + | |details fields=Link,Übersicht |
|searchable columns=Titel, Laufzeiten | |searchable columns=Titel, Laufzeiten | ||
|rows per page=500 | |rows per page=500 | ||
Version vom 15. Dezember 2019, 22:31 Uhr
Ordnung in Reihenfolge der Klassifikation
Query: SELECT CONCAT("ARCHIUM_PROPERTY_maingroup_priority",'. ',"ARCHIUM_PROPERTY_maingroup_assignment") AS "Hauptgruppe",t."_pageName"=Link CONCAT( '',"ARCHIUM_PROPERTY_signature",' ', "ARCHIUM_PROPERTY_title", ' ',"ARCHIUM_PROPERTY_dateString", ' ')=Übersicht AS """ pageName""=Link CONCAT( '',""ARCHIUM PROPERTY signature"",' ', ""ARCHIUM PROPERTY title"", ' ',""ARCHIUM PROPERTY dateString"", ' ')=Ü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: 42601 FEHLER: Syntaxfehler bei »(« LINE 2: CONCAT( '',"ARCHIUM_PROPERTY_signature",' ', "ARCHIUM_PR...
^