Difference between revisions of "Template: GetReleaseDetails"
From Genesys Documentation
(Adding AND (DeploymentTypeId HOLDS 'ec194bf2-b79a-436d-8ff6-eaff94d9f43a' OR DeploymentTypeId HOLDS '5439f1be-1868-4091-b058-1667389b6ce1')) |
|||
| Line 6: | Line 6: | ||
|fields=Component.Name | |fields=Component.Name | ||
|group by=Name | |group by=Name | ||
| − | |where=ComponentId HOLDS '{{{ComponentId|}}}' AND ReleaseDate="{{{ReleaseDate|}}}" AND ComponentRN._pageNamespace="0" | + | |where=ComponentId HOLDS '{{{ComponentId|}}}' AND ReleaseDate="{{{ReleaseDate|}}}" AND ComponentRN._pageNamespace="0" AND (DeploymentTypeId HOLDS 'ec194bf2-b79a-436d-8ff6-eaff94d9f43a' OR DeploymentTypeId HOLDS '5439f1be-1868-4091-b058-1667389b6ce1') |
}} | }} | ||
</td> | </td> | ||
| Line 13: | Line 13: | ||
tables=ComponentRN | tables=ComponentRN | ||
|fields=MAX(ReleaseNumber) | |fields=MAX(ReleaseNumber) | ||
| − | |where=ComponentId HOLDS '{{{ComponentId|}}}' AND ReleaseDate="{{{ReleaseDate|}}}" AND ComponentRN._pageNamespace="0" | + | |where=ComponentId HOLDS '{{{ComponentId|}}}' AND ReleaseDate="{{{ReleaseDate|}}}" AND ComponentRN._pageNamespace="0" AND (DeploymentTypeId HOLDS 'ec194bf2-b79a-436d-8ff6-eaff94d9f43a' OR DeploymentTypeId HOLDS '5439f1be-1868-4091-b058-1667389b6ce1') |
}} | }} | ||
</td> | </td> | ||
| Line 21: | Line 21: | ||
|join on=ArticleCloudRN__ComponentId._value=Component.Id,ArticleCloudRN__ComponentId._rowID=ArticleCloudRN._ID,ArticleCloudRN__ComponentId._value = ComponentRN__ComponentId._value,ComponentRN__ComponentId._rowID=ComponentRN._ID | |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'),']]') | |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|}}}" | + | |where=ComponentRN__ComponentId._value="{{{ComponentId|}}}" AND ArticleCloudRN._pageNamespace="0" AND ReleaseDate="{{{ReleaseDate|}}}" AND (DeploymentTypeId HOLDS 'ec194bf2-b79a-436d-8ff6-eaff94d9f43a' OR DeploymentTypeId HOLDS '5439f1be-1868-4091-b058-1667389b6ce1') |
|group by=ComponentRN.ComponentId | |group by=ComponentRN.ComponentId | ||
}} | }} | ||
| Line 34: | Line 34: | ||
|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="0" AND | + | |where=ComponentId HOLDS "{{{ComponentId|}}}" AND ReleaseDate="{{{ReleaseDate|}}}" AND ComponentRN._pageNamespace="0" AND (DeploymentTypeId HOLDS 'ec194bf2-b79a-436d-8ff6-eaff94d9f43a' OR DeploymentTypeId HOLDS '5439f1be-1868-4091-b058-1667389b6ce1') |
</td> | </td> | ||
<td> | <td> | ||
| Line 43: | Line 43: | ||
|template=PrintHighlightBoilerplate | |template=PrintHighlightBoilerplate | ||
|named args=yes | |named args=yes | ||
| − | |where=ComponentId HOLDS '{{{ComponentId|}}}' AND ReleaseDate="{{{ReleaseDate|}}}" AND ComponentRN._pageNamespace="0" AND HighlightBoilerplateId IS NOT NULL | + | |where=ComponentId HOLDS '{{{ComponentId|}}}' AND ReleaseDate="{{{ReleaseDate|}}}" AND ComponentRN._pageNamespace="0" AND HighlightBoilerplateId IS NOT NULL AND (DeploymentTypeId HOLDS 'ec194bf2-b79a-436d-8ff6-eaff94d9f43a' OR DeploymentTypeId HOLDS '5439f1be-1868-4091-b058-1667389b6ce1') |
|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=ComponentId HOLDS '{{{ComponentId|}}}' AND ReleaseDate="{{{ReleaseDate|}}}" AND ComponentRN._pageNamespace="0" | + | |where=ComponentId HOLDS '{{{ComponentId|}}}' AND ReleaseDate="{{{ReleaseDate|}}}" AND ComponentRN._pageNamespace="0" AND (DeploymentTypeId HOLDS 'ec194bf2-b79a-436d-8ff6-eaff94d9f43a' OR DeploymentTypeId HOLDS '5439f1be-1868-4091-b058-1667389b6ce1') |
|default= | |default= | ||
}} | }} | ||
</tr></includeonly><noinclude>[[Category:PrivateEdition]]</noinclude> | </tr></includeonly><noinclude>[[Category:PrivateEdition]]</noinclude> | ||