Template: GCXI Metrics DisplayList

Subordinate query template to supplement Template:GCXI_Metrics_Display, to get the list of links that displays at the top of Metrics pages in the GCXI Project Guide. The lists include metrics specified both directly and indirectly (via displaysInFolder).

Content is:

'''{{{folder}}}'''<br/>
{{#cargo_query:
tables=GCXI_Metric,GCXI_Metric__displaysInFolder
|join on=GCXI_Metric._ID=GCXI_Metric__displaysInFolder._rowID
|fields=CONCAT( '[[{{{page}}}#',GCXI_Metric.anchor,'|',GCXI_Metric.displayName,']]')=metric
|where=GCXI_Metric._pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Metric.folder LIKE "{{{folder}}}" OR GCXI_Metric__displaysInFolder._value LIKE "{{{folder}}}") 
{{#switch: {{#explode:{{FULLPAGENAME}}|/|2}} | GCXIMCPRG = AND NOT GCXI_Metric.cloud="no" | GCXIPRG = AND NOT GCXI_Metric.premise="no" | #default= }}
|group by=GCXI_Metric.displayName
|default=* There are no metrics in this folder
|format=ul
|order by=displayName ASC
}}

{{{folder}}}