Difference between revisions of "User: Bgrenon/3"
| Line 5: | Line 5: | ||
|where=ComponentRN._pageNamespace="0" AND ArticleCloudRN._pageNamespace="0" AND ArticleCloudRN._pageName LIKE "%GenesysEngage-cloud%" AND PrivateEditionReleaseDate IS NOT NULL AND Component.IpName IS NOT NULL | |where=ComponentRN._pageNamespace="0" AND ArticleCloudRN._pageNamespace="0" AND ArticleCloudRN._pageName LIKE "%GenesysEngage-cloud%" AND PrivateEditionReleaseDate IS NOT NULL AND Component.IpName IS NOT NULL | ||
|intro=<table class="wikitable sortable"><tr><th>Service</th><th>Released on</th><th>Release Number</th><th>Helm updates</th><th>Container updates</th></tr> | |intro=<table class="wikitable sortable"><tr><th>Service</th><th>Released on</th><th>Release Number</th><th>Helm updates</th><th>Container updates</th></tr> | ||
| + | |having=MAX(PrivateEditionReleaseDate) = PrivateEditionReleaseDate | ||
|outro=</table> | |outro=</table> | ||
|format=template | |format=template | ||
Revision as of 18:45, April 8, 2022
Query: SELECT `cargo__Component`.`Name` AS `ServiceName`,MAX(ReleaseDate) AS `ReleaseDate`,MAX(ReleaseNumber) AS `ReleaseNumber`,`cargo__ArticleCloudRN__ComponentId`.`_value` AS `ComponentId`,`cargo__Component`.`IpName` AS `IpName`,`Containers` AS `Containers` FROM `cargo__ArticleCloudRN__ComponentId` LEFT OUTER JOIN `cargo__ArticleCloudRN` ON ((`cargo__ArticleCloudRN__ComponentId`.`_rowID`=`cargo__ArticleCloudRN`.`_ID`)) LEFT OUTER JOIN `cargo__Component` ON ((`cargo__ArticleCloudRN__ComponentId`.`_value`=`cargo__Component`.`Id`)) LEFT OUTER JOIN `cargo__ComponentRN__ComponentId` ON ((`cargo__ArticleCloudRN__ComponentId`.`_value`=`cargo__ComponentRN__ComponentId`.`_value`)) LEFT OUTER JOIN `cargo__ComponentRN` ON ((`cargo__ComponentRN__ComponentId`.`_rowID`=`cargo__ComponentRN`.`_ID`)) LEFT OUTER JOIN `cargo__ComponentRN__DeploymentTypeId` ON ((`cargo__ComponentRN`.`_ID`=`cargo__ComponentRN__DeploymentTypeId`.`_rowID`)) RIGHT OUTER JOIN `cargo__DeploymentType` ON ((`cargo__ComponentRN__DeploymentTypeId`.`_value`=`cargo__DeploymentType`.`Id`)) WHERE `cargo__ComponentRN`.`_pageNamespace`="0" AND `cargo__ArticleCloudRN`.`_pageNamespace`="0" AND `cargo__ArticleCloudRN`.`_pageName` LIKE "%GenesysEngage-cloud%" AND PrivateEditionReleaseDate IS NOT NULL AND `cargo__Component`.`IpName` IS NOT NULL GROUP BY `cargo__Component`.`Name`,`cargo__ArticleCloudRN`.`_pageName`,ReleaseNumber,ComponentId,ReleaseNumber,`cargo__Component`.`IpName`,Containers HAVING MAX(PrivateEditionReleaseDate) = PrivateEditionReleaseDate ORDER BY `cargo__Component`.`Name`,MAX(ReleaseDate),MAX(ReleaseNumber),`cargo__ArticleCloudRN__ComponentId`.`_value`,`cargo__Component`.`IpName` LIMIT 100 Function: CargoSQLQuery::run Error: 1054 Unknown column 'PrivateEditionReleaseDate' in 'having clause' (127.0.0.1)