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