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}}}")
AND ({{#switch: {{#explode:{{FULLPAGENAME}}|/|2}} | GCXIMCPRG = GCXI_Metric.cloud LIKE "yes" OR GCXI_Metric.cloud IS NULL | GCXIPRG = GCXI_Metric.premise LIKE "yes" OR GCXI_Metric.premise IS NULL | #default= }})
|group by=GCXI_Metric.displayName
|default=* There are no metrics in this folder
|format=ul
|order by=displayName ASC
}}
{{{folder}}}
Query: SELECT CONCAT( '[[{{{page}}}#',`cargo__GCXI_Metric`.`anchor`,'|',`cargo__GCXI_Metric`.`displayName`,']]') AS `metric` FROM `cargo__GCXI_Metric` LEFT OUTER JOIN `cargo__GCXI_Metric__displaysInFolder` ON ((`cargo__GCXI_Metric`.`_ID`=`cargo__GCXI_Metric__displaysInFolder`.`_rowID`)) WHERE `cargo__GCXI_Metric`.`_pageName` LIKE "PEC-REP/Library/GCXIPRGLibrary/%%" AND (`cargo__GCXI_Metric`.`folder` LIKE "{{{folder}}}" OR `cargo__GCXI_Metric__displaysInFolder`.`_value` LIKE "{{{folder}}}") AND () GROUP BY `cargo__GCXI_Metric`.`displayName` ORDER BY `displayName` LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY `cargo__GCXI_Metric`.`displayName` ORDER BY `displayName` LIMIT 100' at line 2 (127.0.0.1)