Testseite5: Unterschied zwischen den Versionen

Aktuelle Version vom 17. Dezember 2019, 22:16 Uhr

Vorlage:DFA QUERY Klassifikation Vorlage:DFA QUERY Klassifikation Vorlage:DFA QUERY Klassifikation Vorlage:DFA QUERY Klassifikation Vorlage:DFA QUERY Klassifikation Vorlage:DFA QUERY Klassifikation Vorlage:DFA QUERY Klassifikation Vorlage:DFA QUERY Klassifikation Vorlage:DFA QUERY Klassifikation Vorlage:DFA QUERY Klassifikation Vorlage:DFA QUERY Klassifikation Vorlage:DFA QUERY Klassifikation Vorlage:DFA QUERY Klassifikation Vorlage:DFA QUERY Klassifikation

@@ Zeile 1: / Zeile 1: @@
-{{#cargo_query: tables=ARCHIUM_TABLE_date_of_creation1=a,
+__NOTOC__
-ARCHIUM_TABLE_title=b,
+{{#cargo_query: tables=ARCHIUM_TABLE_maingroup=mg,
-ARCHIUM_TABLE_signature=c,
-ARCHIUM_TABLE_content_general=d,
-ARCHIUM_TABLE_content_special=e,
-ARCHIUM_TABLE_extentmedium=f,
-ARCHIUM_TABLE_note=note,
-|join on=a._pageName = b._pageName, a._pageName = c._pageName, a._pageName = d._pageName, a._pageName = e._pageName, a._pageName = f._pageName, a._pageName=note._pageName
-|fields=CONCAT( '[[', "ARCHIUM_PROPERTY_signature" ,']]' )=Signatur,STRING_AGG("ARCHIUM_PROPERTY_dateString",';')=Laufzeiten,ARCHIUM_PROPERTY_title=Titel,ARCHIUM_PROPERTY_content_general=Enthält,ARCHIUM_PROPERTY_content_special=Darin,ARCHIUM_PROPERTY_sizeMedium=Umfang,ARCHIUM_PROPERTY_note=Anmerkung
-|where=a."_pageName" LIKE 'DFA-%' AND ARRAY[1,4,3] && ARRAY[2,1]
-|format=template
-|named args=yes
-|template=DFA_QUERY_Klassifikation
-|rows per page=50
-|limit=5000
-|parent field=Titel
-|searchable columns=Titel, Enthält, Darin, Umfang
-|order by=ARCHIUM_PROPERTY_ID
-|group by="ARCHIUM_PROPERTY_title","ARCHIUM_PROPERTY_signature","ARCHIUM_PROPERTY_ID","ARCHIUM_PROPERTY_content_general","ARCHIUM_PROPERTY_content_special","ARCHIUM_PROPERTY_sizeMedium","ARCHIUM_PROPERTY_note"
-}}
-==Ordnung in Reihenfolge der Klassifikation==
-{{#cargo_query:
-ARCHIUM_TABLE_maingroup=mg,
 ARCHIUM_TABLE_maingroup_priority=mgp
-|join on=mg._ID = mgp._ID
+|join on=mg._pageName = mgp._pageName
 |fields=CONCAT("ARCHIUM_PROPERTY_maingroup_priority",'. ',"ARCHIUM_PROPERTY_maingroup_assignment")=Hauptgruppe,
 ARCHIUM_PROPERTY_maingroup_priority=HGPrio,
-|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'|}}
+ARCHIUM_PROPERTY_maingroup_assignment=HGName
+|where=mg."_pageName" LIKE 'DFA-%'
 |format=template
 |named args=yes
 |template=DFA_QUERY_Klassifikation
-|searchable columns=
+|rows per page=50
-|rows per page=500
 |limit=500
 |order by=mgp."ARCHIUM_PROPERTY_maingroup_priority" ASC
-<!--|default=Kein Suchergebnis
+|group by=mg."ARCHIUM_PROPERTY_maingroup_assignment",mgp."ARCHIUM_PROPERTY_maingroup_priority"
-|intro={{ARCHIUM TEMPLATE highlightresults.js}}<html><input type="button" value="Highlight results" onClick="highlightSearchTerms('</html>{{#var:SUCHWORT4}}<html>');"><br></html>
-|outro=<html><input type="button" value="Highlight results" onClick="highlightSearchTerms('</html>{{#var:SUCHWORT4}}<html>');"></html>-->
 }}