WikiSysop: Created page with "==Premise== i.e., This would be for the GCXIPRG switch condition. For cloud tests, see User:Jdruker/GCXI_DisplaysInFolder_Attrs_CloudVsPrem * {{FULLPAGENAME}}#BaselineS..."

2022-05-31T16:30:58Z

Created page with "==Premise== i.e., This would be for the GCXIPRG switch condition. For cloud tests, see User:Jdruker/GCXI_DisplaysInFolder_Attrs_CloudVsPrem * {{FULLPAGENAME}}#BaselineS..."

New page

==Premise==
i.e., This would be for the GCXIPRG switch condition. For cloud tests, see [[User:Jdruker/GCXI_DisplaysInFolder_Attrs_CloudVsPrem]]

* [[{{FULLPAGENAME}}#BaselineSummary|Baseline summary]]
* [[{{FULLPAGENAME}}#Age|iWD > Age]]
* [[{{FULLPAGENAME}}#Capture|iWD > Capture]]

{{AnchorDiv|BaselineSummary}}
===Baseline: All iWD > Age except premise=no===
{{#cargo_query:
tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder
|join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID
|fields=GCXI_Attribute.attr,GCXI_Attribute.folder,GCXI_Attribute.premise,GCXI_Attribute.displaysInFolder,GCXI_Attribute.displaysInFolder_Premise
|where=GCXI_Attribute._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Attribute.premise IS NULL OR GCXI_Attribute.premise NOT LIKE "no") AND (GCXI_Attribute.folder LIKE "iWD > Age" OR GCXI_Attribute__displaysInFolder._value LIKE "iWD > Age")
|default=* There are no attributes in this folder.
|group by=GCXI_Attribute.attr
|order by=GCXI_Attribute.attr
|format=table
}}

===Baseline: All iWD > Age and iWD > Capture except premise=no===
{{#cargo_query:
tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder
|join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID
|fields=GCXI_Attribute.attr,GCXI_Attribute.folder,GCXI_Attribute.premise,GCXI_Attribute.displaysInFolder,GCXI_Attribute.displaysInFolder_Premise
|where=GCXI_Attribute._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Attribute.premise IS NULL OR GCXI_Attribute.premise NOT LIKE "no") AND (GCXI_Attribute.folder LIKE "iWD > Capture" OR GCXI_Attribute__displaysInFolder._value LIKE "iWD > Capture")
|default=* There are no attributes in this folder.
|group by=GCXI_Attribute.attr
|order by=GCXI_Attribute.attr
|format=table
}}

{{AnchorDiv|Age}}
===Join on displaysInFolder_Premise helper table -- Test iWD > Age===
{{#cargo_query:
tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder,GCXI_Attribute__displaysInFolder_Premise
|join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID,GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder_Premise._rowID
|fields=GCXI_Attribute.attr,GCXI_Attribute.folder,GCXI_Attribute.premise,GCXI_Attribute.displaysInFolder,GCXI_Attribute.displaysInFolder_Premise
|where=GCXI_Attribute._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Attribute.premise IS NULL OR GCXI_Attribute.premise NOT LIKE "no") AND (GCXI_Attribute.folder LIKE "iWD > Age" OR IF(GCXI_Attribute__displaysInFolder_Premise._value IS NOT NULL,GCXI_Attribute__displaysInFolder_Premise._value LIKE "iWD > Age",GCXI_Attribute__displaysInFolder._value LIKE "iWD > Age"))
|default=* There are no attributes in this folder.
|group by=GCXI_Attribute.attr
|order by=GCXI_Attribute.attr
|format=table
}}

{{AnchorDiv|Capture}}
===Join on displaysInFolder_Premise helper table -- Test iWD > Capture===
{{#cargo_query:
tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder,GCXI_Attribute__displaysInFolder_Premise
|join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID,GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder_Premise._rowID
|fields=GCXI_Attribute.attr,GCXI_Attribute.folder,GCXI_Attribute.premise,GCXI_Attribute.displaysInFolder,GCXI_Attribute.displaysInFolder_Premise
|where=GCXI_Attribute._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Attribute.premise IS NULL OR GCXI_Attribute.premise NOT LIKE "no") AND (GCXI_Attribute.folder LIKE "iWD > Capture" OR IF(GCXI_Attribute__displaysInFolder_Premise._value IS NOT NULL,GCXI_Attribute__displaysInFolder_Premise._value LIKE "iWD > Capture",GCXI_Attribute__displaysInFolder._value LIKE "iWD > Capture"))
|default=* There are no attributes in this folder.
|group by=GCXI_Attribute.attr
|order by=GCXI_Attribute.attr
|format=table
}}

==From [[Template:GCXI_Folder_DisplayFormat]] for folder like iWD > Age, hard-coded Library source, and GCXIPRG setting (prem = yes)==
{{ColumnFormat|cols=3|content=
{{#cargo_query:
tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder
|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 "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND GCXI_Attribute.folder LIKE "iWD > Age") OR (GCXI_Attribute._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%") AND GCXI_Attribute__displaysInFolder._value LIKE "iWD > Age" AND (GCXI_Attribute.premise LIKE "yes" OR GCXI_Attribute.premise IS NULL)
|default=* There are no attributes in this folder.
|group by=GCXI_Attribute.attr
|order by=GCXI_Attribute.attr
|format=ul
}}
}}

==From [[Template:GCXI_Folder_DisplayFormat]] for folder like iWD > Age, hard-coded Library source, and GCXIMCPRG setting (cloud = yes)==
{{ColumnFormat|cols=3|content=
{{#cargo_query:
tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder
|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 "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND GCXI_Attribute.folder LIKE "iWD > Age") OR (GCXI_Attribute._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%") AND GCXI_Attribute__displaysInFolder._value LIKE "iWD > Age" AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL)
|default=* There are no attributes in this folder.
|group by=GCXI_Attribute.attr
|order by=GCXI_Attribute.attr
|format=ul
}}
}}

==From [[Template:GCXI_Folder_DisplayFormat]] for folder like iWD > Age==
{{ColumnFormat|cols=3|content=
{{#cargo_query:
tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder
|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 "iWD > Age") OR (GCXI_Attribute._pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/%%") AND GCXI_Attribute__displaysInFolder._value LIKE "iWD > Age" {{#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
|order by=GCXI_Attribute.attr
|format=ul
}}
}}

User:Jdruker/GCXI DisplaysInFolder Attrs PremVsCloud - Revision history

WikiSysop: Created page with "==Premise== i.e., This would be for the GCXIPRG switch condition. For cloud tests, see User:Jdruker/GCXI_DisplaysInFolder_Attrs_CloudVsPrem * {{FULLPAGENAME}}#BaselineS..."