Template:GCXI Metrics DisplayDetails - Revision history

WikiSysop at 16:15, May 12, 2022

2022-05-12T16:15:44Z

WikiSysop at 16:00, May 3, 2022

2022-05-03T16:00:25Z

WikiSysop at 14:45, May 3, 2022

2022-05-03T14:45:23Z

WikiSysop at 17:45, April 29, 2022

2022-04-29T17:45:28Z

WikiSysop at 17:30, April 29, 2022

2022-04-29T17:30:35Z

WikiSysop at 17:15, April 29, 2022

2022-04-29T17:15:39Z

WikiSysop at 14:16, April 14, 2022

2022-04-14T14:16:05Z

WikiSysop: Created page with "Subordinate query template to supplement Template:GCXI_Metrics_Display, to get details to display, by subfolder, on Metrics pages in the GCXI Project Guide. Th..."

2022-04-13T15:00:33Z

Created page with "<noinclude>Subordinate query template to supplement Template:GCXI_Metrics_Display, to get details to display, by subfolder, on Metrics pages in the GCXI Project Guide. Th..."

New page

<noinclude>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:
<source lang="xml">
==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/{{#explode:{{FULLPAGENAME}}|/|3}}" AND (GCXI_Metric.folder="{{{folder}}}" OR GCXI_Metric__displaysInFolder._value="{{{folder}}}")
|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
}}
</source>
</noinclude>

<onlyinclude>
==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/{{#explode:{{FULLPAGENAME}}|/|3}}" AND (GCXI_Metric.folder="{{{folder}}}" OR GCXI_Metric__displaysInFolder._value="{{{folder}}}")
|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
}}
</onlyinclude>

<noinclude>[[Category:GCXI]] [[Category:Cargo_queries]]</noinclude>

@@ Line 8: / Line 8: @@
 |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}}}','&gt;','>')=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}}}")) {{#switch: {{#explode:{{FULLPAGENAME}}|/|2}} | GCXIMCPRG = AND (GCXI_Metric.cloud LIKE "yes" OR GCXI_Metric.cloud IS NULL) | GCXIPRG = AND (GCXI_Metric.premise LIKE "yes" OR GCXI_Metric.premise IS NULL) | #default= }}
+|where=GCXI_Metric._pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/%%"{{#switch:{{#explode:{{{page}}}|/|2}} | GCXIMCPRG = AND (GCXI_Metric.cloud LIKE "yes" OR GCXI_Metric.cloud IS NULL) AND IF(GCXI_Metric.displaysInFolder_Cloud HOLDS LIKE "%%",(GCXI_Metric.folder LIKE "{{{folder}}}" OR GCXI_Metric.displaysInFolder_Cloud HOLDS LIKE "{{{folder}}}"),(GCXI_Metric.folder LIKE "{{{folder}}}" OR GCXI_Metric.displaysInFolder HOLDS LIKE "{{{folder}}}")) | GCXIPRG = AND (GCXI_Metric.premise LIKE "yes" OR GCXI_Metric.premise IS NULL) AND IF(GCXI_Metric.displaysInFolder_Premise HOLDS LIKE "%%",(GCXI_Metric.folder LIKE "{{{folder}}}" OR GCXI_Metric.displaysInFolder_Premise HOLDS LIKE "{{{folder}}}"),(GCXI_Metric.folder LIKE "{{{folder}}}" OR GCXI_Metric.displaysInFolder HOLDS LIKE "{{{folder}}}")) | #default= }}
 |limit=2000
 |default=There are no metrics in this folder.
@@ Line 26: / Line 26: @@
 |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}}}','&gt;','>')=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}}}")) {{#switch: {{#explode:{{FULLPAGENAME}}|/|2}} | GCXIMCPRG = AND (GCXI_Metric.cloud LIKE "yes" OR GCXI_Metric.cloud IS NULL) | GCXIPRG = AND (GCXI_Metric.premise LIKE "yes" OR GCXI_Metric.premise IS NULL) | #default= }}
+|where=GCXI_Metric._pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/%%"{{#switch:{{#explode:{{{page}}}|/|2}} | GCXIMCPRG = AND (GCXI_Metric.cloud LIKE "yes" OR GCXI_Metric.cloud IS NULL) AND IF(GCXI_Metric.displaysInFolder_Cloud HOLDS LIKE "%%",(GCXI_Metric.folder LIKE "{{{folder}}}" OR GCXI_Metric.displaysInFolder_Cloud HOLDS LIKE "{{{folder}}}"),(GCXI_Metric.folder LIKE "{{{folder}}}" OR GCXI_Metric.displaysInFolder HOLDS LIKE "{{{folder}}}")) | GCXIPRG = AND (GCXI_Metric.premise LIKE "yes" OR GCXI_Metric.premise IS NULL) AND IF(GCXI_Metric.displaysInFolder_Premise HOLDS LIKE "%%",(GCXI_Metric.folder LIKE "{{{folder}}}" OR GCXI_Metric.displaysInFolder_Premise HOLDS LIKE "{{{folder}}}"),(GCXI_Metric.folder LIKE "{{{folder}}}" OR GCXI_Metric.displaysInFolder HOLDS LIKE "{{{folder}}}")) | #default= }}
 |limit=2000
 |default=There are no metrics in this folder.