Difference between revisions of "Template: GetReleaseDetails"
From Genesys Documentation
Line 2: | Line 2: | ||
<td><!-- get component name --> | <td><!-- get component name --> | ||
{{#cargo_query: | {{#cargo_query: | ||
− | + | tables=ComponentRN, | |
− | + | Component | |
− | + | |join on=ComponentRN.ComponentId=Component.Id | |
− | + | |fields=Component.Name | |
− | + | |group by=Name | |
− | + | |where= | |
− | + | ComponentId="{{{ComponentId|}}}" | |
+ | AND ReleaseDate="{{{ReleaseDate|}}}" | ||
}} | }} | ||
</td> | </td> | ||
<td><!-- get release number --> | <td><!-- get release number --> | ||
{{#cargo_query: | {{#cargo_query: | ||
− | + | tables=ComponentRN | |
− | + | |fields=MAX(ReleaseNumber) | |
− | + | |where= | |
− | + | ComponentId="{{{ComponentId|}}}" | |
− | + | AND ReleaseDate="{{{ReleaseDate|}}}" | |
}} | }} | ||
</td> | </td> | ||
Line 24: | Line 25: | ||
IMPORTANT: this query uses hard-coded uuids--> | IMPORTANT: this query uses hard-coded uuids--> | ||
{{#cargo_query: | {{#cargo_query: | ||
− | + | tables= | |
− | + | ArticleCloudRN__ComponentId, | |
− | + | ArticleCloudRN, | |
− | + | 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= | |
− | + | 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> |
− | + | <td> | |
− | + | <!-- get AWS icons for relevant release --> | |
− | |||
− | -- | ||
{{#cargo_query: | {{#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> | |
− | + | <!-- get Azure icons for relevant release --> | |
− | |||
− | -- | ||
{{#cargo_query: | {{#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="ec194bf2-b79a-436d-8ff6-eaff94d9f43a" | |
− | + | |default= | |
− | |||
− | |||
}} | }} | ||
− | </td><!-- | + | </td> |
− | + | <!-- get GCP icons for relevant release --> | |
− | + | <td> | |
− | |||
− | --><td> | ||
{{#cargo_query: | {{#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="0cffec00-9053-4406-88d7-461255f48f53" | |
− | + | |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 | |
− | + | |fields=HighlightBoilerplateId | |
− | + | |format=template | |
− | + | |template=PrintHighlightBoilerplate | |
− | + | |named args=yes | |
− | + | |where= | |
− | + | ComponentRN._pageNamespace="{{NAMESPACENUMBER}}" | |
− | + | AND ComponentId="{{{ComponentId|}}}" | |
− | + | AND ReleaseDate="{{{ReleaseDate|}}}" | |
− | + | AND HighlightBoilerplateId IS NOT NULL | |
− | + | |default= | |
}}<!-- get Highlight from each release -->{{#cargo_query: | }}<!-- 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]][[Category:ComponentRN.ComponentId cleanup]]</noinclude> | </tr></includeonly><noinclude>[[Category:PrivateEdition]][[Category:ComponentRN.ComponentId cleanup]]</noinclude> |