Difference between revisions of "Template: RNPrint"
From Genesys Documentation
(23 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 | + | Creating section heading |
− | |fields=CONCAT('[[File:',DT.Image,'| | + | |
− | |delimiter= | + | --><h2> |
− | |where=ComponentRN.ComponentId | + | {{#ifeq: |
− | }}<!-- | + | {{#cargo_query:tables= |
− | {{#cargo_query: | + | ArticleCloudRN, |
− | tables=ComponentRN, | + | ArticleCloudRN__ComponentId |
− | |join on=ComponentRN. | + | |join on=ArticleCloudRN._ID=ArticleCloudRN__ComponentId._rowID |
− | |fields= | + | |fields=COUNT(*) |
− | |where=ComponentRN.ComponentId | + | |where= |
− | }}--> | + | ArticleCloudRN._pageName="{{FULLPAGENAME}}" |
− | tables=ComponentRN,DeploymentType=DT | + | AND ArticleCloudRN._pageNamespace="{{NAMESPACENUMBER}}" |
− | |join on=ComponentRN.DeploymentTypeId HOLDS DT.Id | + | |no html |
− | |fields=CONCAT(' | + | }} |
− | | | + | |1||{{{ComponentName|}}}: |
− | + | }} {{#if:{{{ReleaseDate|}}}|{{#time:F d, Y|{{{ReleaseDate|}}}}}|<span style="background-color:yellow">Date needed</span> | |
− | }} | + | }}<!-- |
− | {{#cargo_query: | + | |
− | tables=ComponentRN,Issue,IssueCategory | + | DeplomymentType icons after RN heading |
− | |join on=ComponentRN._pageName=Issue._pageName,Issue.IssueCategoryId=IssueCategory.Id | + | |
− | |fields= | + | -->{{#cargo_query: |
− | |format= | + | tables=ComponentRN, |
− | | | + | DeploymentType=DT |
− | |where=ComponentRN.ComponentId | + | |join on=ComponentRN.DeploymentTypeId HOLDS DT.Id |
− | |order by=IssueCategory.PrintOrder ASC | + | |fields=CONCAT('[[File:',DT.Image,'|',Size,'px|link=]]') |
− | }} | + | |delimiter= |
− | __NOCACHE__ | + | |default= |
− | {{#switch:{{NAMESPACENUMBER}}|620=<span style="font-size:80%">[[{{{Page|}}}|(Link to source)]]</span>|#default=}}</includeonly><noinclude>[[Category:RNAutomation]]</noinclude> | + | |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> |