Difference between revisions of "Template: PrintTopRN"
From Genesys Documentation
production>Bgrenon |
|||
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>{{{ | + | {{#ifeq: |
− | <td>{{{ | + | {{#cargo_query:tables=ArticleCloudRN,ArticleCloudRN__ComponentId |
− | <td>{{#cargo_query: | + | |join on=ArticleCloudRN._ID=ArticleCloudRN__ComponentId._rowID |
− | + | |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 | |join on=ComponentRN.DeploymentTypeId HOLDS DeploymentType.Id | ||
− | |||
− | |||
|fields=CONCAT('[[File:',Image,'|',Size,'px|link=]]') | |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= | |delimiter= | ||
− | |where=ComponentId | + | |order by=DeploymentType.Name |
− | <td>{{#if:{{{HighlightBoilerplateId|}}}|{{{{{HighlightBoilerplateId|}}}}}<br/>{{{ | + | |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>|}} | {{#if:{{{ReleaseNumber|}}}|<td>{{{ReleaseNumber|}}}</td>|}} | ||
</tr> | </tr> | ||
− | <noinclude>[[Category:RNAutomation]]</noinclude> | + | <noinclude>[[Category:RNAutomation]][[Category:TrackConstants]][[Category:ComponentRN.ComponentId cleanup]]</noinclude> |
Revision as of 19:52, May 18, 2022
No results No results