PDMColDescDownload

Cargo query to generate a CSV download of column descriptions on a PDM table page.

Query is:

{{#cargo_query:
tables=PDMColumn
|fields=PDMColumn.colName=Column,{{#switch:{{#explode:{{{page}}}|:|2}}|PDMOra=dataType_Ora|PDMPostgre=dataType_Postgre|PDMDB2=dataType_DB2|PDMMS|RPRT|#default=dataType_MSSQL}}=Data Type,primaryKey=Primary Key,mandatoryKey=Mandatory,foreignKey=Foreign Key,defaultValue=Default Value,colDesc=Description,CONCAT( IF( (PDMColumn.introduced IS NOT NULL),CONCAT('Introduced: ',PDMColumn.introduced,'\n'),''),IF( (PDMColumn.modified__full IS NOT NULL),CONCAT('Modified: ',PDMColumn.modified__full,'\n'),''),IF( (PDMColumn.discontinued IS NOT NULL),CONCAT('Discontinued: ',PDMColumn.discontinued,'\n'),''),IF( (PDMColumn.KVP IS NOT NULL),CONCAT('Based on KVP: ',PDMColumn.KVP),''),IF( (PDMColumn.xpath IS NOT NULL),CONCAT('Based on application data attribute: ',PDMColumn.xpath),''),IF( (PDMColumn.transformDefault IS NOT NULL),CONCAT(' If the KVP is missing from UserEvents, the value of this field is ',PDMColumn.transformDefault),'') )=Comment
|where=_pageName LIKE "{{#if:{{{source|}}}|{{{source}}}|Documentation:{{#switch:{{#explode:{{{page}}}|:|1}}|PSAAS=GIM:Library:{{#explode:{{{page}}}|:|3}}:{{#switch:{{#explode:{{{page}}}|:|4}}|draft=DRAFT|Public=PDMSource}}
|#default={{#explode:{{{page}}}|:|1}}:Library:{{anchorencode:{{#explode:{{{page}}}|:|3}}}}:{{#switch:{{lc:{{#sub:{{{page}}}|-5}}}}|draft|ource={{#explode:{{{page}}}|:|4}}|#default={{#switch:{{lc:{{#explode:{{{page}}}|:|4}}}}|public|current=PDMSource|#default={{#sub:{{#explode:{{{page}}}|:|4}}|0|3}}PDMSource}}}}}}}}"
|order by=_rowID
|format=csv
|filename={{#explode:{{{page}}}|:|1}}_PDM_{{#explode:{{{page}}}|:|3}}.csv
|link text=Download a CSV file
|named args=yes
|limit=1000
}}

Download a CSV file