Difference between revisions of "User: Bgrenon"

From Genesys Documentation
Jump to: navigation, search
(Replaced content with "{{#cargo_query: |tables=Article,MintyDocsProduct |join on=Article.productshort=MintyDocsProduct.workspace_id |fields=Article._pageName=Page,Article.Product=Product |where=...")
(Tag: Replaced)
(Undo revision 69392 by Bgrenon (talk))
(Tag: Undo)
Line 1: Line 1:
 +
[[Draft:ContentAdmin]]
 +
 +
==Personas and Qualifying questions==
 +
<pre>
 
{{#cargo_query:
 
{{#cargo_query:
−
|tables=Article,MintyDocsProduct
+
tables=SMART_Meta,SMART_Canonical,SMART_UseCase
−
|join on=Article.productshort=MintyDocsProduct.workspace_id
+
|join on=SMART_Meta._pageName=SMART_Canonical._pageName,SMART_Meta.ID=SMART_UseCase.ID
−
|fields=Article._pageName=Page,Article.Product=Product
+
|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=Article._pageNamespace="0" AND MintyDocsProduct.contentarea="Multicloud"
+
|where=SMART_Meta.ID="EE11" AND SMART_UseCase.Offering="PureEngage"
−
|group by=Article._pageName
+
|format=json
−
|limit=100000
+
|parse values=yes
−
|format=dynamic table}}
+
}}
 +
</pre>
 +
 
 +
{{#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==
 +
 
 +
Query:
 +
<pre>
 +
{{#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
 +
}}
 +
</pre>
 +
 
 +
{{#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==
 +
 
 +
Query:
 +
<pre>
 +
{{#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
 +
}}
 +
</pre>
 +
 
 +
{{#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==
 +
 
 +
{{#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==
 +
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=}}
 +
 
 +
<pre>
 +
{{#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=}}
 +
</pre>
 +
 
 +
==All==
 +
{{#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
 +
}}
 +
 
 +
===query===
 +
<pre>
 +
{{#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
 +
}}
 +
</pre>
 +
 
 +
==At least one==
 +
{{#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
 +
}}
 +
 
 +
===query===
 +
<pre>
 +
{{#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
 +
}}
 +
</pre>
 +
 
 +
==Optional==
 +
{{#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
 +
}}
 +
 
 +
===query===
 +
<pre>
 +
{{#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
 +
}}
 +
</pre>
 +
 
 +
==exceptions==
 +
{{#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
 +
}}
 +
 
 +
===query===
 +
<pre>
 +
{{#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
 +
}}
 +
</pre>
 +
 
 +
==Test html replace==
 +
{{#cargo_query:
 +
tables=SMART_UseCase
 +
|fields=BusinessLogic,Conditions
 +
|where=ID="CE01" AND Offering="PureEngage"
 +
|format=json
 +
}}

Revision as of 20:21, October 23, 2020

Draft:ContentAdmin

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
}}

View JSON

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
}}

View 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
}}

View JSON




Retrieve content from all solutions[ | edit source]

View JSON 

{{#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

View JSON 

{{#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]

View JSON

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]

View JSON

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]

View JSON

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]

View JSON

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
}}

Test html replace[ | edit source]

View JSON

Retrieved from "https://all.docs.genesys.com/User:Bgrenon (2024-11-09 13:05:41)"