DFA-Bestandsordnung: Unterschied zwischen den Versionen
| Zeile 14: | Zeile 14: | ||
ARCHIUM_PROPERTY_dateString=Laufzeiten | ARCHIUM_PROPERTY_dateString=Laufzeiten | ||
|parent field=Hauptgruppe | |parent field=Hauptgruppe | ||
| − | |where=s."_pageName" LIKE 'DFA-%' | + | |where=s."_pageName" LIKE 'DFA-%' {{#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=tree | |format=tree | ||
|searchable columns=title | |searchable columns=title | ||
Version vom 15. Dezember 2019, 15:35 Uhr
Ordnung in Reihenfolge der Klassifikation
Query: SELECT CONCAT( '', "ARCHIUM_PROPERTY_signature" ,'' ) AS "Signatur","ARCHIUM_PROPERTY_title" AS "Titel","ARCHIUM_PROPERTY_maingroup_assignment" AS "Hauptgruppe","ARCHIUM_PROPERTY_dateString" AS "Laufzeiten" 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-%' 0+1 ORDER BY CONCAT( '', "ARCHIUM_PROPERTY_signature" ,'' ),"ARCHIUM_PROPERTY_title","ARCHIUM_PROPERTY_maingroup_assignment","ARCHIUM_PROPERTY_dateString" LIMIT 100 Function: CargoSQLQuery::run Error: 42601 FEHLER: Syntaxfehler bei »0« LINE 1: ...D"="r"."_ID")) WHERE s."_pageName" LIKE 'DFA-%' 0+1 ORDER...
^
<1| AND r."ARCHIUM_PROPERTY_access_restriction" = 'frei'|}}
|format=tree |searchable columns=title |rows per page=500 |limit=500 |order by=mgp."ARCHIUM_PROPERTY_maingroup_priority" ASC,s."ARCHIUM_PROPERTY_ID" ASC }}