Difference between revisions of "User: Bgrenon/3"
From Genesys Documentation
| Line 1: | Line 1: | ||
| − | {{#cargo_query: | + | ==UseCase Sales Content== |
| + | *Query 1: Finds the Platform Challenge and Solution, Sales Notes Internal, Pain Points, Desired State, Personas, Qualifying Questions for CE01 PureEngage On-Premises {{#cargo_query: | ||
tables=SMART_Meta,SMART_Canonical,SMART_UseCase | tables=SMART_Meta,SMART_Canonical,SMART_UseCase | ||
|join on=SMART_Meta.ID=SMART_Canonical.ID,SMART_Canonical.ID=SMART_UseCase.ID | |join on=SMART_Meta.ID=SMART_Canonical.ID,SMART_Canonical.ID=SMART_UseCase.ID | ||
|fields=SMART_Meta.ID,SMART_Meta.Title,Subtitle,Offering,PlatformSolution,PlatformChallenge,SMART_UseCase.SellableItems,PainPoints,DesiredState,SMART_UseCase.BuyerPersonas,SMART_UseCase.QualifyingQuestions | |fields=SMART_Meta.ID,SMART_Meta.Title,Subtitle,Offering,PlatformSolution,PlatformChallenge,SMART_UseCase.SellableItems,PainPoints,DesiredState,SMART_UseCase.BuyerPersonas,SMART_UseCase.QualifyingQuestions | ||
|where=SMART_Meta.ID="CE01" AND SMART_UseCase.Offering="PureEngage" | |where=SMART_Meta.ID="CE01" AND SMART_UseCase.Offering="PureEngage" | ||
| − | |format= | + | |format=json |
| + | |parse values=yes | ||
| + | }} | ||
| + | *Query 2: Finds all Canonical Benefits for CE01 {{#cargo_query: | ||
| + | tables=SMART_Meta,SMART_Canonical|join on=SMART_Meta.ID=SMART_Canonical.ID | ||
| + | |fields=CanonicalBenefitID,CanonicalBenefit | ||
| + | |where=SMART_Meta.ID="CE01" | ||
| + | |format=json | ||
|parse values=yes | |parse values=yes | ||
}} | }} | ||
Revision as of 14:51, November 29, 2018
UseCase Sales Content[ | edit source]
- Query 1: Finds the Platform Challenge and Solution, Sales Notes Internal, Pain Points, Desired State, Personas, Qualifying Questions for CE01 PureEngage On-Premises View JSON
- Query 2: Finds all Canonical Benefits for CE01 Error: No field named "CanonicalBenefitID" found for any of the specified database tables.