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