User:Jdruker/GCXI PG CloudRestricted/TEST PREMISE DISPLAY - Revision history

WikiSysop at 17:00, May 11, 2022

2022-05-11T17:00:34Z

WikiSysop at 16:15, May 11, 2022

2022-05-11T16:15:39Z

WikiSysop at 14:00, May 11, 2022

2022-05-11T14:00:33Z

WikiSysop at 13:45, May 11, 2022

2022-05-11T13:45:33Z

WikiSysop at 12:45, May 11, 2022

2022-05-11T12:45:33Z

WikiSysop at 12:15, May 11, 2022

2022-05-11T12:15:36Z

WikiSysop at 23:00, May 10, 2022

2022-05-10T23:00:32Z

WikiSysop at 22:30, May 10, 2022

2022-05-10T22:30:28Z

WikiSysop: Created page with "Why is TEST_PREMISE_DISPLAY not showing up in even the baseline query? Existing query for iWD > Agent: {{#cargo_query: tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder..."

2022-05-10T22:15:28Z

Created page with "Why is TEST_PREMISE_DISPLAY not showing up in even the baseline query? Existing query for iWD > Agent: {{#cargo_query: tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder..."

New page

Why is TEST_PREMISE_DISPLAY not showing up in even the baseline query?

Existing query for iWD > Agent:

{{#cargo_query:
tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder
|join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID
|fields=CONCAT( '[[{{FULLPAGENAME}}#',GCXI_Attribute.anchor,'|',GCXI_Attribute.attr,']]')=attr
|where=GCXI_Attribute._pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Attribute.folder LIKE "iWD > Agent" OR GCXI_Attribute__displaysInFolder._value LIKE "iWD > Agent") AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL)
|group by=GCXI_Attribute.attr
|intro=Existing query for GCXIMCPRG:
|default=* There are no attributes in this folder
|format=ol
|order by=GCXI_Attribute.attr ASC
}}

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

@@ Line 52: / Line 52: @@
 |fields=CONCAT( '[[{{FULLPAGENAME}}#',GCXI_Attribute.anchor,'|',GCXI_Attribute.attr,']]')=attr,GCXI_Attribute.folder=folder,GCXI_Attribute.displaysInFolder__full=displaysInFolder,GCXI_Attribute.displaysInFolder_Cloud__full=displaysInFolder_Cloud,GCXI_Attribute.cloud=cloud
 |where=GCXI_Attribute._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Attribute.folder LIKE "iWD > Agent" OR (GCXI_Attribute.displaysInFolder HOLDS LIKE "iWD > Agent" AND (GCXI_Attribute.displaysInFolder_Cloud HOLDS NOT "" OR GCXI_Attribute.displaysInFolder_Cloud HOLDS NOT "none" OR GCXI_Attribute.displaysInFolder_Cloud HOLDS LIKE "iWD > Agent"))) AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL)
 |format=table
 |group by=GCXI_Attribute.attr
 }}

@@ Line 3: / Line 3: @@
 tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder
 |join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID
-|fields=CONCAT( '[[{{FULLPAGENAME}}#',GCXI_Attribute.anchor,'|',GCXI_Attribute.attr,']]')=attr,GCXI_Attribute.folder=folder,GCXI_Attribute.displaysInFolder__full=displaysInFolder,GCXI_Attribute.cloud=cloud
+|fields=CONCAT( '[[{{FULLPAGENAME}}#',GCXI_Attribute.anchor,'|',GCXI_Attribute.attr,']]')=attr,GCXI_Attribute.folder=folder,GCXI_Attribute.displaysInFolder__full=displaysInFolder,GCXI_Attribute.displaysInFolder_Cloud__full=displaysInFolder_Cloud,GCXI_Attribute.cloud=cloud
 |where=GCXI_Attribute._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Attribute.folder LIKE "iWD > Agent" OR GCXI_Attribute__displaysInFolder._value LIKE "iWD > Agent") AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL)
 |group by=GCXI_Attribute.attr
@@ Line 16: / Line 16: @@
 tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder
 |join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID
-|fields=CONCAT( '[[{{FULLPAGENAME}}#',GCXI_Attribute.anchor,'|',GCXI_Attribute.attr,']]')=attr,GCXI_Attribute.folder=folder,GCXI_Attribute.displaysInFolder__full=displaysInFolder,GCXI_Attribute.cloud=cloud
+|fields=CONCAT( '[[{{FULLPAGENAME}}#',GCXI_Attribute.anchor,'|',GCXI_Attribute.attr,']]')=attr,GCXI_Attribute.folder=folder,GCXI_Attribute.displaysInFolder__full=displaysInFolder,GCXI_Attribute.displaysInFolder_Cloud__full=displaysInFolder_Cloud,GCXI_Attribute.cloud=cloud
 |where=GCXI_Attribute._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Attribute.folder LIKE "iWD > Agent" OR GCXI_Attribute.displaysInFolder HOLDS LIKE "iWD > Agent") AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL)
 |group by=GCXI_Attribute.attr
@@ Line 36: / Line 36: @@
 }}
-Looking for pagename and (GCXI_Attribute.folder LIKE "iWD > Agent" OR (GCXI_Attribute.displaysInFolder_Cloud HOLDS LIKE "iWD > Agent" OR GCXI_Attribute.displaysInFolder_Cloud HOLDS NOT "none" AND GCXI_Attribute.displaysInFolder HOLDS LIKE "iWD > Agent")) AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL) -- should be 8 results
+Looking for pagename and (GCXI_Attribute.folder LIKE "iWD > Agent" OR (GCXI_Attribute.displaysInFolder_Cloud HOLDS LIKE "iWD > Agent" OR GCXI_Attribute.displaysInFolder_Cloud HOLDS NOT "none" AND GCXI_Attribute.displaysInFolder HOLDS LIKE "iWD > Agent")) AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL) -- should be 7 results
 {{#cargo_query:
 tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder
@@ Line 46: / Line 46: @@
 }}
