Difference between revisions of "Template: RNPrint"

From Genesys Documentation
Jump to: navigation, search
(Update package: RN Automation: Data Structure)
 
(29 intermediate revisions by 4 users not shown)
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><!--  
−
tables=ComponentRN,DeploymentType=DT
 
−
|join on=ComponentRN.DeploymentTypeId HOLDS DT.Id
 
−
|fields=CONCAT('[[File:',DT.Image,'|50px|link=]]')
 
−
|delimiter=
 
−
|where=ComponentRN.ComponentId HOLDS '{{{Component|}}}' AND ReleaseNumber="{{{ReleaseNumber|}}}" AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"
 
−
}}<!-- removing release type from display until required
 
−
{{#cargo_query:
 
−
tables=ComponentRN,ReleaseType=RT
 
−
|join on=ComponentRN.ReleaseTypeId=RT.Id
 
−
|fields=Label
 
−
|where=ComponentRN.ComponentId HOLDS '{{{Component|}}}' AND ReleaseNumber="{{{ReleaseNumber|}}}"
 
−
}}--></h2>
 
  
−
{{AnchorDiv|{{{ComponentName|}}}-{{{ReleaseNumber|}}}}}
+
Creating section heading
−
{{#cargo_query:
+
 
−
tables=ComponentRN,JiraIssue,IssueType
+
--><h2>
−
|join on=ComponentRN._pageName=JiraIssue._pageName,JiraIssue.IssueType=IssueType.Id
+
{{#ifeq:
−
|fields=CONCAT('<h3>',IssueType.SectionName,'</h3>')=Name,IF (SupportingDocumentation IS NOT NULL, CONCAT (LocalContent,IF (JiraIssue.Issue IS NOT NULL, CONCAT (' (',JiraIssue.Issue,')'), ' '),' </br><b>More info</b>: ' ,SupportingDocumentation),CONCAT (LocalContent,IF (JiraIssue.Issue IS NOT NULL, CONCAT(' (',JiraIssue.Issue,')'), ' ')))
+
{{#cargo_query:tables=
−
|format=outline
+
ArticleCloudRN,
−
|outline fields=Name
+
ArticleCloudRN__ComponentId
−
|where=ComponentRN.ComponentId HOLDS '{{{Component|}}}' AND ReleaseNumber="{{{ReleaseNumber|}}}" AND LocalContent IS NOT NULL AND IssueType IS NOT NULL AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"
+
|join on=ArticleCloudRN._ID=ArticleCloudRN__ComponentId._rowID
−
|order by=IssueType.PrintOrder ASC
+
|fields=COUNT(*)
−
}}
+
|where=
−
__NOCACHE__
+
ArticleCloudRN._pageName="{{FULLPAGENAME}}"
−
{{#switch:{{NAMESPACENUMBER}}|620=<span style="font-size:80%">[[{{{Page|}}}|(Link to source)]]</span>|#default=}}</includeonly><noinclude>[[Category:RNAutomation]]</noinclude>
+
AND ArticleCloudRN._pageNamespace="{{NAMESPACENUMBER}}"
 +
|no html
 +
}}
 +
|1||{{{ComponentName|}}}:
 +
}} {{#if:{{{ReleaseDate|}}}|{{#time:F d, Y|{{{ReleaseDate|}}}}}|<span style="background-color:yellow">Date needed</span>
 +
}}<!--
 +
 
 +
DeplomymentType icons after RN heading
 +
 
 +
-->{{#cargo_query:
 +
tables=ComponentRN,
 +
DeploymentType=DT
 +
|join on=ComponentRN.DeploymentTypeId HOLDS DT.Id
 +
|fields=CONCAT('[[File:',DT.Image,'|',Size,'px|link=]]')
 +
|delimiter=
 +
        |default=
 +
|where=
 +
ComponentRN.ComponentId="{{{Component|}}}"
 +
AND ReleaseNumber="{{{ReleaseNumber|}}}"
 +
AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"
 +
AND DT.Name!="Mixed mode"
 +
}}</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:
 +
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=PEDate,
 +
MixedModeReleaseDate=MixedDate
 +
|named args=yes
 +
|format=template
 +
|template=RNPrintSubhead
 +
|default=
 +
|where=
 +
ComponentRN._pageNamespace="{{NAMESPACENUMBER}}" 
 +
AND ComponentRN.ComponentId="{{{Component|}}}"
 +
AND ReleaseNumber="{{{ReleaseNumber|}}}"
 +
AND DT.Name="Private Edition"
 +
}}<!--
 +
 
 +
special handling for on-premises pages tagged with mixed MixedMode
 +
 
 +
-->{{#cargo_query:
 +
tables=
 +
ComponentRN,
 +
DeploymentType=DT
 +
|join on=ComponentRN.DeploymentTypeId HOLDS DT.Id
 +
|fields=
 +
CONCAT('<b>Note</b>: Availability of release ',ReleaseNumber,' for on-premises deployments is limited to select customers.')
 +
|named args=yes
 +
|default=
 +
|where=
 +
ComponentRN._pageNamespace="{{NAMESPACENUMBER}}" 
 +
AND ComponentRN.ComponentId="{{{Component|}}}"
 +
AND ReleaseNumber="{{{ReleaseNumber|}}}"
 +
AND DT.Name="Mixed mode"
 +
}}<!--
 +
 
 +
printing out the list of Issues according to their IssueCategory
 +
 
 +
-->{{#cargo_query:
 +
tables=
 +
ComponentRN,
 +
Issue,
 +
IssueCategory
 +
|join on=
 +
ComponentRN._pageName=Issue._pageName,
 +
Issue.IssueCategoryId=IssueCategory.Id
 +
|fields=
 +
IssueCategory.SectionName=Name,
 +
ReleaseNumber,
 +
ComponentId
 +
|format=template
 +
|template=RNPrintFormat
 +
|named args=yes
 +
|where=
 +
ComponentRN.ComponentId = "{{{Component|}}}"
 +
AND ReleaseNumber="{{{ReleaseNumber|}}}"  
 +
AND IssueCategoryId IS NOT NULL  
 +
AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"
 +
|order by=IssueCategory.PrintOrder ASC
 +
|group by=
 +
ComponentRN._pageID,
 +
IssueCategory._pageID,
 +
IssueCategory.PrintOrder,
 +
IssueCategory.SectionName,
 +
ReleaseNumber,
 +
ComponentId
 +
}}<!--
 +
 
 +
supressing cache for this page
 +
 
 +
-->__NOCACHE__<!--
 +
 
 +
adding link to the base unit RN in draft pages includeonly
 +
 
 +
-->{{#switch:{{NAMESPACENUMBER}}
 +
|620=<span style="font-size:80%">[[{{{Page|}}}|(Link to source)]]</span>
 +
|#default=
 +
}}</includeonly><!--
 +
 
 +
setting categories for this page, including TrackConstants as this page includes some hard-coded values
 +
--><noinclude>[[Category:RNAutomation]][[Category:ComponentRN.ComponentId cleanup]][[Category:TrackConstants]]</noinclude>

Latest revision as of 17:06, October 5, 2022

Retrieved from "https://all.docs.genesys.com/Template:RNPrint (2024-11-09 18:25:05)"