Difference between revisions of "User: Bgrenon/2"

Revision as of 15:25, April 29, 2022

Warning

Content on this page is reserved for development and testing only; any content below should not be considered final or accurate for the purposes of Genesys Documentation.

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 ReleaseDate IS NOT NULL AND `cargo__ComponentRN`.`_pageNamespace`="0" AND DATEDIFF(ReleaseDate,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 ReleaseDate IS NOT NULL AND `cargo__Comp' 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 ReleaseDate IS NOT NULL AND `cargo__ComponentRN`.`_pageNamespace`="0" AND DATEDIFF(ReleaseDate,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 ReleaseDate IS NOT NULL AND `cargo__Comp' at line 1 (127.0.0.1)

Service	Release	Released On	Released for	Highlights
No results
No results
No results
No results
No results
No results
No results
No results
No results
No results
No results
No results
No results
No results
No results
Agent Setup	100.0.006.0214
Agent Setup	100.0.006.0214
Agent Setup	100.0.006.0214
Agent Workspace	100.0.012.0293
Designer	100.0.213.0018
Designer	100.0.213.0018
Digital Channels	100.0.176.0000
Digital Channels	100.0.176.0000
Digital Channels	100.0.176.0000
Email	100.0.101.0000
Email	100.0.101.0000
Genesys CX Insights	100.0.037.0000
Genesys CX Insights	100.0.037.0000
Genesys CX Insights	100.0.037.0000
Genesys Pulse	100.0.000.0047
Genesys Widgets	9.0.018.09
No results
No results
No results
No results
Intelligent Workload Distribution	100.0.101.0000
Intelligent Workload Distribution	100.0.101.0000
IWD Data Mart	100.0.007.1933
Recording, QM and Interaction Analytics	8.5.512.39
No results
Voice Orchestration Service	100.0.100.0081
Voice Orchestration Service	100.0.100.0081
Voice Orchestration Service	100.0.100.0081
Voice SIP Cluster Service	100.0.100.0052
Voice SIP Proxy Service	100.0.100.0020
Workforce Management	8.5.219.40 updated

@@ Line 35: / Line 35: @@
 Latest helm and containers=
 {{#cargo_query:
-tables=ComponentRN,ComponentRN__DeploymentTypeId=DepId,ComponentRN__ComponentId=CompId
+tables=ComponentRN,ComponentRN__DeploymentTypeId=DepId,ComponentRN__ComponentId=CompId,Component
-|join on=ComponentRN._ID=DepId._rowID,DepId._rowID=CompId._rowID
+|join on=ComponentRN._ID=DepId._rowID,DepId._rowID=CompId._rowID,CompId._value=Component.Id
 |fields=CompId._value=ComponentId
 |group by=ComponentRN.ComponentId
@@ Line 42: / Line 42: @@
 |template=GetMaxReleaseDate
 |named args=yes
-<!--|order by=Component.Name-->
+|order by=Component.Name
 |intro=<table class="wikitable sortable"><tr><th>Service</th><th>Release</th><th>Released On</th><th>Released for</th><th>Highlights</th></tr>
 |outro=</table>