Difference between revisions of "User: Bgrenon"
From Genesys Documentation
| Line 20: | Line 20: | ||
}} | }} | ||
| + | ==Cloud Assumptions== | ||
| − | + | Query: | |
| − | |||
| − | |||
<pre> | <pre> | ||
{{#cargo_query: | {{#cargo_query: | ||
| Line 42: | Line 41: | ||
}} | }} | ||
| − | == | + | ==Premise Assumptions== |
Query: | Query: | ||
Revision as of 19:06, March 20, 2020
Contents
Personas and Qualifying questions[ | edit source]
{{#cargo_query:
tables=SMART_Meta,SMART_Canonical,SMART_UseCase
|join on=SMART_Meta._pageName=SMART_Canonical._pageName,SMART_Meta.ID=SMART_UseCase.ID
|fields=SMART_Meta.ID,SMART_Meta.Title,Subtitle,Solution,Offering,MaturityLevel,PainPoints,HighLevelFlowLucid,PlatformSolution,PlatformChallenge,SMART_UseCase.SellableItems,PainPoints,DesiredState,SMART_Canonical.BuyerPersonas,SMART_Canonical.QualifyingQuestions,SMART_UseCase.BusinessLogic,SMART_UseCase.UCOverview,SMART_UseCase.DistributionLogic,SMART_UseCase.CustomerInterfaceRequirements,SMART_UseCase.AgentDeskRequirements,SMART_UseCase.RealTimeReporting,SMART_UseCase.HistoricalReporting,SMART_UseCase.GeneralAssumptions,SMART_UseCase.CustomerAssumptions,SMART_UseCase.UCSummary
|where=SMART_Meta.ID="EE11" AND SMART_UseCase.Offering="PureEngage"
|format=json
|parse values=yes
}}
Cloud Assumptions[ | edit source]
Query:
{{#cargo_query:
tables=SMART_UseCase, SMART_Meta, SMART_Canonical, SMART_CloudAssumptions
|join on=SMART_UseCase.ID=SMART_Meta.ID,SMART_Meta._pageName=SMART_Canonical._pageName, SMART_UseCase._pageName=SMART_CloudAssumptions._pageName
|fields=SMART_UseCase.ID, SMART_UseCase.Title, SMART_UseCase.Offering, SMART_CloudAssumptions.Cloud_Assumptions
|where=SMART_Meta.ID="CE01"
|format=json
}}
Premise Assumptions[ | edit source]
Query:
{{#cargo_query:
tables=SMART_UseCase, SMART_Meta, SMART_Canonical, SMART_PremiseAssumptions,
|join on=SMART_UseCase.ID=SMART_Meta.ID,SMART_Meta._pageName=SMART_Canonical._pageName, SMART_UseCase._pageName=SMART_PremiseAssumptions._pageName
|fields=SMART_UseCase.ID, SMART_UseCase.Title, SMART_UseCase.Offering, SMART_PremiseAssumptions.Premise_Assumptions
|where=SMART_Meta.ID="CE01"
|format=json
}}
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
}}