Difference between revisions of "Template: GetMaxReleaseDate"
From Genesys Documentation
| (22 intermediate revisions by 3 users not shown) | |||
| 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 |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| + | IMPORTANT: this query uses hard coded uui values --> | ||
{{#cargo_query: | {{#cargo_query: | ||
| − | tables=ComponentRN,ComponentRN__DeploymentTypeId=DepId | + | tables=ComponentRN, |
| − | + | ComponentRN__DeploymentTypeId=DepId | |
|join on=ComponentRN._ID=DepId._rowID | |join on=ComponentRN._ID=DepId._rowID | ||
| − | |where=DepId._value='5439f1be-1868-4091-b058-1667389b6ce1' OR DepId._value='ec194bf2-b79a-436d-8ff6-eaff94d9f43a' | + | |fields=ComponentRN.ComponentId=ComponentId, |
| − | + | MAX(ReleaseDate)=ReleaseDate | |
| + | |where=ComponentRN._pageNamespace="0" | ||
| + | AND ComponentRN.ComponentId="{{{ComponentId|}}}" | ||
| + | AND (DepId._value='5439f1be-1868-4091-b058-1667389b6ce1' OR DepId._value='ec194bf2-b79a-436d-8ff6-eaff94d9f43a') | ||
|format=template | |format=template | ||
|template=GetReleaseDetails | |template=GetReleaseDetails | ||
|named args=yes | |named args=yes | ||
}} | }} | ||
| − | + | </includeonly><noinclude>[[Category:RNAutomtion]][[Category:TrackConstants]][[Category:ComponentRN.ComponentId cleanup]]</noinclude> | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||