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

2022-05-11T21:15:32Z

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

New page

==Baseline to test GCXI_Attribute__displaysInFolder._value vs. displaysInFolder HOLDS==
===GCXI_Attribute__displaysInFolder._value LIKE "iWD > Agent"===
Existing query looking for pageName 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) -- 9 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._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=table
|order by=GCXI_Attribute.attr ASC
}}

===GCXI_Attribute.displaysInFolder HOLDS LIKE "iWD > Agent"===
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
{{#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.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL)
|group by=GCXI_Attribute.attr
|intro=Trying to include folder=iWD > Agent and displaysInFolder=iWD > Agent:
|default=* There are no attributes in this folder
|format=table
|order by=GCXI_Attribute.attr ASC
}}

==Success?==
{{Editgrn_open}}IS THIS IT?{{Editgrn_close}}<br/>
Looking for pagename 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) -- no diffs if the interior IF clauses are not in brackets
{{#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 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
|order by=GCXI_Attribute.attr
}}

<hr>

==Testing iWD > Age==
{{#cargo_query:
tables=GCXI_Attribute
|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 LIKE "%%",(GCXI_Attribute.folder LIKE "iWD > Age" OR GCXI_Attribute.displaysInFolder_Cloud HOLDS LIKE "iWD > Age"),(GCXI_Attribute.folder LIKE "iWD > Age" OR GCXI_Attribute.displaysInFolder HOLDS LIKE "iWD > Age")) AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL)
|format=table
|group by=GCXI_Attribute.attr
|order by=GCXI_Attribute.attr
}}

{{#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 > Age" OR GCXI_Attribute__displaysInFolder._value LIKE "iWD > Age") 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=table
|order by=GCXI_Attribute.attr ASC
}}

<hr>

==Testing iWD > Classification==
{{#cargo_query:
tables=GCXI_Attribute
|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 LIKE "%%",(GCXI_Attribute.folder LIKE "iWD > Classification" OR GCXI_Attribute.displaysInFolder_Cloud HOLDS LIKE "iWD > Classification"),(GCXI_Attribute.folder LIKE "iWD > Classification" OR GCXI_Attribute.displaysInFolder HOLDS LIKE "iWD > Classification")) AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL)
|format=table
|group by=GCXI_Attribute.attr
|order by=GCXI_Attribute.attr
}}

{{#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 > Classification" OR GCXI_Attribute__displaysInFolder._value LIKE "iWD > Classification") 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=table
|order by=GCXI_Attribute.attr ASC
}}

<hr>
{{AnchorDiv|InstructiveFailures}}
==Instructive failures of logic and/or syntax==
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) -- 9 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_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
|order by=GCXI_Attribute.attr ASC
}}

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
|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_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)
|format=table
|group by=GCXI_Attribute.attr
|order by=GCXI_Attribute.attr ASC
}}

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 "" 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
|order by=GCXI_Attribute.attr ASC
}}

User:MPandian/GCXI PG CloudRestricted2 - Revision history

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