Testseite5: Unterschied zwischen den Versionen

Aus DFA
Wechseln zu:Navigation, Suche
K (Textersetzung - „._ID“ durch „._pageName“)
 
(16 dazwischenliegende Versionen von einem anderen Benutzer werden nicht angezeigt)
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_maingroup_priority=mgp
ARCHIUM_TABLE_content_general=d,
+
|join on=mg._pageName = mgp._pageName
ARCHIUM_TABLE_content_special=e,
+
|fields=CONCAT("ARCHIUM_PROPERTY_maingroup_priority",'. ',"ARCHIUM_PROPERTY_maingroup_assignment")=Hauptgruppe,
ARCHIUM_TABLE_extentmedium=f,
+
ARCHIUM_PROPERTY_maingroup_priority=HGPrio,
ARCHIUM_TABLE_note=note,
+
ARCHIUM_PROPERTY_maingroup_assignment=HGName
|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
+
|where=mg."_pageName" LIKE 'DFA-%'
|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
 
|format=template
 
|named args=yes
 
|named args=yes
|template=ARCHIUM_QUERY_MASK_test5
+
|template=DFA_QUERY_Klassifikation
 
|rows per page=50
 
|rows per page=50
|limit=5000
+
|limit=500
|parent field=Titel
+
|order by=mgp."ARCHIUM_PROPERTY_maingroup_priority" ASC
|searchable columns=Titel, Enthält, Darin, Umfang
+
|group by=mg."ARCHIUM_PROPERTY_maingroup_assignment",mgp."ARCHIUM_PROPERTY_maingroup_priority"
|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"
 
|default=Kein Suchergebnis
 
|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>
 
 
}}
 
}}

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