DFA-Bestandsordnung: Unterschied zwischen den Versionen
Aus DFA
| Zeile 1: | Zeile 1: | ||
{{DISPLAYTITLE:Bestandsordnung}} | {{DISPLAYTITLE:Bestandsordnung}} | ||
| − | ==Ordnung in Reihenfolge der | + | ==Ordnung in Reihenfolge der Klassifikation== |
{{#cargo_query: tables=ARCHIUM_TABLE_signature=s, | {{#cargo_query: tables=ARCHIUM_TABLE_signature=s, | ||
ARCHIUM_TABLE_title=t, | ARCHIUM_TABLE_title=t, | ||
| Zeile 7: | Zeile 7: | ||
ARCHIUM_TABLE_maingroup_priority=mgp, | ARCHIUM_TABLE_maingroup_priority=mgp, | ||
ARCHIUM_TABLE_date_of_creation1=d | ARCHIUM_TABLE_date_of_creation1=d | ||
| − | |join on=s. | + | ARCHIUM_TABLE_access_restriction=e |
| + | |join on=s._ID = mg._ID, s._ID = mgp._ID, s._ID = t._ID,s._ID = d._ID,s._ID=e._ID | ||
|fields=CONCAT( '[[', "ARCHIUM_PROPERTY_signature" ,']]' )=Signatur, | |fields=CONCAT( '[[', "ARCHIUM_PROPERTY_signature" ,']]' )=Signatur, | ||
ARCHIUM_PROPERTY_title=Titel, | ARCHIUM_PROPERTY_title=Titel, | ||
| Zeile 13: | 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 d."ARCHIUM_PROPERTY_access_restriction" = 'frei'|}} |
|format=tree | |format=tree | ||
|searchable columns=title | |searchable columns=title | ||
Version vom 15. Dezember 2019, 15:33 Uhr
Ordnung in Reihenfolge der Klassifikation
Error: table "d" is not in list of table names.
<1|AND d."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 }}