Difference between revisions of "User: Bgrenon"
From Genesys Documentation
Line 1: | Line 1: | ||
+ | ==Retrieve content from all solutions== | ||
+ | |||
+ | {{#cargo_query: | ||
+ | tables=SMART_UseCase, SMART_Meta | ||
+ | |fields=SMART_UseCase.ID, SMART_Meta.Solution, SMART_Meta.Title, SMART_UseCase.UCOverview, | ||
+ | |where=Offering="PureCloud" AND (Solution ="Outbound" OR Solution = "Digital") AND Solution IS NOT NULL | ||
+ | |join on=SMART_UseCase.ID=SMART_Meta.ID | ||
+ | |format=json | ||
+ | }} | ||
+ | |||
+ | <pre> | ||
+ | {{#cargo_query: | ||
+ | tables=SMART_UseCase, SMART_Meta | ||
+ | |fields=SMART_UseCase.ID, SMART_Meta.Solution, SMART_Meta.Title, SMART_UseCase.UCOverview, | ||
+ | |where=Offering="PureCloud" AND (Solution ="Outbound" OR Solution = "Digital") AND Solution IS NOT NULL | ||
+ | |join on=SMART_UseCase.ID=SMART_Meta.ID | ||
+ | |format=json | ||
+ | }} | ||
+ | </pre> | ||
+ | |||
==Maturity Level== | ==Maturity Level== | ||
Sample for PureEngage Cloud - Maturity Level: Differentiated | Sample for PureEngage Cloud - Maturity Level: Differentiated |
Revision as of 21:48, February 20, 2020
Contents
Retrieve content from all solutions[ | edit source]
{{#cargo_query: tables=SMART_UseCase, SMART_Meta |fields=SMART_UseCase.ID, SMART_Meta.Solution, SMART_Meta.Title, SMART_UseCase.UCOverview, |where=Offering="PureCloud" AND (Solution ="Outbound" OR Solution = "Digital") AND Solution IS NOT NULL |join on=SMART_UseCase.ID=SMART_Meta.ID |format=json }}
Maturity Level[ | edit source]
Sample for PureEngage Cloud - Maturity Level: Differentiated
{{#cargo_query: tables=SMART_UseCase,SMART_Meta |join on=SMART_UseCase.ID=SMART_Meta.ID |fields=SMART_Meta.ID,SMART_Meta.Title |where=MaturityLevel="Differentiated" AND Offering="PureEngageCloud" AND SMART_UseCase._pageNamespace="0" |group by=SMART_Meta.ID |format=json |default=}}
All[ | edit source]
query[ | edit source]
{{#cargo_query: tables=SMART_UseCase__RequiresAll,SMART_UseCase,SMART_Meta |join on=SMART_UseCase__RequiresAll._rowID=SMART_UseCase._ID,SMART_UseCase__RequiresAll._value=SMART_Meta.ID |fields=Solution,CONCAT ('[[UseCases/Current/',Offering,'/',SMART_UseCase__RequiresAll._value,'|',SMART_Meta.Title,' (',SMART_Meta.ID,')]]')=List |where=SMART_UseCase.ID="BO03" |default=None |group by=SMART_Meta.ID |format=json }}
At least one[ | edit source]
query[ | edit source]
{{#cargo_query: tables=SMART_UseCase__RequiresOr,SMART_UseCase,SMART_Meta |join on=SMART_UseCase__RequiresOr._rowID=SMART_UseCase._ID,SMART_UseCase__RequiresOr._value=SMART_Meta.ID |fields=Solution,CONCAT ('[[UseCases/Current/',Offering,'/',SMART_UseCase__RequiresOr._value,'|',SMART_Meta.Title,' (',SMART_Meta.ID,')]]')=List |where=SMART_UseCase.ID="BO06" |default=None |group by=SMART_Meta.ID |format=json }}
Optional[ | edit source]
query[ | edit source]
{{#cargo_query: tables=SMART_UseCase__Optional,SMART_UseCase,SMART_Meta |join on=SMART_UseCase__Optional._rowID=SMART_UseCase._ID,SMART_UseCase__Optional._value=SMART_Meta.ID |fields=Solution,CONCAT ('[[UseCases/Current/',Offering,'/',SMART_UseCase__Optional._value,'|',SMART_Meta.Title,' (',SMART_Meta.ID,')]]')=List |where=SMART_UseCase.ID="BO06" |default=None |default=None |group by=SMART_Meta.ID |format=json }}
exceptions[ | edit source]
query[ | edit source]
{{#cargo_query: tables=SMART_UseCase__Exceptions,SMART_UseCase,SMART_Meta |join on=SMART_UseCase__Exceptions._rowID=SMART_UseCase._ID,SMART_UseCase__Exceptions._value=SMART_Meta.ID |fields=Solution,CONCAT ('[[UseCases/Current/',Offering,'/',SMART_UseCase__Exceptions._value,'|',SMART_Meta.Title,' (',SMART_Meta.ID,')]]')=List |where=SMART_UseCase.ID="BO06" |default=None |format=json |group by=SMART_Meta.ID }}