Template:GCXI Attributes DisplayDetails - Revision history

WikiSysop at 16:00, May 12, 2022

2022-05-12T16:00:46Z

WikiSysop at 13:30, May 12, 2022

2022-05-12T13:30:51Z

WikiSysop at 12:46, May 4, 2022

2022-05-04T12:46:07Z

WikiSysop: Created page with "Subordinate query template to supplement Template:GCXI_Attributes_Display, to get the details to display, by subfolder, on Attributes pages in the GCXI Project..."

2022-04-14T14:31:00Z

Created page with "<noinclude>Subordinate query template to supplement Template:GCXI_Attributes_Display, to get the details to display, by subfolder, on Attributes pages in the GCXI Project..."

New page

<noinclude>Subordinate query template to supplement [[Template:GCXI_Attributes_Display]], to get the details to display, by subfolder, on Attributes pages in the GCXI Project Guide. The details include attributes specified both directly and indirectly (via displaysInFolder). The template uses [[Template:GCXI_Attributes_DisplayFormat2]] to format the output.

Content is:
<source lang="xml">
==Folder: {{{folder}}}==
{{#cargo_query:
tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder
|join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID
|fields=GCXI_Attribute.attr=attr,GCXI_Attribute.shortDesc=shortDesc,GCXI_Attribute.longDesc=longDesc,REPLACE('{{{folder}}}','>','>')=displayFolder,GCXI_Attribute.dataType=dataType,GCXI_Attribute.form=form,GCXI_Attribute.lov=lov,GCXI_Attribute.internalMetricID=internalMetricID,GCXI_Attribute.dbTable=dbTable,GCXI_Attribute.project=project,GCXI_Attribute.notproject=notproject,GCXI_Attribute.introduced=introduced,GCXI_Attribute.modified=modified,GCXI_Attribute.discontinued=discontinued,GCXI_Attribute.anchor=anchor,CONCAT('{{{page}}}')=page
|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}}}")
|limit=2000
|group by=GCXI_Attribute.attr
|default=There are no attributes in this folder
|format=template
|template=GCXI_Attributes_DisplayFormat2
|order by=GCXI_Attribute.attr ASC
|named args=yes
}}
</source>
</noinclude>

<onlyinclude>
==Folder: {{{folder}}}==
{{#cargo_query:
tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder
|join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID
|fields=GCXI_Attribute.attr=attr,GCXI_Attribute.shortDesc=shortDesc,GCXI_Attribute.longDesc=longDesc,REPLACE('{{{folder}}}','>','>')=displayFolder,GCXI_Attribute.dataType=dataType,GCXI_Attribute.form=form,GCXI_Attribute.lov=lov,GCXI_Attribute.internalMetricID=internalMetricID,GCXI_Attribute.dbTable=dbTable,GCXI_Attribute.project=project,GCXI_Attribute.notproject=notproject,GCXI_Attribute.introduced=introduced,GCXI_Attribute.modified=modified,GCXI_Attribute.discontinued=discontinued,GCXI_Attribute.anchor=anchor,CONCAT('{{{page}}}')=page
|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}}}")
|limit=2000
|group by=GCXI_Attribute.attr
|default=There are no attributes in this folder
|format=template
|template=GCXI_Attributes_DisplayFormat2
|order by=GCXI_Attribute.attr ASC
|named args=yes
}}
</onlyinclude>

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

@@ Line 8: / Line 8: @@
 |join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID
 |fields=GCXI_Attribute.attr=attr,GCXI_Attribute.shortDesc=shortDesc,GCXI_Attribute.longDesc=longDesc,REPLACE('{{{folder}}}','&gt;','>')=displayFolder,GCXI_Attribute.dataType=dataType,GCXI_Attribute.form=form,GCXI_Attribute.lov=lov,GCXI_Attribute.internalMetricID=internalMetricID,GCXI_Attribute.dbTable=dbTable,GCXI_Attribute.project=project,GCXI_Attribute.notproject=notproject,GCXI_Attribute.introduced=introduced,GCXI_Attribute.modified=modified,GCXI_Attribute.discontinued=discontinued,GCXI_Attribute.anchor=anchor,CONCAT('{{{page}}}')=page
-|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= }}
 |limit=2000
 |group by=GCXI_Attribute.attr
@@ Line 26: / Line 26: @@
 |join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID
 |fields=GCXI_Attribute.attr=attr,GCXI_Attribute.shortDesc=shortDesc,GCXI_Attribute.longDesc=longDesc,REPLACE('{{{folder}}}','&gt;','>')=displayFolder,GCXI_Attribute.dataType=dataType,GCXI_Attribute.form=form,GCXI_Attribute.lov=lov,GCXI_Attribute.internalMetricID=internalMetricID,GCXI_Attribute.dbTable=dbTable,GCXI_Attribute.project=project,GCXI_Attribute.notproject=notproject,GCXI_Attribute.introduced=introduced,GCXI_Attribute.modified=modified,GCXI_Attribute.discontinued=discontinued,GCXI_Attribute.anchor=anchor,CONCAT('{{{page}}}')=page
-|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= }}
 |limit=2000
 |group by=GCXI_Attribute.attr