Template: GCXI Attributes DisplayDetails

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:

==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}}}") {{#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
|default=There are no attributes in this folder
|format=template
|template=GCXI_Attributes_DisplayFormat2
|order by=GCXI_Attribute.attr ASC
|named args=yes
}}

Folder: {{{folder}}}

There are no attributes in this folder