DFA-Bestandsordnung: Unterschied zwischen den Versionen

Aus DFA
Wechseln zu:Navigation, Suche
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
ARCHIUM_TABLE_access_restriction=e
+
ARCHIUM_TABLE_access_restriction=r
|join on=s._ID = mg._ID, s._ID = mgp._ID, s._ID = t._ID,s._ID = d._ID,s._ID=e._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_signature" ,']]' )=Signatur,
 
|fields=CONCAT( '[[', "ARCHIUM_PROPERTY_signature" ,']]' )=Signatur,
 
ARCHIUM_PROPERTY_title=Titel,
 
ARCHIUM_PROPERTY_title=Titel,
Zeile 14: Zeile 14:
 
ARCHIUM_PROPERTY_dateString=Laufzeiten
 
ARCHIUM_PROPERTY_dateString=Laufzeiten
 
|parent field=Hauptgruppe
 
|parent field=Hauptgruppe
|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'|}}
+
|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:34 Uhr


Ordnung in Reihenfolge der Klassifikation

Error: table "d" is not in list of table names.

<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 }}