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_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
 |named args=yes
 |template=DFA_QUERY_Klassifikation
 |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>
 }}