Template:RNPrint - Revision history

Bgrenon at 17:06, October 5, 2022

2022-10-05T17:06:05Z

WikiSysop at 16:15, October 5, 2022

2022-10-05T16:15:52Z

WikiSysop at 20:45, June 14, 2022

2022-06-14T20:45:57Z

Bgrenon: 1 revision imported

2022-05-25T20:28:56Z

1 revision imported

production>Bgrenon: (by SublimeText.Mediawiker)

2022-05-16T14:29:01Z

(by SublimeText.Mediawiker)

WikiSysop at 14:40, March 30, 2022

2022-03-30T14:40:25Z

Barry.grenon@genesys.com at 19:45, November 18, 2021

2021-11-18T19:45:22Z

Barry.grenon@genesys.com at 01:00, July 1, 2021

2021-07-01T01:00:54Z

Barry.grenon@genesys.com at 01:00, July 1, 2021

2021-07-01T01:00:17Z

Barry.grenon@genesys.com at 00:59, July 1, 2021

2021-07-01T00:59:16Z

@@ Line 27: / Line 27: @@
 	|fields=CONCAT('[[File:',DT.Image,'|',Size,'px|link=]]')
 	|delimiter=
 	|where=
 		ComponentRN.ComponentId="{{{Component|}}}"

@@ Line 31: / Line 31: @@
 		AND ReleaseNumber="{{{ReleaseNumber|}}}"
 		AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"
 }}</h2><!--
@@ Line 61: / Line 62: @@
 		AND ComponentRN.ComponentId="{{{Component|}}}"
 		AND ReleaseNumber="{{{ReleaseNumber|}}}"
-		AND (DT.Name="Private Edition" OR DT.Name="Mixed mode")
+		AND DT.Name="Private Edition"
 }}<!--

