ReportingAttrTable

Query template to generate tables of non-KVP reporting attributes (from Template:ReportingAttr) and their mappings to GIM. This template parallels Template:KVPsTable. The first "client" for this template is BGS.

Three optional parameters (|sourceDraft, |sourcePublished, and |sourcePreview) provide flexibility for location of the single-sourced ReportingAttr 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.

{{#cargo_query:
tables=ReportingAttr
|fields=CONCAT(ReportingAttr.attrName,'<br/>',IF( (ReportingAttr.introduced IS NOT NULL),'<br/><b>Introduced:</b> ',''),IF( (ReportingAttr.introduced IS NOT NULL),ReportingAttr.introduced,''),IF( (ReportingAttr.modified IS NOT NULL),'<br/><b>Modified:</b> ',''),IF( (ReportingAttr.modified IS NOT NULL),ReportingAttr.modified,''),IF( (ReportingAttr.discontinued IS NOT NULL),'<br/><b>Discontinued:</b> ',''),IF( (ReportingAttr.discontinued IS NOT NULL),ReportingAttr.discontinued,''))={{#switch:{{#explode:{{FULLPAGENAME}}|:|1}}|BGS|ES|GCB=Application data attribute|#default=Index property}},CONCAT(ReportingAttr.attrDesc,IF((ReportingAttr.attrValid IS NOT NULL),'<br/><b>Valid values:</b> ',' '),IF((ReportingAttr.attrValid IS NOT NULL),ReportingAttr.attrValid,' '),IF((ReportingAttr.attrDefault IS NOT NULL),'<br/><b>Default value:</b> ',' '),IF((ReportingAttr.attrDefault IS NOT NULL),ReportingAttr.attrDefault,' '),IF((ReportingAttr.mandatoryForGIM IS NOT NULL),'<br/>This attribute is mandatory for Genesys Info Mart reporting.',' ') )=Description,IF( (ReportingAttr.mapsTo LIKE "Not mapped"),"Not used by Genesys Info Mart",REPLACE(ReportingAttr.mapsTo,'_','_<wbr/>'))=Info Mart Database Target
|where={{#switch:{{PONYDOCSSTATUS}}
|unreleased={{#switch:{{{sourceDraft}}}|{{{sourceDraft}}}=ReportingAttr._pageName LIKE "{{{sourceDraft}}}"|#default=ReportingAttr._pageName LIKE "%{{PONYDOCSPRODUCTSHORT}}:Library:%:{{PONYDOCSVERSION}}"}}
|preview={{#switch:{{{sourcePreview}}}|{{{sourcePreview}}}=ReportingAttr._pageName LIKE "{{{sourcePreview}}}"|#default=ReportingAttr._pageName LIKE "%{{PONYDOCSPRODUCTSHORT}}:Library:%:{{PONYDOCSVERSION}}"}}
|released|#default={{#switch:{{{sourcePublished}}}|{{{sourcePublished}}}=ReportingAttr._pageName LIKE "{{{sourcePublished}}}"|#default=ReportingAttr._pageName LIKE "%{{PONYDOCSPRODUCTSHORT}}:Library:%:{{#sub:{{PONYDOCSVERSION}}|0|3}}Source"}}}}
|format=dynamic table
|rows per page=100
}}

No results