WikiSysop at 14:31, May 12, 2022

2022-05-12T14:31:05Z

WikiSysop: Created page with "==Baseline to test GCXI_Metric__displaysInFolder._value vs. displaysInFolder HOLDS== ===GCXI_Metric__displaysInFolder._value LIKE "iWD > Agent"=== Existing query looking for p..."

2022-05-12T14:15:45Z

Created page with "==Baseline to test GCXI_Metric__displaysInFolder._value vs. displaysInFolder HOLDS== ===GCXI_Metric__displaysInFolder._value LIKE "iWD > Agent"=== Existing query looking for p..."

New page

==Baseline to test GCXI_Metric__displaysInFolder._value vs. displaysInFolder HOLDS==
===GCXI_Metric__displaysInFolder._value LIKE "iWD > Agent"===
Existing query looking for pageName AND (GCXI_Metric.folder LIKE "iWD > Agent" OR GCXI_Metric__displaysInFolder._value LIKE "iWD > Agent") AND (GCXI_Metric.cloud LIKE "yes" OR GCXI_Metric.cloud IS NULL) -- 9 results
{{#cargo_query:
tables=GCXI_Metric,GCXI_Metric__displaysInFolder
|join on=GCXI_Metric._ID=GCXI_Metric__displaysInFolder._rowID
|fields=CONCAT( '[[{{FULLPAGENAME}}#',GCXI_Metric.anchor,'|',GCXI_Metric.metric,']]')=metric,GCXI_Metric.folder=folder,GCXI_Metric.displaysInFolder__full=displaysInFolder,GCXI_Metric.displaysInFolder_Cloud__full=displaysInFolder_Cloud,GCXI_Metric.cloud=cloud
|where=GCXI_Metric._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Metric.folder LIKE "iWD > Agent" OR GCXI_Metric__displaysInFolder._value LIKE "iWD > Agent") AND (GCXI_Metric.cloud LIKE "yes" OR GCXI_Metric.cloud IS NULL)
|group by=GCXI_Metric.metric
|intro=Existing query for GCXIMCPRG:
|default=* There are no Metrics in this folder
|format=table
|order by=GCXI_Metric.metric ASC
}}

===GCXI_Metric.displaysInFolder HOLDS LIKE "iWD > Agent"===
Looking for pagename AND (GCXI_Metric.folder LIKE "iWD > Agent" OR GCXI_Metric.displaysInFolder HOLDS LIKE "iWD > Agent") AND (GCXI_Metric.cloud LIKE "yes" OR GCXI_Metric.cloud IS NULL) -- 9 results
{{#cargo_query:
tables=GCXI_Metric,GCXI_Metric__displaysInFolder
|join on=GCXI_Metric._ID=GCXI_Metric__displaysInFolder._rowID
|fields=CONCAT( '[[{{FULLPAGENAME}}#',GCXI_Metric.anchor,'|',GCXI_Metric.metric,']]')=metric,GCXI_Metric.folder=folder,GCXI_Metric.displaysInFolder__full=displaysInFolder,GCXI_Metric.displaysInFolder_Cloud__full=displaysInFolder_Cloud,GCXI_Metric.cloud=cloud
|where=GCXI_Metric._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Metric.folder LIKE "iWD > Agent" OR GCXI_Metric.displaysInFolder HOLDS LIKE "iWD > Agent") AND (GCXI_Metric.cloud LIKE "yes" OR GCXI_Metric.cloud IS NULL)
|group by=GCXI_Metric.metric
|intro=Trying to include folder=iWD > Agent and displaysInFolder=iWD > Agent:
|default=* There are no Metrics in this folder
|format=table
|order by=GCXI_Metric.metric ASC
}}

