Difference between revisions of "Template: GetReleaseDetails"
From Genesys Documentation
| Line 18: | Line 18: | ||
<td><!-- get release date and format as link to ArticleCloudRN page --> | <td><!-- get release date and format as link to ArticleCloudRN page --> | ||
{{#cargo_query: | {{#cargo_query: | ||
| − | tables=ComponentRN | + | tables=ArticleCloudRN__ComponentId,ArticleCloudRN,Component,ComponentRN__ComponentId,ComponentRN |
| + | |join on=ArticleCloudRN__ComponentId._value=Component.Id,ArticleCloudRN__ComponentId._rowID=ArticleCloudRN._ID,ArticleCloudRN__ComponentId._value = ComponentRN__ComponentId._value,ComponentRN__ComponentId._rowID=ComponentRN._ID | ||
| + | |fields=CONCAT('[[',ArticleCloudRN._pageName,'#',DATE_FORMAT(MAX(ReleaseDate),'%M %d, %Y'),'|',DATE_FORMAT(MAX(ReleaseDate),'%M %d, %Y'),']]') | ||
| + | |where=ComponentRN__ComponentId._value="{{{ComponentId|}}}" AND ArticleCloudRN._pageNamespace="0" AND ReleaseDate="{{{ReleaseDate|}}}" | ||
| + | |group by=ComponentRN.ComponentId | ||
| + | }} | ||
| + | </td> | ||
| + | <td> | ||
| + | <!-- finding deployment type icons --> | ||
| + | {{#cargo_query: | ||
| + | tables=ComponentRN,DeploymentType | ||
| + | |join on=ComponentRN.DeploymentTypeId=DeploymentType.Id | ||
|fields=CONCAT('[[File:',Image,'|80px]]') | |fields=CONCAT('[[File:',Image,'|80px]]') | ||
|where=ComponentId HOLDS '{{{ComponentId|}}}' AND ReleaseDate="{{{ReleaseDate|}}}" AND ComponentRN._pageNamespace="0" | |where=ComponentId HOLDS '{{{ComponentId|}}}' AND ReleaseDate="{{{ReleaseDate|}}}" AND ComponentRN._pageNamespace="0" | ||
}} | }} | ||
| − | |||
| − | |||
| − | |||
</td> | </td> | ||
</tr></includeonly><noinclude>[[Category:PrivateEdition]]</noinclude> | </tr></includeonly><noinclude>[[Category:PrivateEdition]]</noinclude> | ||