Difference between revisions of "User: Bgrenon/3"

From Genesys Documentation
Jump to: navigation, search
 
(33 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
<!-- finding all containers-->
 +
<tabber>
 +
Last 7 days=
 
{{#cargo_query:
 
{{#cargo_query:
−
tables=ArticleCloudRN__ComponentId,ArticleCloudRN,Component,ComponentRN__ComponentId,ComponentRN,DeploymentType
+
tables=ComponentRN,Component
−
|join on=ArticleCloudRN__ComponentId._value=Component.Id,ArticleCloudRN__ComponentId._rowID=ArticleCloudRN._ID,ArticleCloudRN__ComponentId._value = ComponentRN__ComponentId._value,ComponentRN__ComponentId._rowID=ComponentRN._ID,ComponentRN.DeploymentTypeId HOLDS DeploymentType.Id
+
|join on=ComponentRN.ComponentId HOLDS Component.Id
−
|fields=Component.Name=ServiceName,CONCAT('[[',ArticleCloudRN._pageName,'#',DATE_FORMAT(MAX(ReleaseDate),'%M %d, %Y'),'|',DATE_FORMAT(MAX(PrivateEditionReleaseDate),'%M %d, %Y'),']]')=ReleaseDate,MAX(ReleaseNumber)=ReleaseNumber,ComponentId,MAX(ReleaseDate)=ReleaseDate,Component.IpName=IpName,Containers
+
|fields=ComponentRN.ComponentId
−
|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
+
|group by=ComponentRN.ComponentId
−
|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>
+
|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>
 
|outro=</table>
 +
|where=PrivateEditionReleaseDate IS NOT NULL AND ComponentRN._pageNamespace="0" AND DATEDIFF(PrivateEditionReleaseDate,NOW()) >= -7
 +
}}
 +
|-|
 +
Last 30 days=
 +
{{#cargo_query:
 +
tables=ComponentRN,Component
 +
|join on=ComponentRN.ComponentId HOLDS Component.Id
 +
|fields=ComponentRN.ComponentId
 +
|group by=ComponentRN.ComponentId
 
|format=template
 
|format=template
−
|template=LatestContainers
+
|template=GetMaxPrivateEditionReleaseDate
 
|named args=yes
 
|named args=yes
−
|group by=Component.Name,ArticleCloudRN._pageName,ReleaseNumber,ComponentId,ReleaseNumber,Component.IpName,Containers
+
|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()) >= -30
 +
}}
 +
|-|
 +
Latest helm and containers=
 
{{#cargo_query:
 
{{#cargo_query:
−
tables=ArticleCloudRN__ComponentId,ArticleCloudRN,Component,ComponentRN__ComponentId,ComponentRN,DeploymentType
+
tables=ComponentRN,Component
−
|join on=ArticleCloudRN__ComponentId._value=Component.Id,ArticleCloudRN__ComponentId._rowID=ArticleCloudRN._ID,ArticleCloudRN__ComponentId._value = ComponentRN__ComponentId._value,ComponentRN__ComponentId._rowID=ComponentRN._ID,ComponentRN.DeploymentTypeId HOLDS DeploymentType.Id
+
|join on=ComponentRN.ComponentId HOLDS Component.Id
−
|fields=Component.Name,ArticleCloudRN._pageName,MAX(ReleaseDate),MAX(PrivateEditionReleaseDate),ReleaseNumber,Image,Highlight,ComponentId,ReleaseDate,ReleaseNumber,Component.IpName,Containers
+
|fields=ComponentRN.ComponentId
−
|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
+
|group by=ComponentRN.ComponentId
−
|format=table
+
|format=template
−
|group by=Component.Name,ArticleCloudRN._pageName,ReleaseNumber,Image,Highlight,ComponentId,ReleaseNumber,Component.IpName,Containers
+
|template=GetMaxPrivateEditionReleaseDate
 +
|named args=yes
 
|order by=Component.Name
 
|order by=Component.Name
−
|limit=10
+
|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-20 23:39:20)"