Difference between revisions of "Template: GetMaxReleaseDate"
From Genesys Documentation
| Line 10: | Line 10: | ||
}}--> | }}--> | ||
TEST:{{#cargo_query: | TEST:{{#cargo_query: | ||
| − | tables=ComponentRN,ComponentRN__DeploymentTypeId=DepId | + | tables=ComponentRN,ComponentRN__DeploymentTypeId=DepId |
|fields=ComponentRN.ComponentId=ComponentId,MAX(ReleaseDate)=ReleaseDate | |fields=ComponentRN.ComponentId=ComponentId,MAX(ReleaseDate)=ReleaseDate | ||
| − | |join on=ComponentRN._ID=DepId | + | |join on=ComponentRN._ID=DepId._rowID |
| − | |where=DepId._value='5439f1be-1868-4091-b058-1667389b6ce1' OR DepId._value='ec194bf2-b79a-436d-8ff6-eaff94d9f43a' AND | + | |where=DepId._value='5439f1be-1868-4091-b058-1667389b6ce1' OR DepId._value='ec194bf2-b79a-436d-8ff6-eaff94d9f43a' AND ComponentRN.ComponentId HOLDS '{{{ComponentId|}}}' AND ReleaseDate IS NOT NULL AND ComponentRN._pageNamespace="0" |
|format=template | |format=template | ||
|group by=ComponentRN.ComponentId | |group by=ComponentRN.ComponentId | ||
Revision as of 13:03, April 29, 2022