Template: PDMColDescDownload
From Genesys Documentation
Cargo query to generate a CSV download of column descriptions on a PDM table page.
Query is:
{{#cargo_query:
tables=PDMColumn
|fields=colName=Column,{{#switch:{{#sub:{{#explode:{{{page}}}|/|2}}|3|2}}
|CX|Li=dataType_Postgre
|PE={{#switch:{{#sub:{{#explode:{{{page}}}|/|2}}|9}}
|Ora=dataType_Ora
|MS=dataType_MSSQL
|Postgres
|#default=dataType_Postgre
}}
|#default=dataType_Postgre
}}=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 "{{#switch:{{MINTYDOCSVERSION}}|Library={{{page}}}|Current|#default={{#explode:{{{page}}}|/|0}}/Library/PDMLibrary{{#sub:{{#explode:{{anchorencode:{{#explode:{{{page}}}|/|2}}}}|_|0}}|5|3}}/{{#explode:{{{page}}}|/|3}}}}"
|order by=_rowID
|format=csv
|filename={{#switch:{{MINTYDOCSVERSION}}|Library={{#sub:{{#explode:{{{page}}}|/|2}}|10}}|Current|#default={{#sub:{{#explode:{{{page}}}|/|2}}|5}}}}_PDM_{{#explode:{{{page}}}|/|3}}.csv
|link text=Download a CSV file
|named args=yes
|limit=1000
}}