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