PDMColumnQuery

This template is the Cargo equivalent of Template:PDMColumnDPL, providing the query to populate the Column List table and descriptions on table pages. It is called by Template:PDMTable (for Library book pages) and Template:PDMTablePageFormat (for RDBMS-specific pages).

The template switches to provide different output for ICON and GIM/RAA/PSAAS. It includes two sub-queries:

• The first query creates the Column List table, using formatting template Template:PDMColumnFormat_Table.
• The second query, which does not apply to ICON, is basically the same as the first, using formatting template Template:PDMColumnFormat_GIMDesc to format the descriptions.

Content is:

{{{!}}
! '''Column'''
! '''Data Type'''
! '''P'''
! '''M'''
! '''F'''
! {{#switch:{{#explode:{{{page}}}|:|1}}|GIM|RAA|PSAAS='''DV'''|ICON|#default='''Description'''}}
{{!}}-
{{#cargo_query:
tables=PDMColumn
|fields=_pageName=pageName,colName=colName,dataType_Ora =dataType_Ora,dataType_MSSQL=dataType_MSSQL,dataType_Postgre=dataType_Postgre,dataType_DB2=dataType_DB2,
primaryKey=primaryKey,mandatoryKey=mandatoryKey,foreignKey=foreignKey,defaultValue=defaultValue,colDesc=colDesc,introduced=introduced,modified=modified,discontinued=discontinued,KVP=KVP,xpath=xpath,mandatoryForGIM=mandatoryForGIM,transformDefault=transformDefault
|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}}}}}}}}"
|format=template
|template=PDMColumnFormat_Table
|order by=_rowID
|named args=yes
|limit=1000
}}
{{!}}}
{{#switch:{{#explode:{{{page}}}|:|1}}
|GIM
|RAA
|PSAAS={{#cargo_query:
tables=PDMColumn
|fields=_pageName=pageName,colName=colName,dataType_Ora =dataType_Ora,dataType_MSSQL=dataType_MSSQL,dataType_Postgre=dataType_Postgre,dataType_DB2=dataType_DB2,
primaryKey=primaryKey,mandatoryKey=mandatoryKey,foreignKey=foreignKey,defaultValue=defaultValue,colDesc=colDesc,introduced=introduced,modified=modified,discontinued=discontinued,KVP=KVP,xpath=xpath,mandatoryForGIM=mandatoryForGIM,transformDefault=transformDefault
|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}}}}}}}}"
|format=template
|template=PDMColumnFormat_GIMDesc
|order by=_rowID
|named args=yes
|limit=1000
}}
|#default=}}

No results

Column	Data Type	P	M	F	Description