Difference between revisions of "Template: ComponentRN"
From Genesys Documentation
(Update package: RN Automation: Data Structure) |
|||
| Line 50: | Line 50: | ||
{{#cargo_query:tables=ArticleCloudRN|field=_pageName|where=ComponentId HOLDS '{{{ComponentId|}}}' AND ArticleCloudRN._pageName LIKE "%Internal%"|format=ul|default=None yet!}} | {{#cargo_query:tables=ArticleCloudRN|field=_pageName|where=ComponentId HOLDS '{{{ComponentId|}}}' AND ArticleCloudRN._pageName LIKE "%Internal%"|format=ul|default=None yet!}} | ||
|}{{#cargo_query: | |}{{#cargo_query: | ||
| − | tables=ComponentRN, | + | tables=ComponentRN,Issue,IssueCategory |
| − | |join on=ComponentRN._pageName= | + | |join on=ComponentRN._pageName=Issue._pageName,Issue.IssueCategoryId=IssueCategory.Id |
| − | |fields=CONCAT ('[https://jira.genesys.com/browse/', | + | |fields=CONCAT ('[https://jira.genesys.com/browse/',Issue.TicketNumber,' ',Issue.TicketNumber,']')=Issue,IssueCategory.Name=Issue Category,<!--DeploymentType.Name=Deployment Type,-->IF(LENGTH(LocalContent) > 100, CONCAT( |
SUBSTRING(LocalContent, 1, 100),"..."), LocalContent)=Description,SupportingDocumentation | SUBSTRING(LocalContent, 1, 100),"..."), LocalContent)=Description,SupportingDocumentation | ||
|format=dynamic table | |format=dynamic table | ||
| − | |where=ComponentRN.ComponentId HOLDS '{{{ComponentId|}}}' AND ReleaseNumber="{{#explode:{{FULLPAGENAME}}|/|2}}" | + | |where=ComponentRN.ComponentId HOLDS '{{{ComponentId|}}}' AND ReleaseNumber="{{#explode:{{FULLPAGENAME}}|/|2}}" |
| − | |group by= | + | |group by=Issue.TicketNumber |
| − | |order by= | + | |order by=IssueCategory.PrintOrder ASC |
}}__NOCACHE__ | }}__NOCACHE__ | ||
__TOC__ | __TOC__ | ||
Revision as of 16:38, June 9, 2021
This is the "ComponentRN" template. It should be called in the following format:
{{ComponentRN
|Highlight=
|ComponentId=
|ReleaseNumber=
|ReleaseDate=
|ReleaseTypeId=
|JQL=
|DeploymentTypeId=
}}
Edit the page to see the template text. This template defines the table "ComponentRN". View table.