@@ Line 1: / Line 1: @@
-<includeonly><!-- Creating section heading--><h2>{{#ifeq:{{#cargo_query:tables=ArticleCloudRN,
+<includeonly><!--
-	ArticleCloudRN__ComponentId
-	|join on=ArticleCloudRN._ID=ArticleCloudRN__ComponentId._rowID
+	Creating section heading
-	|fields=COUNT(*)
-	|where=ArticleCloudRN._pageName="{{FULLPAGENAME}}"
+--><h2>
-	AND ArticleCloudRN._pageNamespace="{{NAMESPACENUMBER}}"|no html}}|1||{{{ComponentName|}}}:}} {{#if:{{{ReleaseDate|}}}|{{#time:F d, Y|{{{ReleaseDate|}}}}}|<span style="background-color:yellow">Date needed</span>}} {{#cargo_query:
+{{#ifeq:
-tables=ComponentRN,
+	{{#cargo_query:tables=
-DeploymentType=DT
+			ArticleCloudRN,
-|join on=ComponentRN.DeploymentTypeId HOLDS DT.Id
+			ArticleCloudRN__ComponentId
-|fields=CONCAT('[[File:',DT.Image,'|',Size,'px|link=]]')
+			|join on=ArticleCloudRN._ID=ArticleCloudRN__ComponentId._rowID
-|delimiter=
+			|fields=COUNT(*)
-|where=ComponentRN.ComponentId="{{{Component|}}}"
+			|where=
-AND ReleaseNumber="{{{ReleaseNumber|}}}"
+				ArticleCloudRN._pageName="{{FULLPAGENAME}}"
-AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"
+				AND ArticleCloudRN._pageNamespace="{{NAMESPACENUMBER}}"
-}}</h2><!-- adding anchor div for linking to RN entry -->{{AnchorDiv|{{{ComponentName|}}}-{{{ReleaseNumber|}}}}}<!-- printing subheading to indicate private edition or mixed mode release info --><!-- IMPORTANT: This query includes hard-coded value for DeploymentType.Name-->{{#cargo_query:
+			|no html
-tables=ComponentRN,
+	}}
-DeploymentType=DT
+	|1||{{{ComponentName|}}}:
-|join on=ComponentRN.DeploymentTypeId HOLDS DT.Id
+}} {{#if:{{{ReleaseDate|}}}|{{#time:F d, Y|{{{ReleaseDate|}}}}}|<span style="background-color:yellow">Date needed</span>
-|fields=DT.Image=Image,
+}}<!--
 DT.Size=Size,
-DT.Name=DTName,
+	DeplomymentType icons after RN heading
 ComponentRN.ComponentId=ComponentId,
-ReleaseNumber,
+-->{{#cargo_query:
-PrivateEditionReleaseDate=PEDate,
+	tables=ComponentRN,
-MixedModeReleaseDate=MixedDate
+	DeploymentType=DT
-|named args=yes
+	|join on=ComponentRN.DeploymentTypeId HOLDS DT.Id
-|format=template
+	|fields=CONCAT('[[File:',DT.Image,'|',Size,'px|link=]]')
-|template=RNPrintSubhead
+	|delimiter=
-|default=
+	|where=
-|where=ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"
+		ComponentRN.ComponentId="{{{Component|}}}"
-AND ComponentRN.ComponentId="{{{Component|}}}"
+		AND ReleaseNumber="{{{ReleaseNumber|}}}"
-AND ReleaseNumber="{{{ReleaseNumber|}}}"
+		AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"
-AND (DT.Name="Private Edition" OR DT.Name="Mixed mode")
+}}</h2><!--
 }}<!-- printing out the list of Issues according to their IssueCategory-->{{#cargo_query:
-tables=ComponentRN,
+	adding anchor div for linking to RN entry
 Issue,
-IssueCategory
+-->{{AnchorDiv|{{{ComponentName|}}}-{{{ReleaseNumber|}}}}}<!--
 |join on=ComponentRN._pageName=Issue._pageName,
-Issue.IssueCategoryId=IssueCategory.Id
+	printing subheading to indicate private edition or mixed mode release info
-|fields=IssueCategory.SectionName=Name,
+	IMPORTANT: This query includes hard-coded value for DeploymentType.Name-
-SupportingDocumentation,
-LocalContent,
+-->{{#cargo_query:
-Issue.TicketNumber,
+	tables=
-SupportingDocumentation,
+		ComponentRN,
-NFBoilerplateId,
+		DeploymentType=DT
-ReleaseNumber,
+	|join on=ComponentRN.DeploymentTypeId HOLDS DT.Id
-ComponentId
+	|fields=
-|format=template
+		DT.Image=Image,
-|template=RNPrintFormat
+		DT.Size=Size,
-|named args=yes
+		DT.Name=DTName,
-|where=ComponentRN.ComponentId = "{{{Component|}}}" AND ReleaseNumber="{{{ReleaseNumber|}}}" AND IssueCategoryId IS NOT NULL AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"
+		ComponentRN.ComponentId=ComponentId,
-|order by=IssueCategory.PrintOrder ASC
+		ReleaseNumber,
-|group by=IssueCategory.SectionName
+		PrivateEditionReleaseDate=PEDate,
-}}__NOCACHE__{{#switch:{{NAMESPACENUMBER}}|620=<span style="font-size:80%">[[{{{Page|}}}|(Link to source)]]</span>|#default=}}</includeonly><noinclude>[[Category:RNAutomation]][[Category:ComponentRN.ComponentId cleanup]][[Category:TrackConstants]]</noinclude>
+		MixedModeReleaseDate=MixedDate

@@ Line 1: / Line 1: @@
-<includeonly><h2>{{#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||{{{ComponentName|}}}:}} {{#if:{{{ReleaseDate|}}}|{{#time:F d, Y|{{{ReleaseDate|}}}}}|<span style="background-color:yellow">Date needed</span>}} {{#cargo_query:
+<includeonly><!-- Creating section heading--><h2>{{#ifeq:{{#cargo_query:tables=ArticleCloudRN,
-tables=ComponentRN,DeploymentType=DT
+	ArticleCloudRN__ComponentId
 |join on=ComponentRN.DeploymentTypeId HOLDS DT.Id
 |fields=CONCAT('[[File:',DT.Image,'|',Size,'px|link=]]')
 |delimiter=
-|where=ComponentRN.ComponentId HOLDS '{{{Component|}}}' AND ReleaseNumber="{{{ReleaseNumber|}}}" AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"
+|where=ComponentRN.ComponentId="{{{Component|}}}"
-}}<!-- removing release type from display until required
+AND ReleaseNumber="{{{ReleaseNumber|}}}"
-{{#cargo_query:
+AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"
-tables=ComponentRN,ReleaseType=RT
+}}</h2><!-- adding anchor div for linking to RN entry -->{{AnchorDiv|{{{ComponentName|}}}-{{{ReleaseNumber|}}}}}<!-- printing subheading to indicate private edition or mixed mode release info --><!-- IMPORTANT: This query includes hard-coded value for DeploymentType.Name-->{{#cargo_query:
-|join on=ComponentRN.ReleaseTypeId=RT.Id
+tables=ComponentRN,
-|fields=Label
+DeploymentType=DT
 |join on=ComponentRN.DeploymentTypeId HOLDS DT.Id
-|fields=DT.Image=Image,DT.Size=Size,DT.Name=DTName,ComponentRN.ComponentId=ComponentId,ReleaseNumber,PrivateEditionReleaseDate=PEDate,MixedModeReleaseDate=MixedDate
+|fields=DT.Image=Image,
 |named args=yes
 |format=template
 |template=RNPrintSubhead
 |default=
-|where=ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"  AND  ComponentRN.ComponentId HOLDS '{{{Component|}}}' AND ReleaseNumber="{{{ReleaseNumber|}}}" AND (DT.Name="Private Edition" OR DT.Name="Mixed mode")
+|where=ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"
-}}{{#cargo_query:
+AND ComponentRN.ComponentId="{{{Component|}}}"
-tables=ComponentRN,Issue,IssueCategory
+AND ReleaseNumber="{{{ReleaseNumber|}}}"
-|join on=ComponentRN._pageName=Issue._pageName,Issue.IssueCategoryId=IssueCategory.Id
+AND (DT.Name="Private Edition" OR DT.Name="Mixed mode")
-|fields=IssueCategory.SectionName=Name,SupportingDocumentation,LocalContent,Issue.TicketNumber,SupportingDocumentation,NFBoilerplateId,ReleaseNumber,ComponentId
+}}<!-- printing out the list of Issues according to their IssueCategory-->{{#cargo_query:
 |format=template
 |template=RNPrintFormat
 |named args=yes
-|where=ComponentRN.ComponentId HOLDS '{{{Component|}}}' AND ReleaseNumber="{{{ReleaseNumber|}}}" AND IssueCategoryId IS NOT NULL AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"
+|where=ComponentRN.ComponentId = "{{{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>
+}}__NOCACHE__{{#switch:{{NAMESPACENUMBER}}|620=<span style="font-size:80%">[[{{{Page|}}}|(Link to source)]]</span>|#default=}}</includeonly><noinclude>[[Category:RNAutomation]][[Category:ComponentRN.ComponentId cleanup]][[Category:TrackConstants]]</noinclude>

@@ 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,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
 |order by=IssueCategory.PrintOrder ASC
 }}__NOCACHE__{{#switch:{{NAMESPACENUMBER}}|620=<span style="font-size:80%">[[{{{Page|}}}|(Link to source)]]</span>|#default=}}</includeonly><noinclude>[[Category:RNAutomation]]</noinclude>

← Older revision	Revision as of 20:28, May 25, 2022
(No difference)