View source for User: Tgilchri/PRG

==iWD==
{{ColumnFormat|cols=2|content=
{{#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" OR GCXI_Attribute__displaysInFolder._value LIKE "iWD") 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
}}
{{#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" OR GCXI_Attribute__displaysInFolder._value LIKE "iWD") AND (GCXI_Attribute.premise LIKE "yes" OR GCXI_Attribute.premise IS NULL)
|group by=GCXI_Attribute.attr
|intro=Existing query for GCXIPRG:
|default=* There are no attributes in this folder
|format=ol
|order by=GCXI_Attribute.attr ASC
}}
{{#cargo_query:
tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder,GCXI_Attribute__displaysInFolder_Cloud
|join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID,GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder_Cloud._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" OR (GCXI_Attribute__displaysInFolder_Cloud._value LIKE "iWD" AND GCXI_Attribute__displaysInFolder._value NOT LIKE "iWD")) AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL)
|group by=GCXI_Attribute.attr
|intro=New query for GCXIMCPRG:
|default=* There are no attributes in this folder
|format=ol
|order by=GCXI_Attribute.attr ASC
}}
{{#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=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" OR (GCXI_Attribute__displaysInFolder_Premise._value LIKE "iWD" AND GCXI_Attribute__displaysInFolder._value NOT LIKE "iWD")) AND (GCXI_Attribute.premise LIKE "yes" OR GCXI_Attribute.premise IS NULL)
|group by=GCXI_Attribute.attr
|intro=New query for GCXIPRG:
|default=* There are no attributes in this folder
|format=ol
|order by=GCXI_Attribute.attr ASC
}}
}}