Difference between revisions of "User: Bgrenon/3"

From Genesys Documentation
Jump to: navigation, search
 
(61 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
==UseCase Sales Content==
+
<!-- finding all containers-->
−
 
+
<tabber>
−
* 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:
+
Last 7 days=
−
tables=SMART_Meta,SMART_Canonical,SMART_UseCase
+
{{#cargo_query:
−
|join on=SMART_Meta.ID=SMART_Canonical.ID,SMART_Canonical.ID=SMART_UseCase.ID
+
tables=ComponentRN,Component
−
|fields=SMART_Meta.ID,SMART_Meta.Title,Subtitle,Offering,PlatformSolution,PlatformChallenge,SMART_UseCase.SellableItems,PainPoints,DesiredState,SMART_UseCase.BuyerPersonas,SMART_UseCase.QualifyingQuestions
+
|join on=ComponentRN.ComponentId HOLDS Component.Id
−
|where=SMART_Meta.ID="CE01" AND SMART_UseCase.Offering="PureEngage"
+
|fields=ComponentRN.ComponentId
−
|format=json
+
|group by=ComponentRN.ComponentId
−
|parse values=yes
+
|format=template
 +
|template=GetMaxPrivateEditionReleaseDate
 +
|named args=yes
 +
|order by=Component.Name
 +
|intro=<table class="wikitable sortable"><tr><th>Service</th><th>Release</th><th>Released On</th><th>Helm</th><th>Containers</th></tr>
 +
|outro=</table>
 +
|where=PrivateEditionReleaseDate IS NOT NULL AND ComponentRN._pageNamespace="0" AND DATEDIFF(PrivateEditionReleaseDate,NOW()) >= -7
 
}}
 
}}
−
* Query 2: Finds all Canonical Benefits for CE01  {{#cargo_query:
+
|-|
−
tables=SMART_Canonical,SMART_Benefits|join on=SMART_Canonical._pageName=SMART_Benefits._pageName
+
Last 30 days=
−
|fields=CanonicalBenefitID,CanonicalBenefit
+
{{#cargo_query:
−
|where=SMART_Canonical.ID="CE01"
+
tables=ComponentRN,Component
−
|format=json
+
|join on=ComponentRN.ComponentId HOLDS Component.Id
−
|parse values=yes
+
|fields=ComponentRN.ComponentId
−
}}
+
|group by=ComponentRN.ComponentId
−
 
+
|format=template
−
==Functional Use Case==
+
|template=GetMaxPrivateEditionReleaseDate
−
*Query 1: Finds the Story, Flow diagram (link to Lucidchart) for CE01 PureEngage On-Premises {{#cargo_query:
+
|named args=yes
−
tables=SMART_Meta,SMART_Canonical,SMART_UseCase
+
|order by=Component.Name
−
|join on=SMART_Meta.ID=SMART_Canonical.ID,SMART_Canonical.ID=SMART_UseCase.ID
+
|intro=<table class="wikitable sortable"><tr><th>Service</th><th>Release</th><th>Released On</th><th>Helm</th><th>Containers</th></tr>
−
|fields=SMART_Meta.ID,SMART_Meta.Title,Subtitle,Offering,UCOverview=Story,HighLevelFlowLucid
+
|outro=</table>
−
|where=SMART_Meta.ID="CE01" AND SMART_UseCase.Offering="PureEngage"
+
|where=PrivateEditionReleaseDate IS NOT NULL AND ComponentRN._pageNamespace="0" AND DATEDIFF(PrivateEditionReleaseDate,NOW()) >= -30
−
|format=json
 
−
|parse values=yes
 
−
}}
 
−
*Query 2: Lists the accompanying flow steps (listed in order) {{#cargo_query:
 
−
tables=SMART_Canonical,SMART_DataSheetFlow
 
−
|join on=SMART_Canonical._pageName=SMART_DataSheetFlow._pageName
 
−
|fields=Flow
 
−
|order by=SMART_Canonical._ID
 
−
|where=SMART_Canonical.ID="CE01"
 
−
|format=json
 
−
|parse values=yes
 
 
}}
 
}}
−
 