==Success?==
{{Editgrn_open}}IS THIS IT?{{Editgrn_close}}<br/>
Looking for pagename AND IF(GCXI_Metric.displaysInFolder_Cloud HOLDS LIKE "%%",(GCXI_Metric.folder LIKE "iWD > Agent" OR GCXI_Metric.displaysInFolder_Cloud HOLDS LIKE "iWD > Agent"),(GCXI_Metric.folder LIKE "iWD > Agent" OR GCXI_Metric.displaysInFolder HOLDS LIKE "iWD > Agent")) AND (GCXI_Metric.cloud LIKE "yes" OR GCXI_Metric.cloud IS NULL) -- no diffs if the interior IF clauses are not in brackets
{{#cargo_query:
tables=GCXI_Metric,GCXI_Metric__displaysInFolder
|join on=GCXI_Metric._ID=GCXI_Metric__displaysInFolder._rowID
|fields=CONCAT( '[[{{FULLPAGENAME}}#',GCXI_Metric.anchor,'|',GCXI_Metric.metric,']]')=metric,GCXI_Metric.folder=folder,GCXI_Metric.displaysInFolder__full=displaysInFolder,GCXI_Metric.displaysInFolder_Cloud__full=displaysInFolder_Cloud,GCXI_Metric.cloud=cloud
|where=GCXI_Metric._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND IF(GCXI_Metric.displaysInFolder_Cloud HOLDS LIKE "%%",(GCXI_Metric.folder LIKE "iWD > Agent" OR GCXI_Metric.displaysInFolder_Cloud HOLDS LIKE "iWD > Agent"),(GCXI_Metric.folder LIKE "iWD > Agent" OR GCXI_Metric.displaysInFolder HOLDS LIKE "iWD > Agent")) AND (GCXI_Metric.cloud LIKE "yes" OR GCXI_Metric.cloud IS NULL)
|format=table
|group by=GCXI_Metric.metric
|order by=GCXI_Metric.metric
}}

<hr>

==Testing iWD > Age==
{{#cargo_query:
tables=GCXI_Metric
|fields=CONCAT( '[[{{FULLPAGENAME}}#',GCXI_Metric.anchor,'|',GCXI_Metric.metric,']]')=metric,GCXI_Metric.folder=folder,GCXI_Metric.displaysInFolder__full=displaysInFolder,GCXI_Metric.displaysInFolder_Cloud__full=displaysInFolder_Cloud,GCXI_Metric.cloud=cloud
|where=GCXI_Metric._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND IF(GCXI_Metric.displaysInFolder_Cloud HOLDS LIKE "%%",(GCXI_Metric.folder LIKE "iWD > Age" OR GCXI_Metric.displaysInFolder_Cloud HOLDS LIKE "iWD > Age"),(GCXI_Metric.folder LIKE "iWD > Age" OR GCXI_Metric.displaysInFolder HOLDS LIKE "iWD > Age")) AND (GCXI_Metric.cloud LIKE "yes" OR GCXI_Metric.cloud IS NULL)
|format=table
|group by=GCXI_Metric.metric
|order by=GCXI_Metric.metric
}}

{{#cargo_query:
tables=GCXI_Metric,GCXI_Metric__displaysInFolder
|join on=GCXI_Metric._ID=GCXI_Metric__displaysInFolder._rowID
|fields=CONCAT( '[[{{FULLPAGENAME}}#',GCXI_Metric.anchor,'|',GCXI_Metric.metric,']]')=metric,GCXI_Metric.folder=folder,GCXI_Metric.displaysInFolder__full=displaysInFolder,GCXI_Metric.displaysInFolder_Cloud__full=displaysInFolder_Cloud,GCXI_Metric.cloud=cloud
|where=GCXI_Metric._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Metric.folder LIKE "iWD > Age" OR GCXI_Metric__displaysInFolder._value LIKE "iWD > Age") AND (GCXI_Metric.cloud LIKE "yes" OR GCXI_Metric.cloud IS NULL)
|group by=GCXI_Metric.metric
|intro=Existing query for GCXIMCPRG:
|default=* There are no Metrics in this folder
|format=table
|order by=GCXI_Metric.metric ASC
}}

<hr>

==Testing iWD > Classification==
{{#cargo_query:
tables=GCXI_Metric
|fields=CONCAT( '[[{{FULLPAGENAME}}#',GCXI_Metric.anchor,'|',GCXI_Metric.metric,']]')=metric,GCXI_Metric.folder=folder,GCXI_Metric.displaysInFolder__full=displaysInFolder,GCXI_Metric.displaysInFolder_Cloud__full=displaysInFolder_Cloud,GCXI_Metric.cloud=cloud
|where=GCXI_Metric._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND IF(GCXI_Metric.displaysInFolder_Cloud HOLDS LIKE "%%",(GCXI_Metric.folder LIKE "iWD > Classification" OR GCXI_Metric.displaysInFolder_Cloud HOLDS LIKE "iWD > Classification"),(GCXI_Metric.folder LIKE "iWD > Classification" OR GCXI_Metric.displaysInFolder HOLDS LIKE "iWD > Classification")) AND (GCXI_Metric.cloud LIKE "yes" OR GCXI_Metric.cloud IS NULL)
|format=table
|group by=GCXI_Metric.metric
|order by=GCXI_Metric.metric
}}

