Difference between revisions of "Template: GetMaxReleaseDate"
From Genesys Documentation
| Line 1: | Line 1: | ||
<includeonly><!-- Finding the MAX ReleaseDate and passing that and ComponentId to formatting template --> | <includeonly><!-- Finding the MAX ReleaseDate and passing that and ComponentId to formatting template --> | ||
{{#cargo_query: | {{#cargo_query: | ||
| + | tables=ComponentRN,ComponentRN__DeploymentTypeId=DepId,ComponentRN__ComponentId=CompId | ||
| + | |fields=CompId._value,MAX(ReleaseDate)=ReleaseDate | ||
| + | |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" | ||
| + | }} | ||
| + | <!--{{#cargo_query: | ||
tables=ComponentRN,Component | tables=ComponentRN,Component | ||
|join on=ComponentRN.ComponentId HOLDS Component.Id | |join on=ComponentRN.ComponentId HOLDS Component.Id | ||
| Line 8: | Line 14: | ||
|template=GetReleaseDetails | |template=GetReleaseDetails | ||
|named args=yes--> | |named args=yes--> | ||
| − | }}</includeonly><noinclude>[[Category:RNAutomtion]]</noinclude> | + | }}--></includeonly><noinclude>[[Category:RNAutomtion]]</noinclude> |
Revision as of 13:46, April 29, 2022