+
|-|
−
==Use Case Sales for all use cases in PureEngage==
+
Latest helm and containers=
 
{{#cargo_query:
 
{{#cargo_query:
−
tables=SMART_Meta,SMART_Canonical,SMART_UseCase
+
tables=ComponentRN,Component
−
|join on=SMART_Meta.ID=SMART_Canonical.ID,SMART_Canonical.ID=SMART_UseCase.ID
+
|join on=ComponentRN.ComponentId HOLDS Component.Id
−
|fields=SMART_Meta.ID,SMART_Meta.Title,Subtitle,Offering,PlatformSolution,PlatformChallenge,SMART_UseCase.SellableItems,PainPoints,DesiredState,SMART_UseCase.BuyerPersonas,SMART_UseCase.QualifyingQuestions
+
|fields=ComponentRN.ComponentId
−
|where=SMART_UseCase.Offering="PureEngage"
+
|group by=ComponentRN.ComponentId
−
|format=json
+
|format=template
−
|parse values=yes
+
|template=GetMaxPrivateEditionReleaseDate
 +
|named args=yes
 +
|order by=Component.Name
 +
|intro=<table class="wikitable sortable"><tr><th>Service</th><th>Release</th><th>Released On</th><th>Helm</th><th>Containers</th></tr>
 +
|outro=</table>
 +
|where=PrivateEditionReleaseDate IS NOT NULL AND ComponentRN._pageNamespace="0"
 
}}
 
}}
 +
</tabber>

Latest revision as of 16:06, April 12, 2022

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__ComponentRN`.`ComponentId` AS `ComponentId` FROM `cargo__ComponentRN` LEFT OUTER JOIN `cargo__Component` ON ((`cargo__ComponentRN`.`ComponentId` HOLDS `cargo__Component`.`Id`)) WHERE PrivateEditionReleaseDate IS NOT NULL AND `cargo__ComponentRN`.`_pageNamespace`="0" AND DATEDIFF(PrivateEditionReleaseDate,NOW()) >= -7 GROUP BY `cargo__ComponentRN`.`ComponentId` ORDER BY `cargo__Component`.`Name` LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS `cargo__Component`.`Id`)) WHERE PrivateEditionReleaseDate IS NOT NULL AN' at line 1 (127.0.0.1)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__ComponentRN`.`ComponentId` AS `ComponentId` FROM `cargo__ComponentRN` LEFT OUTER JOIN `cargo__Component` ON ((`cargo__ComponentRN`.`ComponentId` HOLDS `cargo__Component`.`Id`)) WHERE PrivateEditionReleaseDate IS NOT NULL AND `cargo__ComponentRN`.`_pageNamespace`="0" AND DATEDIFF(PrivateEditionReleaseDate,NOW()) >= -30 GROUP BY `cargo__ComponentRN`.`ComponentId` ORDER BY `cargo__Component`.`Name` LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS `cargo__Component`.`Id`)) WHERE PrivateEditionReleaseDate IS NOT NULL AN' at line 1 (127.0.0.1)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__ComponentRN`.`ComponentId` AS `ComponentId` FROM `cargo__ComponentRN` LEFT OUTER JOIN `cargo__Component` ON ((`cargo__ComponentRN`.`ComponentId` HOLDS `cargo__Component`.`Id`)) WHERE PrivateEditionReleaseDate IS NOT NULL AND `cargo__ComponentRN`.`_pageNamespace`="0" GROUP BY `cargo__ComponentRN`.`ComponentId` ORDER BY `cargo__Component`.`Name` LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS `cargo__Component`.`Id`)) WHERE PrivateEditionReleaseDate IS NOT NULL AN' at line 1 (127.0.0.1)

Retrieved from "https://all.docs.genesys.com/User:Bgrenon/3 (2025-06-24 09:59:49)"