Template:GCXI Folder DisplayFormat - Revision history

WikiSysop at 14:01, June 3, 2022

2022-06-03T14:01:16Z

WikiSysop at 13:46, June 3, 2022

2022-06-03T13:46:05Z

WikiSysop at 13:30, June 3, 2022

2022-06-03T13:30:54Z

WikiSysop at 13:15, June 3, 2022

2022-06-03T13:15:55Z

WikiSysop at 19:15, May 4, 2022

2022-05-04T19:15:36Z

WikiSysop at 19:00, May 4, 2022

2022-05-04T19:00:39Z

WikiSysop at 18:45, May 4, 2022

2022-05-04T18:45:42Z

WikiSysop at 18:30, May 4, 2022

2022-05-04T18:30:42Z

WikiSysop at 18:15, May 4, 2022

2022-05-04T18:15:32Z

WikiSysop at 14:01, May 4, 2022

2022-05-04T14:01:06Z

@@ Line 13: / Line 13: @@
 {{ColumnFormat|cols=3|content=
 {{#cargo_query:
-tables=GCXI_Metric,GCXI_Metric__displaysInFolder
+tables=GCXI_Metric,GCXI_Metric__displaysInFolder,GCXI_Metric__displaysInFolder_Premise,GCXI_Metric__displaysInFolder_Cloud
-|join on=GCXI_Metric._ID=GCXI_Metric__displaysInFolder._rowID
+|join on=GCXI_Metric._ID=GCXI_Metric__displaysInFolder._rowID,GCXI_Metric._ID=GCXI_Metric__displaysInFolder_Premise._rowID,GCXI_Metric._ID=GCXI_Metric__displaysInFolder_Cloud._rowID
 |fields=CONCAT( '[[{{FULLPAGENAME}}Metrics',IF( (GCXI_Metric.anchor IS NOT NULL),CONCAT('#',GCXI_Metric.anchor),''),'|',GCXI_Metric.displayName,']]' )
-|where=(GCXI_Metric._pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/%%" AND GCXI_Metric.folder LIKE "{{{folderName}}}") OR (GCXI_Metric._pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/%%" AND GCXI_Metric__displaysInFolder._value LIKE "{{{folderName}}}") {{#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/%%" AND ({{#switch: {{#explode:{{FULLPAGENAME}}|/|2}} | GCXIPRG = (GCXI_Metric.premise IS NULL OR GCXI_Metric.premise NOT LIKE "no") AND (GCXI_Metric.folder LIKE "{{{folderName}}}" OR IF(GCXI_Metric__displaysInFolder_Premise._value IS NOT NULL,GCXI_Metric__displaysInFolder_Premise._value LIKE "{{{folderName}}}",GCXI_Metric__displaysInFolder._value LIKE "{{{folderName}}}"))
 |group by=GCXI_Metric.displayName
 |default=* There are no metrics in this folder
@@ Line 27: / Line 28: @@
 {{ColumnFormat|cols=3|content=
 {{#cargo_query:
-tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder
+tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder,GCXI_Attribute__displaysInFolder_Premise,GCXI_Attribute__displaysInFolder_Cloud
-|join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID
+|join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID,GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder_Premise._rowID,GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder_Cloud._rowID
 |fields=CONCAT( '[[{{FULLPAGENAME}}Attributes',IF( (anchor IS NOT NULL),CONCAT('#',anchor),''),'|',attr,']]' )
-|where=(GCXI_Attribute._pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/%%" AND GCXI_Attribute.folder LIKE "{{{folderName}}}") OR (GCXI_Attribute._pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/%%") AND GCXI_Attribute__displaysInFolder._value LIKE "{{{folderName}}}" {{#switch: {{#explode:{{FULLPAGENAME}}|/|2}} | GCXIMCPRG = AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL) | GCXIPRG = AND (GCXI_Attribute.premise LIKE "yes" OR GCXI_Attribute.premise IS NULL) | #default= }}
+|where=GCXI_Attribute._pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/%%" AND ({{#switch: {{#explode:{{FULLPAGENAME}}|/|2}} | GCXIPRG = (GCXI_Attribute.premise IS NULL OR GCXI_Attribute.premise NOT LIKE "no") AND (GCXI_Attribute.folder LIKE "{{{folderName}}}" OR IF(GCXI_Attribute__displaysInFolder_Premise._value IS NOT NULL,GCXI_Attribute__displaysInFolder_Premise._value LIKE "{{{folderName}}}",GCXI_Attribute__displaysInFolder._value LIKE "{{{folderName}}}"))
 |default=* There are no attributes in this folder.
 |group by=GCXI_Attribute.attr

@@ Line 52: / Line 52: @@
 {{ColumnFormat|cols=3|content=
 {{#cargo_query:
-tables=GCXI_Metric,GCXI_Metric__displaysInFolder
+tables=GCXI_Metric,GCXI_Metric__displaysInFolder,GCXI_Metric__displaysInFolder_Premise,GCXI_Metric__displaysInFolder_Cloud
-|join on=GCXI_Metric._ID=GCXI_Metric__displaysInFolder._rowID
+|join on=GCXI_Metric._ID=GCXI_Metric__displaysInFolder._rowID,GCXI_Metric._ID=GCXI_Metric__displaysInFolder_Premise._rowID,GCXI_Metric._ID=GCXI_Metric__displaysInFolder_Cloud._rowID
 |fields=CONCAT( '[[{{FULLPAGENAME}}Metrics',IF( (GCXI_Metric.anchor IS NOT NULL),CONCAT('#',GCXI_Metric.anchor),''),'|',GCXI_Metric.displayName,']]' )
-|where=((GCXI_Metric._pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/%%" AND GCXI_Metric.folder LIKE "{{{folderName}}}") OR (GCXI_Metric._pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/%%") AND GCXI_Metric__displaysInFolder._value LIKE "{{{folderName}}}") {{#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/%%" AND ({{#switch: {{#explode:{{FULLPAGENAME}}|/|2}} | GCXIPRG = (GCXI_Metric.premise IS NULL OR GCXI_Metric.premise NOT LIKE "no") AND (GCXI_Metric.folder LIKE "{{{folderName}}}" OR IF(GCXI_Metric__displaysInFolder_Premise._value IS NOT NULL,GCXI_Metric__displaysInFolder_Premise._value LIKE "{{{folderName}}}",GCXI_Metric__displaysInFolder._value LIKE "{{{folderName}}}"))
 |group by=GCXI_Metric.displayName
 |default=* There are no metrics in this folder

@@ Line 66: / Line 66: @@
 {{ColumnFormat|cols=3|content=
 {{#cargo_query:
-tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder
+tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder,GCXI_Attribute__displaysInFolder_Premise,GCXI_Attribute__displaysInFolder_Cloud
-|join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID
+|join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID,GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder_Premise._rowID,GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder_Cloud._rowID
 |fields=CONCAT( '[[{{FULLPAGENAME}}Attributes',IF( (anchor IS NOT NULL),CONCAT('#',anchor),''),'|',attr,']]' )
 |where=GCXI_Attribute._pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/%%" AND ({{#switch: {{#explode:{{FULLPAGENAME}}|/|2}} | GCXIPRG = (GCXI_Attribute.premise IS NULL OR GCXI_Attribute.premise NOT LIKE "no") AND (GCXI_Attribute.folder LIKE "{{{folderName}}}" OR IF(GCXI_Attribute__displaysInFolder_Premise._value IS NOT NULL,GCXI_Attribute__displaysInFolder_Premise._value LIKE "{{{folderName}}}",GCXI_Attribute__displaysInFolder._value LIKE "{{{folderName}}}"))

@@ Line 69: / Line 69: @@
 |join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID
 |fields=CONCAT( '[[{{FULLPAGENAME}}Attributes',IF( (anchor IS NOT NULL),CONCAT('#',anchor),''),'|',attr,']]' )
-|where=((GCXI_Attribute._pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/%%" AND GCXI_Attribute.folder LIKE "{{{folderName}}}") OR (GCXI_Attribute._pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/%%") AND GCXI_Attribute__displaysInFolder._value LIKE "{{{folderName}}}") {{#switch: {{#explode:{{FULLPAGENAME}}|/|2}} | GCXIMCPRG = AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL) | GCXIPRG = AND (GCXI_Attribute.premise LIKE "yes" OR GCXI_Attribute.premise IS NULL) | #default= }}
+|where=GCXI_Attribute._pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/%%" AND ({{#switch: {{#explode:{{FULLPAGENAME}}|/|2}} | GCXIPRG = (GCXI_Attribute.premise IS NULL OR GCXI_Attribute.premise NOT LIKE "no") AND (GCXI_Attribute.folder LIKE "{{{folderName}}}" OR IF(GCXI_Attribute__displaysInFolder_Premise._value IS NOT NULL,GCXI_Attribute__displaysInFolder_Premise._value LIKE "{{{folderName}}}",GCXI_Attribute__displaysInFolder._value LIKE "{{{folderName}}}"))
 |default=* There are no attributes in this folder.
 |group by=GCXI_Attribute.attr

@@ Line 69: / Line 69: @@
 |join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID
 |fields=CONCAT( '[[{{FULLPAGENAME}}Attributes',IF( (anchor IS NOT NULL),CONCAT('#',anchor),''),'|',attr,']]' )
-|where=(GCXI_Attribute._pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/%%" AND GCXI_Attribute.folder LIKE "{{{folderName}}}") OR (GCXI_Attribute._pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/%%" AND GCXI_Attribute__displaysInFolder._value LIKE "{{{folderName}}}") {{#switch: {{#explode:{{FULLPAGENAME}}|/|2}} | GCXIMCPRG = AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL) | GCXIPRG = AND (GCXI_Attribute.premise LIKE "yes" OR GCXI_Attribute.premise IS NULL) | #default= }}
+|where=((GCXI_Attribute._pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/%%" AND GCXI_Attribute.folder LIKE "{{{folderName}}}") OR (GCXI_Attribute._pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/%%") AND GCXI_Attribute__displaysInFolder._value LIKE "{{{folderName}}}") {{#switch: {{#explode:{{FULLPAGENAME}}|/|2}} | GCXIMCPRG = AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL) | GCXIPRG = AND (GCXI_Attribute.premise LIKE "yes" OR GCXI_Attribute.premise IS NULL) | #default= }}
 |default=* There are no attributes in this folder.
 |group by=GCXI_Attribute.attr