{{#cargo_query:
tables=GCXI_Metric,GCXI_Metric__displaysInFolder
|join on=GCXI_Metric._ID=GCXI_Metric__displaysInFolder._rowID
|fields=CONCAT( '[[{{FULLPAGENAME}}#',GCXI_Metric.anchor,'|',GCXI_Metric.metric,']]')=metric,GCXI_Metric.folder=folder,GCXI_Metric.displaysInFolder__full=displaysInFolder,GCXI_Metric.displaysInFolder_Cloud__full=displaysInFolder_Cloud,GCXI_Metric.cloud=cloud
|where=GCXI_Metric._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Metric.folder LIKE "iWD > Classification" OR GCXI_Metric__displaysInFolder._value LIKE "iWD > Classification") AND (GCXI_Metric.cloud LIKE "yes" OR GCXI_Metric.cloud IS NULL)
|group by=GCXI_Metric.metric
|intro=Existing query for GCXIMCPRG:
|default=* There are no Metrics in this folder
|format=table
|order by=GCXI_Metric.metric ASC
}}

<hr>
{{AnchorDiv|InstructiveFailures}}
==Instructive failures of logic and/or syntax==
Looking for pagename AND (GCXI_Metric.folder LIKE "iWD > Agent" OR GCXI_Metric.displaysInFolder_Cloud HOLDS LIKE "iWD > Agent" OR GCXI_Metric.displaysInFolder HOLDS LIKE "iWD > Agent") AND (GCXI_Metric.cloud LIKE "yes" OR GCXI_Metric.cloud IS NULL) -- 9 results
{{#cargo_query:
tables=GCXI_Metric,GCXI_Metric__displaysInFolder
|join on=GCXI_Metric._ID=GCXI_Metric__displaysInFolder._rowID
|fields=CONCAT( '[[{{FULLPAGENAME}}#',GCXI_Metric.anchor,'|',GCXI_Metric.metric,']]')=metric,GCXI_Metric.folder=folder,GCXI_Metric.displaysInFolder__full=displaysInFolder,GCXI_Metric.displaysInFolder_Cloud__full=displaysInFolder_Cloud,GCXI_Metric.cloud=cloud
|where=GCXI_Metric._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Metric.folder LIKE "iWD > Agent" OR GCXI_Metric.displaysInFolder_Cloud HOLDS LIKE "iWD > Agent" OR GCXI_Metric.displaysInFolder HOLDS LIKE "iWD > Agent") AND (GCXI_Metric.cloud LIKE "yes" OR GCXI_Metric.cloud IS NULL)
|format=table
|group by=GCXI_Metric.metric
|order by=GCXI_Metric.metric ASC
}}

Looking for pagename and (GCXI_Metric.folder LIKE "iWD > Agent" OR (GCXI_Metric.displaysInFolder_Cloud HOLDS LIKE "iWD > Agent" OR GCXI_Metric.displaysInFolder_Cloud HOLDS NOT "none" AND GCXI_Metric.displaysInFolder HOLDS LIKE "iWD > Agent")) AND (GCXI_Metric.cloud LIKE "yes" OR GCXI_Metric.cloud IS NULL) -- should be 7 results
{{#cargo_query:
tables=GCXI_Metric,GCXI_Metric__displaysInFolder
|join on=GCXI_Metric._ID=GCXI_Metric__displaysInFolder._rowID
|fields=CONCAT( '[[{{FULLPAGENAME}}#',GCXI_Metric.anchor,'|',GCXI_Metric.metric,']]')=metric,GCXI_Metric.folder=folder,GCXI_Metric.displaysInFolder__full=displaysInFolder,GCXI_Metric.displaysInFolder_Cloud__full=displaysInFolder_Cloud,GCXI_Metric.cloud=cloud
|where=GCXI_Metric._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Metric.folder LIKE "iWD > Agent" OR (GCXI_Metric.displaysInFolder_Cloud HOLDS LIKE "iWD > Agent" OR GCXI_Metric.displaysInFolder_Cloud HOLDS NOT "none" AND GCXI_Metric.displaysInFolder HOLDS LIKE "iWD > Agent")) AND (GCXI_Metric.cloud LIKE "yes" OR GCXI_Metric.cloud IS NULL)
|format=table
|group by=GCXI_Metric.metric
|order by=GCXI_Metric.metric ASC
}}

