Template: GCXI Metrics DisplayDetails

Subordinate query template to supplement Template:GCXI_Metrics_Display, to get details to display, by subfolder, on Metrics pages in the GCXI Project Guide. The details include metrics specified both directly and indirectly (via displaysInFolder). The template uses Template:GCXI_Metrics_DisplayFormat to format the output.

Content is:

==Folder: {{{folder}}}==
{{#cargo_query:
tables=GCXI_Metric,GCXI_Metric__displaysInFolder
|join on=GCXI_Metric._ID=GCXI_Metric__displaysInFolder._rowID
|fields=GCXI_Metric.metric=metric,GCXI_Metric.displayName=displayName,GCXI_Metric.shortDesc=shortDesc,GCXI_Metric.longDesc=longDesc,GCXI_Metric.type=type,GCXI_Metric.mediaType=mediaType,GCXI_Metric.dataType=dataType,REPLACE('{{{folder}}}','>','>')=displayFolder,GCXI_Metric.internalMetricID=internalMetricID,GCXI_Metric.dbTable=dbTable,GCXI_Metric.calculation=calculation,GCXI_Metric._ID=MetricID,GCXI_Metric.project=project,GCXI_Metric.notproject=notproject,GCXI_Metric.introduced=introduced,GCXI_Metric.modified=modified,GCXI_Metric.discontinued=discontinued,GCXI_Metric.anchor=anchor,CONCAT('{{{page}}}')=page
|where=GCXI_Metric._pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/%%" AND ((GCXI_Metric.folder="{{{folder}}}" OR GCXI_Metric__displaysInFolder._value="{{{folder}}}")) AND NOT GCXI_Metric.cloud="no" 
|limit=2000
|default=There are no metrics in this folder.
|format=template
|template={{#if:{{{formatTemplate|}}}|{{{formatTemplate}}}|GCXI_Metrics_DisplayFormat}}
|named args=yes
|group by=GCXI_Metric.displayName
|order by=GCXI_Metric.displayName
}}

Folder: {{{folder}}}

There are no metrics in this folder.