Difference between revisions of "User: Bgrenon/2"

Revision as of 19:15, 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	Azure	AWS	Highlights
IWD Data Mart	100.0.007.1933
Voice Call State Service	100.0.100.0016
Genesys Widgets	9.0.018.09
AI Connector	100.0.149.9341
Webphone	100.0.038.0000
Event Stream	100.0.003.0335
Recording, QM and Interaction Analytics	8.5.512.39
Voice Config Service	100.0.100.0014
Voice Dial Plan Service	100.0.100.0018
Voice Front End Service	100.0.100.0010
Genesys Pulse	100.0.000.0047
Voice RQ Service	100.0.100.0018
Voice Registrar Service	100.0.100.0031
Authentication Service	100.0.012.3950
Workspace API	9.0.001.06
Agent Workspace	100.0.012.0293
Voice Agent State Service	100.0.100.0027
Digital Channels APIs	9.0.000.88
Email	100.0.101.0000
Agent Setup	100.0.006.0214
Genesys Portal	8.5.300.10
Voice SIP Proxy Service	100.0.100.0020
Genesys CX Insights	100.0.037.0000
Digital Channels	100.0.176.0000
Designer	100.0.213.0018
Workforce Management	8.5.219.40 updated
CX Contact	100.0.036.0005
Genesys Softphone VDI Adapter	9.0.103.00
Statistics API	9.0.000.80
Callback	100.0.009.0005
Gplus Adapter for Salesforce	100.0.012.0293
Intelligent Workload Distribution API	9.0.000.74
Voice Orchestration Service	100.0.100.0081
Authentication API	9.0.000.68
Provisioning API	9.0.001.11
Workforce Management API	8.5.219.03
Intelligent Workload Distribution	100.0.101.0000
WebRTC Media Service	100.0.076.0000
Voice Tenant Service	100.0.100.0076
Voice SIP Cluster Service	100.0.100.0052
Genesys Softphone	9.0.103.00
Service Client API	100.0.008.0096
Recording Cloud Backup Service	8.5.299.40
CCE Auth	9.0.000.03
Screen Recording Service	8.5.371.30
Voice Voicemail Service	100.0.100.0030

@@ Line 35: / Line 35: @@
 Latest releases per service=
 {{#cargo_query:
-tables=ComponentRN,ComponentRN__DeploymentTypeId=DepId,ComponentRN__ComponentId=CompId,Component
+tables=ComponentRN,ComponentRN__DeploymentTypeId=DepId,DeploymentType,ComponentRN__ComponentId=CompId,Component
-|join on=ComponentRN._ID=DepId._rowID,DepId._rowID=CompId._rowID,CompId._value=Component.Id
+|join on=ComponentRN._ID=DepId._rowID,DepId._value=DeploymentType.Id,DepId._rowID=CompId._rowID,CompId._value=Component.Id
-|fields=CompId._value=ComponentId
+|fields=ComponentRN.ComponentId=ComponentId
 |group by=ComponentRN.ComponentId
 |format=template
@@ Line 45: / Line 45: @@
 |intro=<table class="wikitable sortable"><tr><th>Service</th><th>Release</th><th>Released On</th><th>Azure</th><th>AWS</th><th>Highlights</th></tr>
 |outro=</table>
-|where=ComponentRN._pageName NOT LIKE "%Draft%" AND (DepId._value='5439f1be-1868-4091-b058-1667389b6ce1' OR DepId._value='ec194bf2-b79a-436d-8ff6-eaff94d9f43a')
+|where=ComponentRN._pageName NOT LIKE "%Draft%" AND DeploymentType.Hosted IS TRUE <!--(DepId._value='5439f1be-1868-4091-b058-1667389b6ce1' OR DepId._value='ec194bf2-b79a-436d-8ff6-eaff94d9f43a')-->
 }}
 </tabber>