Difference between revisions of "Template: GetMaxReleaseDate"
From Genesys Documentation
| Line 5: | Line 5: | ||
|fields=ComponentRN.ComponentId=ComponentId,MAX(ReleaseDate)=ReleaseDate | |fields=ComponentRN.ComponentId=ComponentId,MAX(ReleaseDate)=ReleaseDate | ||
|where=PrivateEditionReleaseDate IS NULL AND ComponentId HOLDS '{{{ComponentId|}}}' AND ReleaseDate IS NOT NULL AND ComponentRN._pageNamespace="0" | |where=PrivateEditionReleaseDate IS NULL AND ComponentId HOLDS '{{{ComponentId|}}}' AND ReleaseDate IS NOT NULL AND ComponentRN._pageNamespace="0" | ||
| − | |format=template | + | <!--|format=template |
|template=GetReleaseDetails | |template=GetReleaseDetails | ||
| − | |named args=yes | + | |named args=yes--> |
| − | }}<!-- | + | }}</includeonly><noinclude>[[Category:RNAutomtion]]</noinclude> |
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | <!-- | ||
| + | {{#cargo_query: | ||
| + | tables=ComponentRN,ComponentRN__DeploymentTypeId=DepId,ComponentRN__ComponentId=CompId | ||
| + | |fields=ComponentRN.ComponentId=ComponentId,MAX(ReleaseDate)=ReleaseDate | ||
| + | |join on=ComponentRN._ID=DepId._rowID,DepId._rowID=CompId._rowID | ||
| + | |where=CompId._value="acaca529-aedd-4820-8557-4966ab8490db" 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" | ||
| + | }} | ||
| + | |||
| + | |||
TEST:{{#cargo_query: | TEST:{{#cargo_query: | ||
tables=ComponentRN,ComponentRN__DeploymentTypeId=DepId | tables=ComponentRN,ComponentRN__DeploymentTypeId=DepId | ||
| Line 19: | Line 36: | ||
|template=GetReleaseDetails | |template=GetReleaseDetails | ||
|named args=yes | |named args=yes | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
}} | }} | ||
Revision as of 13:34, April 29, 2022