Template: PDMColumnQuery
From Genesys Documentation
This template provides 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 includes two sub-queries:
- The first query creates the Column List table, using formatting template Template:PDMColumnFormat_Table.
- The second query is basically the same as the first, using formatting template Template:PDMColumnFormat_GIMDesc to format the descriptions.
This template has been modified from the one originally developed for Ponydocs. Since it no longer needs to cover ICON, some switches and query fields fall away.
Content is:
{{{!}}
! '''Column'''
! '''Data Type'''
! '''P'''
! '''M'''
! '''F'''
! '''DV'''
{{!}}-
{{#cargo_query:
tables=PDMColumn
|fields=_pageName=pageName,colName=colName,dataType_Ora =dataType_Ora,dataType_MSSQL=dataType_MSSQL,dataType_Postgre=dataType_Postgre,
primaryKey=primaryKey,mandatoryKey=mandatoryKey,foreignKey=foreignKey,defaultValue=defaultValue,colDesc=colDesc,introduced=introduced,modified=modified,discontinued=discontinued,KVP=KVP,xpath=xpath,mandatoryForGIM=mandatoryForGIM,transformDefault=transformDefault,CONCAT('{{{page}}}')=page
|where=_pageName LIKE "{{#switch:{{MINTYDOCSVERSION}}|Library={{FULLPAGENAME}}|Current|#default={{#explode:{{FULLPAGENAME}}|/|0}}/Library/PDMLibrary{{#sub:{{#explode:{{anchorencode:{{#explode:{{FULLPAGENAME}}|/|2}}}}|_|0}}|5|3}}/{{#explode:{{FULLPAGENAME}}|/|3}}}}"
|format=template
|template=PDMColumnFormat_Table
|order by=_rowID
|named args=yes
|limit=1000
}}
{{!}}}
{{#cargo_query:
tables=PDMColumn
|fields=_pageName=pageName,colName=colName,dataType_Ora =dataType_Ora,dataType_MSSQL=dataType_MSSQL,dataType_Postgre=dataType_Postgre,
primaryKey=primaryKey,mandatoryKey=mandatoryKey,foreignKey=foreignKey,defaultValue=defaultValue,colDesc=colDesc,introduced=introduced,modified=modified,discontinued=discontinued,KVP=KVP,xpath=xpath,mandatoryForGIM=mandatoryForGIM,transformDefault=transformDefault,CONCAT('{{{page}}}')=page
|where=_pageName LIKE "{{#switch:{{MINTYDOCSVERSION}}|Library={{FULLPAGENAME}}|Current|#default={{#explode:{{FULLPAGENAME}}|/|0}}/Library/PDMLibrary{{#sub:{{#explode:{{anchorencode:{{#explode:{{FULLPAGENAME}}|/|2}}}}|_|0}}|5|3}}/{{#explode:{{FULLPAGENAME}}|/|3}}}}"
|format=template
|template=PDMColumnFormat_GIMDesc
|order by=_rowID
|named args=yes
|limit=1000
}}
| Column | Data Type | P | M | F | DV |
|---|
No results