Difference between revisions of "Template: RNPrint"
From Genesys Documentation
(Update package: RN Automation: Data Structure) |
(Update package: RN Automation: Data Structure) |
||
| Line 15: | Line 15: | ||
{{AnchorDiv|{{{ComponentName|}}}-{{{ReleaseNumber|}}}}} | {{AnchorDiv|{{{ComponentName|}}}-{{{ReleaseNumber|}}}}} | ||
{{#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('<h3>', | + | |fields=CONCAT('<h3>',IssueCategory.SectionName,'</h3>')=Name,IF (SupportingDocumentation IS NOT NULL, CONCAT (LocalContent,IF (Issue.TicketNumber IS NOT NULL, CONCAT (' (',Issue.TicketNumber,')'), ' '),' </br><b>More info</b>: ' ,SupportingDocumentation),CONCAT (LocalContent,IF (Issue.TicketNumber IS NOT NULL, CONCAT(' (',Issue.TicketNumber,')'), ' '))) |
|format=outline | |format=outline | ||
|outline fields=Name | |outline fields=Name | ||
| − | |where=ComponentRN.ComponentId HOLDS '{{{Component|}}}' AND ReleaseNumber="{{{ReleaseNumber|}}}" AND LocalContent IS NOT NULL AND | + | |where=ComponentRN.ComponentId HOLDS '{{{Component|}}}' AND ReleaseNumber="{{{ReleaseNumber|}}}" AND LocalContent IS NOT NULL AND IssueCategoryId IS NOT NULL AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}" |
| − | |order by= | + | |order by=IssueCategory.PrintOrder ASC |
}} | }} | ||
__NOCACHE__ | __NOCACHE__ | ||
{{#switch:{{NAMESPACENUMBER}}|620=<span style="font-size:80%">[[{{{Page|}}}|(Link to source)]]</span>|#default=}}</includeonly><noinclude>[[Category:RNAutomation]]</noinclude> | {{#switch:{{NAMESPACENUMBER}}|620=<span style="font-size:80%">[[{{{Page|}}}|(Link to source)]]</span>|#default=}}</includeonly><noinclude>[[Category:RNAutomation]]</noinclude> | ||