Template:GCXI Metrics DisplayList - Revision history

WikiSysop at 16:00, May 12, 2022

2022-05-12T16:00:50Z

WikiSysop at 13:45, May 12, 2022

2022-05-12T13:45:48Z

WikiSysop at 16:00, May 3, 2022

2022-05-03T16:00:27Z

WikiSysop at 15:45, May 3, 2022

2022-05-03T15:45:26Z

WikiSysop at 15:00, May 3, 2022

2022-05-03T15:00:26Z

WikiSysop at 14:45, May 3, 2022

2022-05-03T14:45:25Z

WikiSysop at 14:30, May 3, 2022

2022-05-03T14:30:22Z

WikiSysop at 14:15, May 3, 2022

2022-05-03T14:15:22Z

WikiSysop at 20:30, April 29, 2022

2022-04-29T20:30:34Z

WikiSysop at 20:15, April 29, 2022

2022-04-29T20:15:36Z

@@ Line 8: / Line 8: @@
 |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}}}")
+|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= }}
 |group by=GCXI_Metric.displayName
 |default=* There are no metrics in this folder
@@ Line 24: / Line 23: @@
 |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:{{{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= }}
+|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= }}
 |group by=GCXI_Metric.displayName
 |default=* There are no metrics in this folder

@@ Line 24: / Line 24: @@
 |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}}}")
+|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:{{{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= }}
 |group by=GCXI_Metric.displayName
 |default=* There are no metrics in this folder

@@ Line 9: / Line 9: @@
 |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= }})
+{{#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= }}
 |group by=GCXI_Metric.displayName
 |default=* There are no metrics in this folder
@@ Line 25: / Line 25: @@
 |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= }})
+{{#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= }}
 |group by=GCXI_Metric.displayName
 |default=* There are no metrics in this folder

@@ Line 9: / Line 9: @@
 |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= }}
+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
@@ Line 25: / Line 25: @@
 |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= }}
+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

@@ Line 25: / Line 25: @@
 |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= }}
+{{#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