PDMs GIM-GIDBColumnsFormat

Formatting template called by Template:PDMs_GIM-GIDBTablePageFormat to format the Column List table on GIDB pages in the PSAAS PDM.

Content is:

[[{{{page}}}#{{{column}}}|{{{column}}}]]
{{!}} {{#switch:{{#sub:{{anchorencode:{{#explode:{{{page}}}|:|3}}}}|6}}
|GIDB_GC_GROUP={{#switch:{{{column}}}
|SCRIPT=nvarchar(1024)
|NAME=n{{{dataType}}}
|#default={{{dataType}}}}}
|GIDB_GC_CALLING_LIST
|GIDB_GC_CAMPAIGN
|GIDB_GC_FOLDER
|GIDB_GC_LOGIN
|GIDB_GC_PLACE
|GIDB_GC_SKILL
|GIDB_GC_TENANT={{#switch:{{{column}}}
|NAME
|DESCRIPTION
|SCRIPT
|LOGINCODE=n{{{dataType}}}
|#default={{{dataType}}}
}}
|#default={{{dataType}}}
}}
{{!}} {{#switch:{{#sub:{{anchorencode:{{#explode:{{{page}}}|:|3}}}}|0|14}}
|Table-GIDB_GCX={{#switch:{{{column}}}
|LOGINID
|AGENTID
|CREATED_TS=X
|ID
|#default=}}
|#default={{#if:{{{primaryKey|}}}|X|}}}}
{{!}} {{#switch:{{anchorencode:{{#explode:{{{page}}}|:|3}}}}
|Table-GIDB_GCX_LOGIN_INFO={{#switch:{{{column}}}
|CREATED_TS=X
|#default={{#if:{{{mandatoryKey|}}}|X|}}}}
|#default={{#if:{{{mandatoryKey|}}}|X|}}}}
{{!}} {{#if:{{{foreignKey|}}}|X|}}
{{!}}-
{{!}}

[[{{{page}}}#{{{column}}}|{{{column}}}]] | {{{dataType}}} | | | |- |