Template:KVPsTable - Revision history

Bgrenon at 19:44, October 1, 2019

2019-10-01T19:44:42Z

Bgrenon at 19:43, October 1, 2019

2019-10-01T19:43:41Z

Bgrenon at 18:36, October 1, 2019

2019-10-01T18:36:50Z

Bgrenon: Created page with "Query template to generate tables of KVPs and their mappings to GIM. This template is a more general, Cargo equivalent of Template:KVPsDPL, which was developed..."

2019-10-01T18:34:30Z

Created page with "<noinclude>Query template to generate tables of KVPs and their mappings to GIM. This template is a more general, Cargo equivalent of Template:KVPsDPL, which was developed..."

New page

<noinclude>Query template to generate tables of KVPs and their mappings to GIM. This template is a more general, Cargo equivalent of [[Template:KVPsDPL]], which was developed for GMS/Callback.

Three optional parameters (|sourceDraft, |sourcePublished, and sourcePreview) provide flexibility for location of the single-sourced KVP content. If these options are not specified, the template will use a PONYDOCSVERSION of the Library book as the source for draft pages and a "<first two digits of PONYDOCSVERSION>Source" Library book for preview and released pages.

The first "client" for this template is GPR/GPM, which specifies the |KVPType parameter in the {{Template:KVP}} source material. This query template was modified in June 2018 for Chat/BGS, introducing an optional |noType parameter to enable suppression of the KVPType column in the query result. Another optional parameter introduced for Chat is |KVPCategory.

===Usage===
<nowiki>{{KVPsTable|sourceDraft=<optional Library URL for unreleased>|sourcePublished==<optional Library URL for released>|sourcePreview==<optional Library URL for preview>|noType=<optional "yes" to suppress the KVP Type column>|KVPCategory=<optional filtering by the KVPCategory parameter specified in the KVP markup>}}</nowiki>

