Template:GCXI Attributes DisplayList - Revision history

WikiSysop at 15:45, May 12, 2022

2022-05-12T15:45:46Z

WikiSysop at 13:30, May 12, 2022

2022-05-12T13:30:54Z

WikiSysop at 12:30, May 4, 2022

2022-05-04T12:30:59Z

WikiSysop at 19:30, May 3, 2022

2022-05-03T19:30:30Z

WikiSysop at 19:15, May 3, 2022

2022-05-03T19:15:28Z

WikiSysop: Created page with "Subordinate query template to supplement Template:GCXI_Attributes_Display, to get the list of links that displays at the top of Attributes pages in the GCXI Pro..."

2022-04-14T14:31:02Z

Created page with "<noinclude>Subordinate query template to supplement Template:GCXI_Attributes_Display, to get the list of links that displays at the top of Attributes pages in the GCXI Pro..."

New page

<noinclude>Subordinate query template to supplement [[Template:GCXI_Attributes_Display]], to get the list of links that displays at the top of Attributes pages in the GCXI Project Guide. The lists include attributes specified both directly and indirectly (via displaysInFolder).

Content is:
<source lang="xml">
'''{{{folder}}}'''<br/>
{{#cargo_query:
tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder
|join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID
|fields=CONCAT( '[[{{{page}}}#',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 "{{{folder}}}" OR GCXI_Attribute__displaysInFolder._value LIKE "{{{folder}}}")
|group by=GCXI_Attribute.attr
|default=* There are no attributes in this folder
|format=ul
|order by=GCXI_Attribute.attr ASC
}}
</source>
</noinclude>

<onlyinclude>
'''{{{folder}}}'''<br/>
{{#cargo_query:
tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder
|join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID
|fields=CONCAT( '[[{{{page}}}#',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 "{{{folder}}}" OR GCXI_Attribute__displaysInFolder._value LIKE "{{{folder}}}")
|group by=GCXI_Attribute.attr
|default=* There are no attributes in this folder
|format=ul
|order by=GCXI_Attribute.attr ASC
}}
</onlyinclude>

<noinclude>[[Category:GCXI]] [[Category:Cargo_queries]]</noinclude>

@@ Line 8: / Line 8: @@
 |join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID
 |fields=CONCAT( '[[{{{page}}}#',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 "{{{folder}}}" OR GCXI_Attribute__displaysInFolder._value LIKE "{{{folder}}}") {{#switch: {{#explode:{{{page}}}|/|2}} | GCXIMCPRG = AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL) AND IF(GCXI_Attribute.displaysInFolder_Cloud HOLDS LIKE "%%",(GCXI_Attribute.folder LIKE "{{{folder}}}" OR GCXI_Attribute.displaysInFolder_Cloud HOLDS LIKE "{{{folder}}}"),(GCXI_Attribute.folder LIKE "{{{folder}}}" OR GCXI_Attribute.displaysInFolder HOLDS LIKE "{{{folder}}}")) | GCXIPRG = AND (GCXI_Attribute.premise LIKE "yes" OR GCXI_Attribute.premise IS NULL) AND IF(GCXI_Attribute.displaysInFolder_Premise HOLDS LIKE "%%",(GCXI_Attribute.folder LIKE "{{{folder}}}" OR GCXI_Attribute.displaysInFolder_Premise HOLDS LIKE "{{{folder}}}"),(GCXI_Attribute.folder LIKE "{{{folder}}}" OR GCXI_Attribute.displaysInFolder HOLDS LIKE "{{{folder}}}")) | #default= }}
+|where=GCXI_Attribute._pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/%%"{{#switch:{{#explode:{{{page}}}|/|2}} | GCXIMCPRG = AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL) AND IF(GCXI_Attribute.displaysInFolder_Cloud HOLDS LIKE "%%",(GCXI_Attribute.folder LIKE "{{{folder}}}" OR GCXI_Attribute.displaysInFolder_Cloud HOLDS LIKE "{{{folder}}}"),(GCXI_Attribute.folder LIKE "{{{folder}}}" OR GCXI_Attribute.displaysInFolder HOLDS LIKE "{{{folder}}}")) | GCXIPRG = AND (GCXI_Attribute.premise LIKE "yes" OR GCXI_Attribute.premise IS NULL) AND IF(GCXI_Attribute.displaysInFolder_Premise HOLDS LIKE "%%",(GCXI_Attribute.folder LIKE "{{{folder}}}" OR GCXI_Attribute.displaysInFolder_Premise HOLDS LIKE "{{{folder}}}"),(GCXI_Attribute.folder LIKE "{{{folder}}}" OR GCXI_Attribute.displaysInFolder HOLDS LIKE "{{{folder}}}")) | #default= }}
 |group by=GCXI_Attribute.attr
 |default=* There are no attributes in this folder
@@ Line 23: / Line 23: @@
 |join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID
 |fields=CONCAT( '[[{{{page}}}#',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 "{{{folder}}}" OR GCXI_Attribute__displaysInFolder._value LIKE "{{{folder}}}") {{#switch: {{#explode:{{{page}}}|/|2}} | GCXIMCPRG = AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL) AND IF(GCXI_Attribute.displaysInFolder_Cloud HOLDS LIKE "%%",(GCXI_Attribute.folder LIKE "{{{folder}}}" OR GCXI_Attribute.displaysInFolder_Cloud HOLDS LIKE "{{{folder}}}"),(GCXI_Attribute.folder LIKE "{{{folder}}}" OR GCXI_Attribute.displaysInFolder HOLDS LIKE "{{{folder}}}")) | GCXIPRG = AND (GCXI_Attribute.premise LIKE "yes" OR GCXI_Attribute.premise IS NULL) AND IF(GCXI_Attribute.displaysInFolder_Premise HOLDS LIKE "%%",(GCXI_Attribute.folder LIKE "{{{folder}}}" OR GCXI_Attribute.displaysInFolder_Premise HOLDS LIKE "{{{folder}}}"),(GCXI_Attribute.folder LIKE "{{{folder}}}" OR GCXI_Attribute.displaysInFolder HOLDS LIKE "{{{folder}}}")) | #default= }}
+|where=GCXI_Attribute._pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/%%"{{#switch:{{#explode:{{{page}}}|/|2}} | GCXIMCPRG = AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL) AND IF(GCXI_Attribute.displaysInFolder_Cloud HOLDS LIKE "%%",(GCXI_Attribute.folder LIKE "{{{folder}}}" OR GCXI_Attribute.displaysInFolder_Cloud HOLDS LIKE "{{{folder}}}"),(GCXI_Attribute.folder LIKE "{{{folder}}}" OR GCXI_Attribute.displaysInFolder HOLDS LIKE "{{{folder}}}")) | GCXIPRG = AND (GCXI_Attribute.premise LIKE "yes" OR GCXI_Attribute.premise IS NULL) AND IF(GCXI_Attribute.displaysInFolder_Premise HOLDS LIKE "%%",(GCXI_Attribute.folder LIKE "{{{folder}}}" OR GCXI_Attribute.displaysInFolder_Premise HOLDS LIKE "{{{folder}}}"),(GCXI_Attribute.folder LIKE "{{{folder}}}" OR GCXI_Attribute.displaysInFolder HOLDS LIKE "{{{folder}}}")) | #default= }}
 |group by=GCXI_Attribute.attr
 |default=* There are no attributes in this folder