Difference between revisions of "Template: PrintTopRN"

From Genesys Documentation
Jump to: navigation, search
(PUBSWIKI-2672 - removed td for GCP)
 
(7 intermediate revisions by 4 users not shown)
Line 1: Line 1:
<tr>
+
<tr><!--
{{#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>}}  
+
 
<td>{{{Release Date|}}}</td>
+
print Service column if there is more than 1 service
{{#if:{{{ReleaseNumber|}}}|<td>{{{ReleaseNumber|}}}</td>|}}
+
 
<td>{{#cargo_query:
+
-->{{#ifeq:
table=ComponentRN,DeploymentType
+
{{#cargo_query:tables=ArticleCloudRN,ArticleCloudRN__ComponentId
|join on=ComponentRN.DeploymentTypeId HOLDS DeploymentType.Id
+
|join on=ArticleCloudRN._ID=ArticleCloudRN__ComponentId._rowID
|intro=<div style="margin: -10px 0 -10px 0">
+
|fields=COUNT(*)
|outro=</div>
+
|where=
|fields=CONCAT('[[File:',Image,'|',Size,'px|link=]]')
+
ArticleCloudRN._pageName="{{FULLPAGENAME}}"  
|delimiter=
+
AND ArticleCloudRN._pageNamespace="{{NAMESPACENUMBER}}"
|where=ComponentId HOLDS "{{{ComponentId|}}}" AND ReleaseDate="{{{ReleaseDate|}}}" AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}" {{#switch:{{#explode:{{FULLPAGENAME}}|/|3}}|Hosted=AND DeploymentType.Name!="Private Edition"|#default=}} }}</td>
+
|no html
<td>{{#cargo_query:
+
}}
table=ComponentRN,DeploymentType
+
|1||<td>{{#cargo_query:tables=Component|fields=Name|where=Id="{{{ComponentId|}}}"}}</td>
|join on=ComponentRN.DeploymentTypeId HOLDS DeploymentType.Id
+
}}<!--
|fields=Highlight
+
 
|group by=Highlight
+
Print ReleaseDate
|delimiter=
+
 
|where=ComponentId HOLDS "{{{ComponentId|}}}" AND ReleaseDate="{{{ReleaseDate|}}}" AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"}}</td>
+
--><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
 +
|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=
 +
|order by=DeploymentType.Name
 +
|default=
 +
}}
 +
</td>
 +
<td>
 +
<!--
 +
 
 +
Find 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 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><!--
 +
 
 +
print Highlights
 +
 
 +
-->
 +
<td><!--
 +
 
 +
printing boilerplate and content for highlight content
 +
 
 +
|{{
 +
{{{HighlightBoilerplateId|}}}
 +
|{{{ReleaseNumber|}}}
 +
|{{{ComponentId}}}
 +
}}
 +
}}
 +
 
 +
-->{{#if:{{{HighlightBoilerplateId|}}}
 +
|
 +
{{#arraymap:
 +
{{{HighlightBoilerplateId|}}}
 +
|,
 +
|x
 +
|{{Template:x|{{{ReleaseNumber|}}}|{{{ComponentId}}}}}
 +
|<br/>
 +
}}
 +
<br/>{{{Highlight|}}}
 +
|{{{Highlight|}}}
 +
}}
 +
</td><!--
 +
 
 +
include relase number if exists
 +
 
 +
-->{{#if:{{{ReleaseNumber|}}}
 +
|<td>{{{ReleaseNumber|}}}</td>
 +
|
 +
}}
 
</tr>
 
</tr>
<noinclude>[[Category:RNAutomation]]</noinclude>
+
<noinclude>[[Category:RNAutomation]][[Category:TrackConstants]][[Category:ComponentRN.ComponentId cleanup]]</noinclude>

Latest revision as of 05:48, December 21, 2022

No resultsNo results

Retrieved from "https://all.docs.genesys.com/Template:PrintTopRN (2024-11-09 11:19:58)"