Template: PDMColumnQuery

From Genesys Documentation
Jump to: navigation, search

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:

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
}}


No results
Column Data Type P M F DV

No results

Retrieved from "https://all.docs.genesys.com/Template:PDMColumnQuery (2022-08-14 20:56:25)"