Difference between revisions of "Template: RNPrint"

Revision as of 14:40, March 30, 2022

@@ Line 11: / Line 11: @@
 |fields=Label
 |where=ComponentRN.ComponentId HOLDS '{{{Component|}}}' AND ReleaseNumber="{{{ReleaseNumber|}}}"
-}}--></h2> {{AnchorDiv|{{{ComponentName|}}}-{{{ReleaseNumber|}}}}}{{#cargo_query:
+}}--></h2>{{AnchorDiv|{{{ComponentName|}}}-{{{ReleaseNumber|}}}}}{{#cargo_query:
 tables=ComponentRN,DeploymentType=DT
 |join on=ComponentRN.DeploymentTypeId HOLDS DT.Id
-|fields=DT.Image=Image,DT.Size=Size,DT.Name=DTName,ComponentRN.ComponentId=ComponentId,ReleaseNumber,PrivateEditionReleaseDate=Date
+|fields=DT.Image=Image,DT.Size=Size,DT.Name=DTName,ComponentRN.ComponentId=ComponentId,ReleaseNumber,PrivateEditionReleaseDate=PEDate,MixedModeReleaseDate=MixedDate
 |named args=yes
 |format=template
 |template=RNPrintSubhead
 |default=
-|where=ComponentRN.ComponentId HOLDS '{{{Component|}}}' AND ReleaseNumber="{{{ReleaseNumber|}}}" AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}" AND DT.Name="Private Edition"
+|where=ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"  AND  ComponentRN.ComponentId HOLDS '{{{Component|}}}' AND ReleaseNumber="{{{ReleaseNumber|}}}" AND (DT.Name="Private Edition" OR DT.Name="Mixed mode")
-}}{{#cargo_query:
-tables=ComponentRN,DeploymentType=DT
-|join on=ComponentRN.DeploymentTypeId HOLDS DT.Id
-|fields=DT.Image=Image,DT.Size=Size,DT.Name=DTName,ComponentRN.ComponentId=ComponentId,ReleaseNumber,MixedModeReleaseDate=Date
-|named args=yes
-|format=template
-|template=RNPrintSubhead
-|default=
-|where=ComponentRN.ComponentId HOLDS '{{{Component|}}}' AND ReleaseNumber="{{{ReleaseNumber|}}}" AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}" AND DT.Name="Mixed mode"
 }}{{#cargo_query:
 tables=ComponentRN,Issue,IssueCategory
 |join on=ComponentRN._pageName=Issue._pageName,Issue.IssueCategoryId=IssueCategory.Id
-|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,')'), ' ')))
+|fields=IssueCategory.SectionName=Name,SupportingDocumentation,LocalContent,Issue.TicketNumber,SupportingDocumentation,NFBoilerplateId,ReleaseNumber,ComponentId
-|format=outline
+|format=template
-|outline fields=Name
+|template=RNPrintFormat
-|where=ComponentRN.ComponentId HOLDS '{{{Component|}}}' AND ReleaseNumber="{{{ReleaseNumber|}}}" AND LocalContent IS NOT NULL AND IssueCategoryId IS NOT NULL AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"
+|named args=yes
+|where=ComponentRN.ComponentId HOLDS '{{{Component|}}}' AND ReleaseNumber="{{{ReleaseNumber|}}}" AND IssueCategoryId IS NOT NULL AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"
 |order by=IssueCategory.PrintOrder ASC
+|group by=IssueCategory.SectionName
 }}__NOCACHE__{{#switch:{{NAMESPACENUMBER}}|620=<span style="font-size:80%">[[{{{Page|}}}|(Link to source)]]</span>|#default=}}</includeonly><noinclude>[[Category:RNAutomation]]</noinclude>