Difference between revisions of "User: Bgrenon"

From Genesys Documentation
Jump to: navigation, search
Line 1: Line 1:
−
{{NoteFormat|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.|3}}
+
<!-- finding all containers-->
−
 
 
 
<tabber>
 
<tabber>
−
Updated in last 7 days=
+
Last 7 days=
−
coming soon
+
{{#cargo_query:
 +
tables=ComponentRN,Component
 +
|join on=ComponentRN.ComponentId HOLDS Component.Id
 +
|fields=ComponentRN.ComponentId
 +
|group by=ComponentRN.ComponentId
 +
|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
 +
}}
 
|-|
 
|-|
−
Updated in last 30 days=
+
Last 30 days=
−
coming soon
 
−
|-|
 
−
Latest containers per component=
 
−
coming soon
 
−
</tabber>
 
−
 
 
−
<!--
 
−
 
 
−
Updated in last 7 days=
 
 
{{#cargo_query:
 
{{#cargo_query:
−
tables=RNElements,ComponentRN
+
tables=ComponentRN,Component
−
|join on=RNElements.Version=ComponentRN.ReleaseNumber
+
|join on=ComponentRN.ComponentId HOLDS Component.Id
−
|fields=IpName,DATE_FORMAT((ReleaseDate),'%M %d, %Y')=ReleaseDate,Version,Container
+
|fields=ComponentRN.ComponentId
−
|where=DATEDIFF(ReleaseDate,NOW()) >= -7 AND ComponentRN._pageNamespace="0" AND PrivateEditionReleaseDate IS NOT NULL
+
|group by=ComponentRN.ComponentId
−
|limit=500
+
|format=template
−
|format=dynamic table
+
|template=GetMaxPrivateEditionReleaseDate
−
|merge similar cells=yes
+
|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()) >= -30
 
}}
 
}}
 
|-|
 
|-|
−
Updated in last 30 days=
+
Latest helm and containers=
 
{{#cargo_query:
 
{{#cargo_query:
−
tables=RNElements,ComponentRN
+
tables=ComponentRN,Component
−
|join on=RNElements.Version=ComponentRN.ReleaseNumber
+
|join on=ComponentRN.ComponentId HOLDS Component.Id
−
|fields=IpName,DATE_FORMAT((ReleaseDate),'%M %d, %Y')=ReleaseDate,Version,Container
+
|fields=ComponentRN.ComponentId
−
|where=DATEDIFF(ReleaseDate,NOW()) >= -30 AND ComponentRN._pageNamespace="0" AND PrivateEditionReleaseDate IS NOT NULL
+
|group by=ComponentRN.ComponentId
−
|limit=500
+
|format=template
−
|format=dynamic table
+
|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>
−
-->
 

Revision as of 12:20, April 20, 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 (2025-06-19 04:01:28)"