-Looking for pagename AND (GCXI_Attribute.folder LIKE "iWD > Agent" OR (GCXI_Attribute.displaysInFolder HOLDS LIKE "iWD > Agent" AND GCXI_Attribute.displaysInFolder_Cloud HOLDS NOT "none") OR GCXI_Attribute.displaysInFolder_Cloud HOLDS LIKE "iWD > Agent") AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL) -- should be 8 results
+Looking for pagename AND (GCXI_Attribute.folder LIKE "iWD > Agent" OR (GCXI_Attribute.displaysInFolder HOLDS LIKE "iWD > Agent" AND (GCXI_Attribute.displaysInFolder_Cloud HOLDS NOT "" OR GCXI_Attribute.displaysInFolder_Cloud HOLDS NOT "none" OR GCXI_Attribute.displaysInFolder_Cloud HOLDS LIKE "iWD > Agent"))) AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL) -- should be 7 results
 {{#cargo_query:
 tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder
 |join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID
 |fields=CONCAT( '[[{{FULLPAGENAME}}#',GCXI_Attribute.anchor,'|',GCXI_Attribute.attr,']]')=attr,GCXI_Attribute.folder=folder,GCXI_Attribute.displaysInFolder__full=displaysInFolder,GCXI_Attribute.displaysInFolder_Cloud__full=displaysInFolder_Cloud,GCXI_Attribute.cloud=cloud
-|where=GCXI_Attribute._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Attribute.folder LIKE "iWD > Agent" OR (GCXI_Attribute.displaysInFolder HOLDS LIKE "iWD > Agent" AND GCXI_Attribute.displaysInFolder_Cloud HOLDS NOT "none") OR GCXI_Attribute.displaysInFolder_Cloud HOLDS LIKE "iWD > Agent") AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL)
+|where=GCXI_Attribute._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Attribute.folder LIKE "iWD > Agent" OR (GCXI_Attribute.displaysInFolder HOLDS LIKE "iWD > Agent" AND (GCXI_Attribute.displaysInFolder_Cloud HOLDS NOT "" OR GCXI_Attribute.displaysInFolder_Cloud HOLDS NOT "none" OR GCXI_Attribute.displaysInFolder_Cloud HOLDS LIKE "iWD > Agent"))) AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL)
 |format=table
 |group by=GCXI_Attribute.attr
 }}

@@ Line 26: / Line 26: @@
-Looking for pagename AND (GCXI_Attribute.folder LIKE "iWD > Agent" OR GCXI_Attribute.displaysInFolder HOLDS LIKE "iWD > Agent") AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL) -- {{Editgrn_open}}9 results but different order{{Editgrn_close}}
+Looking for pagename AND (GCXI_Attribute.folder LIKE "iWD > Agent" OR GCXI_Attribute.displaysInFolder_Cloud HOLDS LIKE "iWD > Agent" OR GCXI_Attribute.displaysInFolder HOLDS LIKE "iWD > Agent") AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL) -- {{Editgrn_open}}9 results but different order{{Editgrn_close}}
 {{#cargo_query:
 tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder
 |join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID
-|fields=CONCAT( '[[{{FULLPAGENAME}}#',GCXI_Attribute.anchor,'|',GCXI_Attribute.attr,']]')=attr,GCXI_Attribute.folder=folder,GCXI_Attribute.displaysInFolder__full=displaysInFolder,GCXI_Attribute.cloud=cloud
+|fields=CONCAT( '[[{{FULLPAGENAME}}#',GCXI_Attribute.anchor,'|',GCXI_Attribute.attr,']]')=attr,GCXI_Attribute.folder=folder,GCXI_Attribute.displaysInFolder__full=displaysInFolder,GCXI_Attribute.displaysInFolder_Cloud__full=displaysInFolder_Cloud,GCXI_Attribute.cloud=cloud
-|where=GCXI_Attribute._pageName LIKE "Draft:PEC-REP/Library%%" AND (GCXI_Attribute.folder LIKE "iWD > Agent" OR GCXI_Attribute.displaysInFolder HOLDS LIKE "iWD > Agent") AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL)
+|where=GCXI_Attribute._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Attribute.folder LIKE "iWD > Agent" OR GCXI_Attribute.displaysInFolder_Cloud HOLDS LIKE "iWD > Agent" OR GCXI_Attribute.displaysInFolder HOLDS LIKE "iWD > Agent") AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL)
 |format=table
 |group by=GCXI_Attribute.attr
 }}

@@ Line 26: / Line 26: @@
-Looking for pagename AND (GCXI_Attribute.folder LIKE "iWD > Agent" OR GCXI_Attribute.displaysInFolder HOLDS LIKE "iWD > Agent") AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL) -- 9 results but different
+Looking for pagename AND (GCXI_Attribute.folder LIKE "iWD > Agent" OR GCXI_Attribute.displaysInFolder HOLDS LIKE "iWD > Agent") AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL) -- {{Editgrn_open}}9 results but different order{{Editgrn_close}}
 {{#cargo_query:
 tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder

@@ Line 13: / Line 13: @@
 |format=ol
 |order by=GCXI_Attribute.attr ASC
 }}