Difference between revisions of "Template: GetReleaseDetails"
From Genesys Documentation
production>Bgrenon ((by SublimeText.Mediawiker)) |
(PUBSWIKI-2672 - removed GCP icon td) |
||
(11 intermediate revisions by 2 users not shown) | |||
Line 2: | Line 2: | ||
<td><!-- get component name --> | <td><!-- get component name --> | ||
{{#cargo_query: | {{#cargo_query: | ||
− | tables=ComponentRN, | + | tables=ComponentRN,Component |
− | Component | + | |join on=ComponentRN.ComponentId=Component.Id |
− | |join on=ComponentRN.ComponentId=Component.Id | + | |fields=Component.Name |
− | |fields=Component.Name | + | |group by=Name |
− | |group by=Name | + | |where= |
− | |where= | + | ComponentId="{{{ComponentId|}}}" |
− | ComponentId="{{{ComponentId|}}}" | + | AND ReleaseDate="{{{ReleaseDate|}}}" |
− | AND ReleaseDate="{{{ReleaseDate|}}}" | ||
}} | }} | ||
</td> | </td> | ||
<td><!-- get release number --> | <td><!-- get release number --> | ||
{{#cargo_query: | {{#cargo_query: | ||
− | tables=ComponentRN | + | tables=ComponentRN |
− | |fields=MAX(ReleaseNumber) | + | |fields=MAX(ReleaseNumber) |
− | |where= | + | |where= |
− | ComponentId="{{{ComponentId|}}}" | + | ComponentId="{{{ComponentId|}}}" |
− | AND ReleaseDate="{{{ReleaseDate|}}}" | + | AND ReleaseDate="{{{ReleaseDate|}}}" |
}} | }} | ||
</td> | </td> | ||
Line 25: | Line 24: | ||
IMPORTANT: this query uses hard-coded uuids--> | IMPORTANT: this query uses hard-coded uuids--> | ||
{{#cargo_query: | {{#cargo_query: | ||
− | tables= | + | tables= |
− | ArticleCloudRN__ComponentId, | + | ArticleCloudRN__ComponentId, |
− | ArticleCloudRN, | + | ArticleCloudRN, |
− | ComponentRN, | + | ComponentRN, |
− | Component | + | Component |
− | |join on= | + | |join on= |
− | ArticleCloudRN__ComponentId._value=Component.Id, | + | ArticleCloudRN__ComponentId._value=Component.Id, |
− | ArticleCloudRN__ComponentId._rowID=ArticleCloudRN._ID, | + | ArticleCloudRN__ComponentId._rowID=ArticleCloudRN._ID, |
− | ArticleCloudRN__ComponentId._value = ComponentRN.ComponentId, | + | ArticleCloudRN__ComponentId._value = ComponentRN.ComponentId, |
− | ComponentRN.ComponentId=Component.Id | + | ComponentRN.ComponentId=Component.Id |
− | |fields= | + | |fields= |
− | CONCAT | + | CONCAT |
− | + | ( | |
− | + | '[[',ArticleCloudRN._pageName,'#',Component.Name,'-',ReleaseNumber,'|',DATE_FORMAT(MAX(ReleaseDate),'%M %d, %Y'),']]' | |
− | + | ) | |
− | |where= | + | |where= |
− | ComponentRN.ComponentId="{{{ComponentId|}}}" | + | ArticleCloudRN._pageName NOT LIKE "%/Internal%" |
− | AND ArticleCloudRN._pageNamespace=" | + | AND ComponentRN.ComponentId="{{{ComponentId|}}}" |
− | AND ReleaseDate="{{{ReleaseDate|}}}" | + | AND ArticleCloudRN._pageNamespace="{{NAMESPACENUMBER}}" |
− | AND ( | + | AND ReleaseDate="{{{ReleaseDate|}}}" |
− | + | AND ( | |
− | + | DeploymentTypeId HOLDS NOT '8b480b3c-2733-433a-9166-eab2c2d0663a' | |
− | + | OR DeploymentTypeId HOLDS NOT '577e188b-36c5-4733-86a7-e1d0d6564aff' | |
+ | ) | ||
}} | }} | ||
− | </td> | + | </td><!-- |
− | + | ||
− | <!-- get AWS icons for relevant release --> | + | get AWS icons for relevant release |
+ | |||
+ | --><td> | ||
{{#cargo_query: | {{#cargo_query: | ||
− | table= | + | table=ComponentRN,DeploymentType |
− | ComponentRN, | + | |join on=ComponentRN.DeploymentTypeId HOLDS DeploymentType.Id |
− | DeploymentType | + | |intro=<div style="margin: -10px 0 -10px 0"> |
− | |join on=ComponentRN.DeploymentTypeId HOLDS DeploymentType.Id | + | |outro=</div> |
− | |intro=<div style="margin: -10px 0 -10px 0"> | + | |fields=CONCAT('[[File:',Image,'|',Size,'px|link=]]') |
− | |outro=</div> | + | |delimiter= |
− | |fields=CONCAT('[[File:',Image,'|',Size,'px|link=]]') | + | |where= |
− | |delimiter= | + | ComponentId="{{{ComponentId|}}}" |
− | |where= | + | AND ReleaseDate="{{{ReleaseDate|}}}" |
− | ComponentId="{{{ComponentId|}}}" | + | AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}" |
− | AND ReleaseDate="{{{ReleaseDate|}}}" | + | AND DeploymentType.Id="ec194bf2-b79a-436d-8ff6-eaff94d9f43a" |
− | AND ComponentRN._pageNamespace=" | + | |default= |
− | AND DeploymentType.Id=" | ||
− | |default= | ||
}} | }} | ||
− | </td> | + | </td><!-- |
− | + | ||
− | <!-- get Azure icons for relevant release | + | get Azure icons for relevant release |
− | + | ||
− | + | --><td> | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | <td> | ||
{{#cargo_query: | {{#cargo_query: | ||
− | table=ComponentRN,DeploymentType | + | table= |
− | |join on=ComponentRN.DeploymentTypeId HOLDS DeploymentType.Id | + | ComponentRN, |
− | |intro=<div style="margin: -10px 0 -10px 0"> | + | DeploymentType |
− | |outro=</div> | + | |join on=ComponentRN.DeploymentTypeId HOLDS DeploymentType.Id |
− | |fields=CONCAT('[[File:',Image,'|',Size,'px|link=]]') | + | |intro=<div style="margin: -10px 0 -10px 0"> |
− | |delimiter= | + | |outro=</div> |
− | |where= | + | |fields=CONCAT('[[File:',Image,'|',Size,'px|link=]]') |
− | ComponentId="{{{ComponentId|}}}" | + | |delimiter= |
− | AND ReleaseDate="{{{ReleaseDate|}}}" | + | |where= |
− | AND ComponentRN._pageNamespace=" | + | ComponentId="{{{ComponentId|}}}" |
− | AND DeploymentType.Id=" | + | AND ReleaseDate="{{{ReleaseDate|}}}" |
− | |default= | + | AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}" |
+ | AND DeploymentType.Id="5439f1be-1868-4091-b058-1667389b6ce1" | ||
+ | |default= | ||
}} | }} | ||
</td> | </td> | ||
<td> | <td> | ||
<!-- get HighlightBoilerplateId and send to formatting template -->{{#cargo_query: | <!-- get HighlightBoilerplateId and send to formatting template -->{{#cargo_query: | ||
− | tables=ComponentRN | + | tables=ComponentRN |
− | |fields=HighlightBoilerplateId | + | |fields=HighlightBoilerplateId,ReleaseNumber,ComponentId |
− | |format=template | + | |format=template |
− | |template=PrintHighlightBoilerplate | + | |template=PrintHighlightBoilerplate |
− | |named args=yes | + | |named args=yes |
− | |where= | + | |where= |
− | ComponentRN._pageNamespace=" | + | ComponentRN._pageNamespace="{{NAMESPACENUMBER}}" |
− | AND ComponentId="{{{ComponentId|}}}" | + | AND ComponentId="{{{ComponentId|}}}" |
− | AND ReleaseDate="{{{ReleaseDate|}}}" | + | AND ReleaseDate="{{{ReleaseDate|}}}" |
− | + | |default= | |
− | |default= | ||
}}<!-- get Highlight from each release -->{{#cargo_query: | }}<!-- get Highlight from each release -->{{#cargo_query: | ||
− | tables=ComponentRN | + | tables=ComponentRN |
− | |fields=Highlight | + | |fields=Highlight |
− | |where= | + | |where= |
− | ComponentId="{{{ComponentId|}}}" | + | ComponentId="{{{ComponentId|}}}" |
− | AND ReleaseDate="{{{ReleaseDate|}}}" | + | AND ReleaseDate="{{{ReleaseDate|}}}" |
− | AND ComponentRN._pageNamespace=" | + | AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}" |
− | |default= | + | |default= |
}} | }} | ||
</tr></includeonly><noinclude>[[Category:PrivateEdition]][[Category:ComponentRN.ComponentId cleanup]]</noinclude> | </tr></includeonly><noinclude>[[Category:PrivateEdition]][[Category:ComponentRN.ComponentId cleanup]]</noinclude> |