Difference between revisions of "Template: GetReleaseDetails"
From Genesys Documentation
| Line 6: | Line 6: | ||
|fields=Component.Name | |fields=Component.Name | ||
|group by=Name | |group by=Name | ||
| − | |where=ComponentId HOLDS '{{{ComponentId|}}}' AND ReleaseDate="{{{ReleaseDate|}}}" | + | |where=ComponentId HOLDS '{{{ComponentId|}}}' AND ReleaseDate="{{{ReleaseDate|}}}" |
}} | }} | ||
</td> | </td> | ||
| Line 13: | Line 13: | ||
tables=ComponentRN | tables=ComponentRN | ||
|fields=MAX(ReleaseNumber) | |fields=MAX(ReleaseNumber) | ||
| − | |where=ComponentId HOLDS '{{{ComponentId|}}}' AND ReleaseDate="{{{ReleaseDate|}}}" | + | |where=ComponentId HOLDS '{{{ComponentId|}}}' AND ReleaseDate="{{{ReleaseDate|}}}" |
}} | }} | ||
</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|}}}" AND (DeploymentTypeId HOLDS ' | + | |where=ComponentRN__ComponentId._value="{{{ComponentId|}}}" AND ArticleCloudRN._pageNamespace="0" AND ReleaseDate="{{{ReleaseDate|}}}" AND (DeploymentTypeId HOLDS NOT '8b480b3c-2733-433a-9166-eab2c2d0663a' OR DeploymentTypeId HOLDS NOT '577e188b-36c5-4733-86a7-e1d0d6564aff') |
|group by=ComponentRN.ComponentId | |group by=ComponentRN.ComponentId | ||
}} | }} | ||