Looking for pagename AND (GCXI_Metric.folder LIKE "iWD > Agent" OR (GCXI_Metric.displaysInFolder HOLDS LIKE "iWD > Agent" AND (GCXI_Metric.displaysInFolder_Cloud HOLDS NOT "" OR GCXI_Metric.displaysInFolder_Cloud HOLDS NOT "none" OR GCXI_Metric.displaysInFolder_Cloud HOLDS LIKE "iWD > Agent"))) AND (GCXI_Metric.cloud LIKE "yes" OR GCXI_Metric.cloud IS NULL) -- should be 7 results
{{#cargo_query:
tables=GCXI_Metric,GCXI_Metric__displaysInFolder
|join on=GCXI_Metric._ID=GCXI_Metric__displaysInFolder._rowID
|fields=CONCAT( '[[{{FULLPAGENAME}}#',GCXI_Metric.anchor,'|',GCXI_Metric.metric,']]')=metric,GCXI_Metric.folder=folder,GCXI_Metric.displaysInFolder__full=displaysInFolder,GCXI_Metric.displaysInFolder_Cloud__full=displaysInFolder_Cloud,GCXI_Metric.cloud=cloud
|where=GCXI_Metric._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Metric.folder LIKE "iWD > Agent" OR (GCXI_Metric.displaysInFolder HOLDS LIKE "iWD > Agent" AND (GCXI_Metric.displaysInFolder_Cloud HOLDS NOT "" OR GCXI_Metric.displaysInFolder_Cloud HOLDS NOT "none" OR GCXI_Metric.displaysInFolder_Cloud HOLDS LIKE "iWD > Agent"))) AND (GCXI_Metric.cloud LIKE "yes" OR GCXI_Metric.cloud IS NULL)
|format=table
|group by=GCXI_Metric.metric
|order by=GCXI_Metric.metric ASC
}}

@@ Line 34: / Line 34: @@
 tables=GCXI_Metric,GCXI_Metric__displaysInFolder
 |join on=GCXI_Metric._ID=GCXI_Metric__displaysInFolder._rowID
-|fields=CONCAT( '[[{{FULLPAGENAME}}#',GCXI_Metric.anchor,'|',GCXI_Metric.metric,']]')=metric,GCXI_Metric.folder=folder,GCXI_Metric.displaysInFolder__full=displaysInFolder,GCXI_Metric.displaysInFolder_Cloud__full=displaysInFolder_Cloud,GCXI_Metric.cloud=cloud
+|fields=CONCAT( '[[{{FULLPAGENAME}}#',GCXI_Metric.anchor,'|',GCXI_Metric.displayName,']]')=metric
-|where=GCXI_Metric._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND IF(GCXI_Metric.displaysInFolder_Cloud HOLDS LIKE "%%",(GCXI_Metric.folder LIKE "iWD > Agent" OR GCXI_Metric.displaysInFolder_Cloud HOLDS LIKE "iWD > Agent"),(GCXI_Metric.folder LIKE "iWD > Agent" OR GCXI_Metric.displaysInFolder HOLDS LIKE "iWD > Agent")) AND (GCXI_Metric.cloud LIKE "yes" OR GCXI_Metric.cloud IS NULL)
+|where=GCXI_Metric._pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Metric.folder LIKE "iWD > Agent" OR GCXI_Metric__displaysInFolder._value LIKE "iWD > Agent") {{#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 "iWD > Agent" OR GCXI_Metric.displaysInFolder_Cloud HOLDS LIKE "iWD > Agent"),(GCXI_Metric.folder LIKE "iWD > Agent" OR GCXI_Metric.displaysInFolder HOLDS LIKE "iWD > Agent")) | 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 "iWD > Agent" OR GCXI_Metric.displaysInFolder_Premise HOLDS LIKE "iWD > Agent"),(GCXI_Metric.folder LIKE "iWD > Agent" OR GCXI_Metric.displaysInFolder HOLDS LIKE "iWD > Agent")) | #default= }}
-|format=table
+|group by=GCXI_Metric.displayName
-|group by=GCXI_Metric.metric
+|default=* There are no metrics in this folder
-|order by=GCXI_Metric.metric
+|format=ul
 }}

User:Jdruker/GCXI PG CloudVsPremMetrics - Revision history

WikiSysop at 14:31, May 12, 2022

WikiSysop: Created page with "==Baseline to test GCXI_Metric__displaysInFolder._value vs. displaysInFolder HOLDS== ===GCXI_Metric__displaysInFolder._value LIKE "iWD > Agent"=== Existing query looking for p..."