TestPDMColumnFormat Table

Formatting template to format the rows in the Column List table generated by Template:TestPDMColumnQuery. The formatting switches for GIM, ICON and RAA. This template parallels Template:TestPDMColumn.dpl, the formatting template used by the previous DPL query.

Content is as follows:

{{!}} {{#switch:{{#explode:{{FULLPAGENAME}}|:|1}}
|GIM
|RAA
|PSAAS=[[{{FULLPAGENAME}}#{{{colName}}}|{{{colName}}}]]{{#if:{{{discontinued|}}}|<br/>*Discontinued in release {{{discontinued}}}|}}
|ICON
|#default={{{colName}}}{{#if:{{{discontinued|}}}|<br/>*Discontinued in release {{{discontinued}}}|}}}}
{{!}} {{#switch:{{#explode:{{FULLPAGENAME}}|:|2}}
|PDMOra={{uc:{{{dataType_Ora}}}}}
|PDMMS={{lc:{{{dataType_MSSQL}}}}}
|PDMPostgre={{lc:{{{dataType_Postgre}}}}}
|PDMDB2={{uc:{{{dataType_DB2}}}}}
|GIMRef
|RPRT={{lc:{{{dataType_MSSQL}}}}}
|Library={{#if:{{{dataType_Ora|}}}|'''Oracle:''' {{uc:{{{dataType_Ora}}}}}<br>|}}{{#if:{{{dataType_MSSQL|}}}|'''MSSQL:''' {{lc:{{{dataType_MSSQL}}}}}<br>|}}{{#if:{{{dataType_Postgre|}}}|'''PostgreSQL:''' {{lc:{{{dataType_Postgre}}}}}<br>|}}{{#if:{{{dataType_DB2|}}}|'''DB2:''' {{uc:{{{dataType_DB2}}}}}|}}
|#default=Data type}}
{{!}} style="text-align:center;" {{!}} {{#if:{{{primaryKey|}}}|X|}}
{{!}} style="text-align:center;" {{!}} {{#if:{{{mandatoryKey|}}}|X|}}
{{!}} style="text-align:center;" {{!}} {{#if:{{{foreignKey|}}}|X|}}
{{!}} {{#switch:{{#explode:{{FULLPAGENAME}}|:|1}}
|GIM
|RAA
|PSAAS={{{defaultValue}}}
|ICON
|#default={{{colDesc}}}}}
{{!}}-

---

| {{{colName}}} | Data type | style="text-align:center;" | | style="text-align:center;" | | style="text-align:center;" | | {{{colDesc}}} |-