Template:PDMColumnFormat Table - Revision history

WikiSysop at 16:00, June 21, 2022

2022-06-21T16:00:42Z

Jose.druker@genesys.com at 17:31, December 15, 2021

2021-12-15T17:31:08Z

Jose.druker@genesys.com at 17:26, December 15, 2021

2021-12-15T17:26:34Z

Jose.druker@genesys.com at 17:25, December 15, 2021

2021-12-15T17:25:30Z

Jose.druker@genesys.com: Changing the switch for data types because of new manual shortnames

2021-12-15T17:23:23Z

Changing the switch for data types because of new manual shortnames

Jose.druker@genesys.com: Created page with "Formatting template to format the rows in the Column List table generated by Template:PDMColumnQuery. This template has been modified from the one originally de..."

2021-03-21T21:26:16Z

Created page with "<noinclude>Formatting template to format the rows in the Column List table generated by Template:PDMColumnQuery. This template has been modified from the one originally de..."

New page

<noinclude>Formatting template to format the rows in the Column List table generated by [[Template:PDMColumnQuery]]. This template has been modified from the one originally developed for Ponydocs. Since it no longer needs to cover ICON, some switches fall away.

Content is as follows:
<source lang="xml">
{{!}} [[{{FULLPAGENAME}}#{{{colName}}}|{{{colName}}}]]{{#if:{{{discontinued|}}}| *Discontinued in release {{{discontinued}}}|}}
{{!}} {{#switch:{{#sub:{{#explode:{{FULLPAGENAME}}|/|2}}|3}}
|PDMOra={{uc:{{{dataType_Ora}}}}}
|PDMMS={{lc:{{{dataType_MSSQL}}}}}
|PDMPostgre={{lc:{{{dataType_Postgre}}}}}
|PDM={{lc:{{{dataType_MSSQL}}}}}
|LibraryGIM
|LibraryRAA={{#if:{{{dataType_Ora|}}}|'''Oracle:''' {{uc:{{{dataType_Ora}}}}} |}}{{#if:{{{dataType_MSSQL|}}}|'''MSSQL:''' {{lc:{{{dataType_MSSQL}}}}} |}}{{#if:{{{dataType_Postgre|}}}|'''PostgreSQL:''' {{lc:{{{dataType_Postgre}}}}}|}}
|#default=Data type}}
{{!}} style="text-align:center;" {{!}} {{#if:{{{primaryKey|}}}|X|}}
{{!}} style="text-align:center;" {{!}} {{#if:{{{mandatoryKey|}}}|X|}}
{{!}} style="text-align:center;" {{!}} {{#if:{{{foreignKey|}}}|X|}}
{{!}} {{{defaultValue}}}
{{!}}-
</source>
----
</noinclude>
<onlyinclude>
{{!}} [[{{FULLPAGENAME}}#{{{colName}}}|{{{colName}}}]]{{#if:{{{discontinued|}}}| *Discontinued in release {{{discontinued}}}|}}
{{!}} {{#switch:{{#sub:{{#explode:{{FULLPAGENAME}}|/|2}}|3}}
|PDMOra={{uc:{{{dataType_Ora}}}}}
|PDMMS={{lc:{{{dataType_MSSQL}}}}}
|PDMPostgre={{lc:{{{dataType_Postgre}}}}}
|PDM={{lc:{{{dataType_MSSQL}}}}}
|LibraryGIM
|LibraryRAA={{#if:{{{dataType_Ora|}}}|'''Oracle:''' {{uc:{{{dataType_Ora}}}}} |}}{{#if:{{{dataType_MSSQL|}}}|'''MSSQL:''' {{lc:{{{dataType_MSSQL}}}}} |}}{{#if:{{{dataType_Postgre|}}}|'''PostgreSQL:''' {{lc:{{{dataType_Postgre}}}}}|}}
|#default=Data type}}
{{!}} style="text-align:center;" {{!}} {{#if:{{{primaryKey|}}}|X|}}
{{!}} style="text-align:center;" {{!}} {{#if:{{{mandatoryKey|}}}|X|}}
{{!}} style="text-align:center;" {{!}} {{#if:{{{foreignKey|}}}|X|}}
{{!}} {{{defaultValue}}}
{{!}}-
</onlyinclude>
<noinclude>[[Category:PDMs]]</noinclude>

@@ Line 10: / Line 10: @@
 |Ora={{uc:{{{dataType_Ora}}}}}
 |MS={{lc:{{{dataType_MSSQL}}}}}
-|Postgres=
+|Postgres
 |#default={{lc:{{{dataType_Postgre}}}}}
 }}
@@ Line 31: / Line 31: @@
 |Ora={{uc:{{{dataType_Ora}}}}}
 |MS={{lc:{{{dataType_MSSQL}}}}}
-|Postgres=
+|Postgres
 |#default={{lc:{{{dataType_Postgre}}}}}
 }}

@@ Line 30: / Line 30: @@
 |Postgres=
 |#default={{lc:{{{dataType_Postgre}}}}}
 |#default=Data type
 }}

@@ Line 28: / Line 28: @@
 |Ora={{uc:{{{dataType_Ora}}}}}
 |MS={{lc:{{{dataType_MSSQL}}}}}
-|Postgres={{lc:{{{dataType_Postgre}}}}}
+|Postgres=
 |#default=Data type
 }}

@@ Line 4: / Line 4: @@
 <source lang="xml">
 {{!}} [[{{FULLPAGENAME}}#{{{colName}}}|{{{colName}}}]]{{#if:{{{discontinued|}}}|<br/>*Discontinued in release {{{discontinued}}}|}}
-{{!}} {{#switch:{{#sub:{{#explode:{{FULLPAGENAME}}|/|2}}|3}}
+{{!}} {{#switch:{{#sub:{{#explode:{{FULLPAGENAME}}|/|2}}|3|2}}
-|PDMOra={{uc:{{{dataType_Ora}}}}}
+|CX
-|PDMMS={{lc:{{{dataType_MSSQL}}}}}
+|Li={{lc:{{{dataType_Postgre}}}}}
-|PDMPostgre={{lc:{{{dataType_Postgre}}}}}
+|PE={{#switch:{{#sub:{{#explode:{{FULLPAGENAME}}|/|2}}|9}}
-|PDM={{lc:{{{dataType_MSSQL}}}}}
+|Ora={{uc:{{{dataType_Ora}}}}}
-|LibraryGIM
+|MS={{lc:{{{dataType_MSSQL}}}}}
-|LibraryRAA={{#if:{{{dataType_Ora|}}}|'''Oracle:''' {{uc:{{{dataType_Ora}}}}}<br>|}}{{#if:{{{dataType_MSSQL|}}}|'''MSSQL:''' {{lc:{{{dataType_MSSQL}}}}}<br>|}}{{#if:{{{dataType_Postgre|}}}|'''PostgreSQL:''' {{lc:{{{dataType_Postgre}}}}}|}}
+|Postgres=
-|#default=Data type}}
+|#default={{lc:{{{dataType_Postgre}}}}}
 {{!}} style="text-align:center;" {{!}} {{#if:{{{primaryKey|}}}|X|}}
 {{!}} style="text-align:center;" {{!}} {{#if:{{{mandatoryKey|}}}|X|}}