Difference between revisions of "Template: SMART SpecificBenefitDrilldown"

From Genesys Documentation
Jump to: navigation, search
Line 1: Line 1:
 
<includeonly>{{#cargo_query:
 
<includeonly>{{#cargo_query:
 
tables=SMART_Benefits,SMART_UseCase,SMART_Meta
 
tables=SMART_Benefits,SMART_UseCase,SMART_Meta
|join on=SMART_Benefits._pageName=SMART_Meta._pageName,SMART_Benefits._pageName=SMART_UseCase._pageName,SMART_UseCase.ID=SMART_Meta.ID
+
|join on=SMART_UseCase._pageName=SMART_Benefits._pageName,SMART_UseCase.ID=SMART_Meta.ID
|fields=CONCAT('[[',SMART_Benefits._pageName,'|',SMART_Meta.Title,' ',SMART_UseCase.ID,']]')=Use Case,UCBenefitID=Benefit,UCBenefit=Description
+
|fields=CONCAT ('[[',SMART_Benefits._pageName,'|',SMART_Meta.Title,' ',SMART_UseCase.ID,']]')=Use Case,UCBenefitID=Benefit,UCBenefit=Description
|where=UCBenefitID="{{{SpecificBenefit}}}" AND SMART_UseCase.ID IS NOT NULL AND Offering="{{#switch:{{{Platform}}}|PureEngage Cloud=PureEngageCloud|PureEngage On-Premises=PureEngage|#default={{{Platform|}}}}}"
+
|where=UCBenefitID="{{{SpecificBenefit}}}" AND SMART_UseCase.ID IS NOT NULL AND Offering="{{#switch:{{{Platform}}}|PureEngage Cloud=PureEngageCloud|PureEngage On-Premises=PureEngage|#default={{{Platform|}}}}}" AND MintyDocsVersion="Current" AND SMART_UseCase._pageNamespace="0"
 
|limit=1000
 
|limit=1000
 
|format=dynamic table
 
|format=dynamic table
 
}}<nowiki /></includeonly><noinclude>[[Category:SMART_Cargo]]</noinclude>
 
}}<nowiki /></includeonly><noinclude>[[Category:SMART_Cargo]]</noinclude>

Revision as of 17:22, February 19, 2020