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)
Line 1: Line 1:
−
[[Draft:ContentAdmin]]
 
−
 
−
==Personas and Qualifying questions==
 
−
<pre>
 
 
{{#cargo_query:
 
{{#cargo_query:
−
tables=SMART_Meta,SMART_Canonical,SMART_UseCase
+
|tables=Article,MintyDocsProduct
−
|join on=SMART_Meta._pageName=SMART_Canonical._pageName,SMART_Meta.ID=SMART_UseCase.ID
+
|join on=Article.productshort=MintyDocsProduct.workspace_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
+
|fields=Article._pageName=Page,Article.Product=Product
−
|where=SMART_Meta.ID="EE11" AND SMART_UseCase.Offering="PureEngage"
+
|where=Article._pageNamespace="0" AND MintyDocsProduct.contentarea="Multicloud"
−
|format=json
+
|group by=Article._pageName
−
|parse values=yes
+
|limit=100000
−
}}
+
|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:16, October 23, 2020

Page Product
Page Product
RN/CreateRN
Retrieved from "https://all.docs.genesys.com/User:Bgrenon (2025-06-19 16:35:00)"