Difference between revisions of "Template: SMART SpecificBenefitDrilldown"
From Genesys Documentation
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= | + | |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> |