Content is:
<source lang="xml">
{{#switch:{{{noType}}}
|yes={{#cargo_query:
tables=KVP
|fields=CONCAT(REPLACE(KVP,"_","_"),' ',IF( (introduced IS NOT NULL),CONCAT(' Introduced: ',introduced),''),IF( (modified IS NOT NULL),CONCAT( ' Modified: ',modified),''),IF( (discontinued IS NOT NULL),CONCAT( ' Discontinued: ',discontinued),''))=KVP,CONCAT( KVPDesc,'\n',IF( (KVPDefault IS NOT NULL),CONCAT(' Default value: ',KVPDefault),''),IF( (KVPValid IS NOT NULL),CONCAT(' Valid values: ',KVPValid),''),IF((mandatoryForGIM IS NOT NULL),' Note: This KVP is mandatory for Genesys Info Mart reporting.','') )=Description,REPLACE(mapsTo,"_","_")=Info Mart Database Target
|where={{#switch:{{PONYDOCSSTATUS}}
|unreleased={{#switch:{{{sourceDraft}}}|{{{sourceDraft}}}=_pageName LIKE "{{{sourceDraft}}}"|#default=_pageName LIKE "%{{PONYDOCSPRODUCTSHORT}}:Library:%:{{PONYDOCSVERSION}}"}}
|preview={{#switch:{{{sourcePreview}}}|{{{sourcePreview}}}=_pageName LIKE "{{{sourcePreview}}}"|#default=_pageName LIKE "%{{PONYDOCSPRODUCTSHORT}}:Library:%:{{PONYDOCSVERSION}}"}}
|released|#default={{#switch:{{{sourcePublished}}}|{{{sourcePublished}}}=_pageName LIKE "{{{sourcePublished}}}"|#default=_pageName LIKE "%{{PONYDOCSPRODUCTSHORT}}:Library:%:{{#sub:{{PONYDOCSVERSION}}|0|3}}Source"}}}}{{#if:{{{KVPCategory|}}}|AND (KVPCategory LIKE "{{{KVPCategory}}}")|}}
|format=dynamic table
|rows per page=100
}}
|no
|#default={{#cargo_query:
tables=KVP
|fields=CONCAT(REPLACE(KVP,"_","_"),' ',IF( (introduced IS NOT NULL),CONCAT(' Introduced: ',introduced),''),IF( (modified IS NOT NULL),CONCAT( ' Modified: ',modified),''),IF( (discontinued IS NOT NULL),CONCAT( ' Discontinued: ',discontinued),''))=KVP,CONCAT( KVPDesc,'\n',IF( (KVPDefault IS NOT NULL),CONCAT(' Default value: ',KVPDefault),''),IF( (KVPValid IS NOT NULL),CONCAT(' Valid values: ',KVPValid),''),IF((mandatoryForGIM IS NOT NULL),' Note: This KVP is mandatory for Genesys Info Mart reporting.','') )=Description,KVPType=KVP Type,REPLACE(mapsTo,"_","_")=Info Mart Database Target
|where={{#switch:{{PONYDOCSSTATUS}}
|unreleased={{#switch:{{{sourceDraft}}}|{{{sourceDraft}}}=_pageName LIKE "{{{sourceDraft}}}"|#default=_pageName LIKE "%{{PONYDOCSPRODUCTSHORT}}:Library:%:{{PONYDOCSVERSION}}"}}
|preview={{#switch:{{{sourcePreview}}}|{{{sourcePreview}}}=_pageName LIKE "{{{sourcePreview}}}"|#default=_pageName LIKE "%{{PONYDOCSPRODUCTSHORT}}:Library:%:{{PONYDOCSVERSION}}"}}
|released|#default={{#switch:{{{sourcePublished}}}|{{{sourcePublished}}}=_pageName LIKE "{{{sourcePublished}}}"|#default=_pageName LIKE "%{{PONYDOCSPRODUCTSHORT}}:Library:%:{{#sub:{{PONYDOCSVERSION}}|0|3}}Source"}}}}{{#if:{{{KVPCategory|}}}|AND (KVPCategory LIKE "{{{KVPCategory}}}")|}}
|format=dynamic table
|rows per page=100
}}
}}
</source></noinclude>

<onlyinclude>
{{#switch:{{{noType}}}
|yes={{#cargo_query:
tables=KVP
|fields=CONCAT(REPLACE(KVP,"_","_"),' ',IF( (introduced IS NOT NULL),CONCAT(' Introduced: ',introduced),''),IF( (modified IS NOT NULL),CONCAT( ' Modified: ',modified),''),IF( (discontinued IS NOT NULL),CONCAT( ' Discontinued: ',discontinued),''))=KVP,CONCAT( KVPDesc,'\n',IF( (KVPDefault IS NOT NULL),CONCAT(' Default value: ',KVPDefault),''),IF( (KVPValid IS NOT NULL),CONCAT(' Valid values: ',KVPValid),''),IF((mandatoryForGIM IS NOT NULL),' Note: This KVP is mandatory for Genesys Info Mart reporting.','') )=Description,REPLACE(mapsTo,"_","_")=Info Mart Database Target
|where={{#switch:{{PONYDOCSSTATUS}}
|unreleased={{#switch:{{{sourceDraft}}}|{{{sourceDraft}}}=_pageName LIKE "{{{sourceDraft}}}"|#default=_pageName LIKE "%{{PONYDOCSPRODUCTSHORT}}:Library:%:{{PONYDOCSVERSION}}"}}
|preview={{#switch:{{{sourcePreview}}}|{{{sourcePreview}}}=_pageName LIKE "{{{sourcePreview}}}"|#default=_pageName LIKE "%{{PONYDOCSPRODUCTSHORT}}:Library:%:{{PONYDOCSVERSION}}"}}
|released|#default={{#switch:{{{sourcePublished}}}|{{{sourcePublished}}}=_pageName LIKE "{{{sourcePublished}}}"|#default=_pageName LIKE "%{{PONYDOCSPRODUCTSHORT}}:Library:%:{{#sub:{{PONYDOCSVERSION}}|0|3}}Source"}}}}{{#if:{{{KVPCategory|}}}|AND (KVPCategory LIKE "{{{KVPCategory}}}")|}}
|format=dynamic table
|rows per page=100
}}
|no
|#default={{#cargo_query:
tables=KVP
|fields=CONCAT(REPLACE(KVP,"_","_"),' ',IF( (introduced IS NOT NULL),CONCAT(' Introduced: ',introduced),''),IF( (modified IS NOT NULL),CONCAT( ' Modified: ',modified),''),IF( (discontinued IS NOT NULL),CONCAT( ' Discontinued: ',discontinued),''))=KVP,CONCAT( KVPDesc,'\n',IF( (KVPDefault IS NOT NULL),CONCAT(' Default value: ',KVPDefault),''),IF( (KVPValid IS NOT NULL),CONCAT(' Valid values: ',KVPValid),''),IF((mandatoryForGIM IS NOT NULL),' Note: This KVP is mandatory for Genesys Info Mart reporting.','') )=Description,KVPType=KVP Type,REPLACE(mapsTo,"_","_")=Info Mart Database Target
|where={{#switch:{{PONYDOCSSTATUS}}
|unreleased={{#switch:{{{sourceDraft}}}|{{{sourceDraft}}}=_pageName LIKE "{{{sourceDraft}}}"|#default=_pageName LIKE "%{{PONYDOCSPRODUCTSHORT}}:Library:%:{{PONYDOCSVERSION}}"}}
|preview={{#switch:{{{sourcePreview}}}|{{{sourcePreview}}}=_pageName LIKE "{{{sourcePreview}}}"|#default=_pageName LIKE "%{{PONYDOCSPRODUCTSHORT}}:Library:%:{{PONYDOCSVERSION}}"}}
|released|#default={{#switch:{{{sourcePublished}}}|{{{sourcePublished}}}=_pageName LIKE "{{{sourcePublished}}}"|#default=_pageName LIKE "%{{PONYDOCSPRODUCTSHORT}}:Library:%:{{#sub:{{PONYDOCSVERSION}}|0|3}}Source"}}}}{{#if:{{{KVPCategory|}}}|AND (KVPCategory LIKE "{{{KVPCategory}}}")|}}
|format=dynamic table
|rows per page=100
}}
}}

</onlyinclude>

[[Category:PDMs]] [[Category:KVPs]]

@@ Line 35: / Line 35: @@
 |fields=CONCAT(REPLACE(KVP,"_","_<wbr/>"),'<br/>',IF( (introduced IS NOT NULL),CONCAT('<br/><b>Introduced:</b> ',introduced),''),IF( (modified IS NOT NULL),CONCAT( '<br/><b>Modified:</b> ',modified),''),IF( (discontinued IS NOT NULL),CONCAT( '<br/><b>Discontinued:</b> ',discontinued),''))=KVP,CONCAT( KVPDesc,'\n',IF( (KVPDefault IS NOT NULL),CONCAT('<br/><b>Default value:</b> ',KVPDefault),''),IF( (KVPValid IS NOT NULL),CONCAT('<br/><b>Valid values:</b> ',KVPValid),''),IF((mandatoryForGIM IS NOT NULL),'<br/><br/><b>Note:</b> This KVP is mandatory for Genesys Info Mart reporting.','') )=Description,REPLACE(mapsTo,"_","_<wbr/>")=Info Mart Database Target
 |where=_pageNamespace="{{NAMESPACENUMBER}}" AND _pageName="{{PAGENAME}}"
 |format=dynamic table
 |rows per page=100

@@ Line 30: / Line 30: @@
 <onlyinclude>
-{{#switch:{{{noType}}}
+{{#cargo_query:
 tables=KVP
 |fields=CONCAT(REPLACE(KVP,"_","_<wbr/>"),'<br/>',IF( (introduced IS NOT NULL),CONCAT('<br/><b>Introduced:</b> ',introduced),''),IF( (modified IS NOT NULL),CONCAT( '<br/><b>Modified:</b> ',modified),''),IF( (discontinued IS NOT NULL),CONCAT( '<br/><b>Discontinued:</b> ',discontinued),''))=KVP,CONCAT( KVPDesc,'\n',IF( (KVPDefault IS NOT NULL),CONCAT('<br/><b>Default value:</b> ',KVPDefault),''),IF( (KVPValid IS NOT NULL),CONCAT('<br/><b>Valid values:</b> ',KVPValid),''),IF((mandatoryForGIM IS NOT NULL),'<br/><br/><b>Note:</b> This KVP is mandatory for Genesys Info Mart reporting.','') )=Description,KVPType=KVP Type,REPLACE(mapsTo,"_","_<wbr/>")=Info Mart Database Target
-|where=_pageNamespace="{{NAMESPACENUMBER}}" AND _pageName="{{PAGENAME}}"
+|where=_pageNamespace="{{NAMESPACENUMBER}}" AND _pageName="{{FULLPAGENAME}}"
 |format=dynamic table
 |rows per page=100
 }}