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}}}','&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/%%"{{#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}}}[edit source]

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__GCXI_Attribute`.`attr` AS `attr`,`cargo__GCXI_Attribute`.`shortDesc` AS `shortDesc`,`cargo__GCXI_Attribute`.`longDesc` AS `longDesc`,REPLACE('{{{folder}}}','>','>') AS `displayFolder`,`cargo__GCXI_Attribute`.`dataType` AS `dataType`,`form__full` AS `form`,`cargo__GCXI_Attribute`.`lov` AS `lov`,`cargo__GCXI_Attribute`.`internalMetricID` AS `internalMetricID`,`dbTable__full` AS `dbTable`,`cargo__GCXI_Attribute`.`project` AS `project`,`cargo__GCXI_Attribute`.`notproject` AS `notproject`,`cargo__GCXI_Attribute`.`introduced` AS `introduced`,`cargo__GCXI_Attribute`.`modified` AS `modified`,`cargo__GCXI_Attribute`.`discontinued` AS `discontinued`,`cargo__GCXI_Attribute`.`anchor` AS `anchor`,CONCAT('{{{page}}}') AS `page` FROM `cargo__GCXI_Attribute` LEFT OUTER JOIN `cargo__GCXI_Attribute__displaysInFolder` ON ((`cargo__GCXI_Attribute`.`_ID`=`cargo__GCXI_Attribute__displaysInFolder`.`_rowID`)) WHERE `cargo__GCXI_Attribute`.`_pageName` LIKE "PEC-REP/Library/GCXIPRGLibrary/%%" GROUP BY `cargo__GCXI_Attribute`.`attr` ORDER BY `cargo__GCXI_Attribute`.`attr` LIMIT 2000 Function: CargoSQLQuery::run Error: 1 Can't create/write to file '/tmp/MYbL4dHy' (OS errno 28 - No space left on device) (127.0.0.1)