Difference between revisions of "Template: LatestContainers"

Latest revision as of 18:24, April 8, 2022

@@ Line 1: / Line 1: @@
 <tr>
-{{#ifeq:{{#cargo_query:tables=ArticleCloudRN,ArticleCloudRN__ComponentId|join on=ArticleCloudRN._ID=ArticleCloudRN__ComponentId._rowID|fields=COUNT(*)|where=ArticleCloudRN._pageName="{{FULLPAGENAME}}" AND ArticleCloudRN._pageNamespace="0"|no html}}|1||<td>{{{Service|}}}</td>}}
+{{#ifeq:{{#cargo_query:tables=ArticleCloudRN,ArticleCloudRN__ComponentId|join on=ArticleCloudRN._ID=ArticleCloudRN__ComponentId._rowID|fields=COUNT(*)|where=ArticleCloudRN._pageName="{{FULLPAGENAME}}" AND ArticleCloudRN._pageNamespace="0"|no html}}|1||<td>{{{ServiceName|}}}</td>}}
-<td>{{{Release Date|}}}</td>
+<td>{{{ReleaseDate|}}}</td>
-<td>{{#cargo_query:
+<td>{{{ReleaseNumber|}}}</td>
-	table=ComponentRN,DeploymentType
+<td>
-	|join on=ComponentRN.DeploymentTypeId HOLDS DeploymentType.Id
+{{{ReleaseNumber|}}}
-	|fields=MAX(ReleaseNumber)
+{{#cargo_query:tables=RNElements,Component
-	|delimiter=
-	|where=ComponentId HOLDS "{{{ComponentId|}}}" AND ReleaseDate="{{{ReleaseDate|}}}" AND ComponentRN._pageNamespace="0"}}</td>
-<td>{{#cargo_query:tables=RNElements,Component
 	|join on=RNElements.IpName=Component.IpName
 	|fields=CONCAT(RNElements.Filename,'{{#switch:{{NAMESPACENUMBER}}|620={{SuperscriptCheck}}|#default=}}')
 	|default={{#arraymap:{{{Containers|}}}|*|x|{{#switch:{{#sub:x|-3|}}|tgz=*x{{#switch:{{NAMESPACENUMBER}}|620={{SuperscriptFlag}}|#default=}}|#default=}}|\n }}
 	|format=ul
-	|where=Component.Id="{{{ComponentId|}}}" AND RNElements.Version="{{{Release|}}}" AND Type="helm" }}
+	|where=Component.Id="{{{ComponentId|}}}" AND RNElements.Version="{{{ReleaseNumber|}}}" AND Type="helm"
+}}
 </td>
 <td>
+{{{ReleaseNumber|}}}
 {{#cargo_query:tables=RNElements,Component
 	|join on=RNElements.IpName=Component.IpName
@@ Line 21: / Line 20: @@
 	|default={{#arraymap:{{{Containers|}}}|*|x|{{#switch:{{#sub:x|-3|}}|tgz=*x{{#switch:{{NAMESPACENUMBER}}|620={{SuperscriptFlag}}|#default=}}|#default=}}|\n }}
 	|format=ul
-	|where=Component.Id="{{{ComponentId|}}}" AND RNElements.Version="{{{Release|}}}" AND Type="docker" }}
+	|where=RNElements.IpName="{{{IpName|}}}" AND RNElements.Version="{{{ReleaseNumber|}}}" AND Type="docker"
+}}
 </td>
 </tr>