Difference between revisions of "Template: PrintTopRN"

Revision as of 19:52, May 18, 2022

No results No results

@@ Line 1: / Line 1: @@
-<tr>
+<tr><!-- print Service column if there is more than 1 service -->
-{{#ifeq:{{#cargo_query:tables=ArticleCloudRN,ArticleCloudRN__ComponentId|join on=ArticleCloudRN._ID=ArticleCloudRN__ComponentId._rowID|fields=COUNT(*)|where=ArticleCloudRN._pageName="{{FULLPAGENAME}}" AND ArticleCloudRN._pageNamespace="{{NAMESPACENUMBER}}"|no html}}|1||<td>{{{Service|}}}</td>}}
+{{#ifeq:
-<td>{{{Release Date|}}}</td>
+	{{#cargo_query:tables=ArticleCloudRN,ArticleCloudRN__ComponentId
-<td>{{#cargo_query:
+	|join on=ArticleCloudRN._ID=ArticleCloudRN__ComponentId._rowID
-	table=ComponentRN,DeploymentType
+	|fields=COUNT(*)
+	|where=ArticleCloudRN._pageName="{{FULLPAGENAME}}"
+	AND ArticleCloudRN._pageNamespace="{{NAMESPACENUMBER}}"
+	|no html
+	}}
+|1||<td>{{#cargo_query:tables=Component|fields=Name|where=Id="{{{ComponentId|}}}"}}</td>
+}} <!-- Print ReleaseDate -->
+<td>{{#cargo_query:tables=Component
+	|fields=CONCAT('[[#',Name,'-{{{ReleaseNumber|}}}|{{#time:F j, Y|{{{ReleaseDate|}}}}}]]')
+	|where=Id="{{{ComponentId|}}}"
+}}</td>
+<td><!--Find and print Genesys CX on AWS per ComponentRN-->
+	 {{#cargo_query:tables=ComponentRN,DeploymentType
 	|join on=ComponentRN.DeploymentTypeId HOLDS DeploymentType.Id
-	|intro=<div style="margin: -10px 0 -10px 0">
-	|outro=</div>
 	|fields=CONCAT('[[File:',Image,'|',Size,'px|link=]]')
+	|where=ComponentRN.ComponentId="{{{ComponentId|}}}" AND ComponentRN.ReleaseNumber="{{{ReleaseNumber|}}}" AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}" AND DeploymentType.Id="ec194bf2-b79a-436d-8ff6-eaff94d9f43a"
 	|delimiter=
-	|where=ComponentId HOLDS "{{{ComponentId|}}}" AND ReleaseDate="{{{ReleaseDate|}}}" AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}" {{#switch:{{#explode:{{FULLPAGENAME}}|/|3}}|Hosted=AND DeploymentType.Name!="Private Edition"|#default=}} }}</td>
+	|order by=DeploymentType.Name
-<td>{{#if:{{{HighlightBoilerplateId|}}}|{{{{{HighlightBoilerplateId|}}}}}<br/>{{{Highlights|}}}|{{{Highlights|}}}}}</td>
+	|default=
+	}}
+</td>
+<td>
+	<!-- Finr and print Genesys CX on Azure per ComponentRN-->
+	 {{#cargo_query:tables=ComponentRN,DeploymentType
+	|join on=ComponentRN.DeploymentTypeId HOLDS DeploymentType.Id
+	|fields=CONCAT('[[File:',Image,'|',Size,'px|link=]]')
+	|where=ComponentRN.ComponentId="{{{ComponentId|}}}" AND ComponentRN.ReleaseNumber="{{{ReleaseNumber|}}}" AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}" AND DeploymentType.Id="5439f1be-1868-4091-b058-1667389b6ce1"
+	|delimiter=
+	|order by=DeploymentType.Name
+	|default=
+	}}
+</td>
+<td>
+	<!--Find Genesys CX on GKE-->
+	 {{#cargo_query:tables=ComponentRN,DeploymentType
+	|join on=ComponentRN.DeploymentTypeId HOLDS DeploymentType.Id
+	|fields=CONCAT('[[File:',Image,'|',Size,'px|link=]]')
+	|where=ComponentRN.ComponentId="{{{ComponentId|}}}" AND ComponentRN.ReleaseNumber="{{{ReleaseNumber|}}}" AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}" AND DeploymentType.Id="0cffec00-9053-4406-88d7-461255f48f53"
+	|delimiter=
+	|order by=DeploymentType.Name
+	|default=
+	}}</td>
+<td>
+<!--Find Private Edition-->
+	 {{#cargo_query:tables=ComponentRN,DeploymentType
+	|join on=ComponentRN.DeploymentTypeId HOLDS DeploymentType.Id
+	|fields=CONCAT('[[File:',Image,'|',Size,'px|link=]]')
+	|where=ComponentRN.ComponentId="{{{ComponentId|}}}" AND ComponentRN.ReleaseNumber="{{{ReleaseNumber|}}}" AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}" AND DeploymentType.Id="8b480b3c-2733-433a-9166-eab2c2d0663a"
+	|delimiter=
+	|order by=DeploymentType.Name
+	|default=
+	}}</td>
+<td>
+<!-- print Highlights-->{{#if:{{{HighlightBoilerplateId|}}}|{{{{{HighlightBoilerplateId|}}}|{{{ReleaseNumber|}}}|{{{ComponentId}}}}}<br/>{{{Highlight|}}}|{{{Highlight|}}}}}</td>
 {{#if:{{{ReleaseNumber|}}}|<td>{{{ReleaseNumber|}}}</td>|}}
 </tr>
-<noinclude>[[Category:RNAutomation]]</noinclude>
+<noinclude>[[Category:RNAutomation]][[Category:TrackConstants]][[Category:ComponentRN.ComponentId cleanup]]</noinclude>