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,Component | tables=ComponentRN,Component | ||
|join on=ComponentRN.ComponentId HOLDS Component.Id | |join on=ComponentRN.ComponentId HOLDS Component.Id | ||
| Line 8: | Line 8: | ||
|template=GetReleaseDetails | |template=GetReleaseDetails | ||
|named args=yes | |named args=yes | ||
| − | }} | + | }}--> |
TEST:{{#cargo_query: | TEST:{{#cargo_query: | ||
| − | tables=ComponentRN,ComponentRN__DeploymentTypeId=DepId | + | tables=ComponentRN,ComponentRN__DeploymentTypeId=DepId,ComponentRN__ComponentId=CompId |
|fields=ComponentRN.ComponentId=ComponentId,MAX(ReleaseDate)=ReleaseDate | |fields=ComponentRN.ComponentId=ComponentId,MAX(ReleaseDate)=ReleaseDate | ||
| − | |join on=ComponentRN._ID=DepId._rowID | + | |join on=ComponentRN._ID=DepId._rowID,ComponentRN._ID=CompId |
| − | |where=DepId._value='5439f1be-1868-4091-b058-1667389b6ce1' OR DepId._value='ec194bf2-b79a-436d-8ff6-eaff94d9f43a' | + | |where=DepId._value='5439f1be-1868-4091-b058-1667389b6ce1' OR DepId._value='ec194bf2-b79a-436d-8ff6-eaff94d9f43a' AND CompId="{{{ComponentId|}}}" AND ReleaseDate IS NOT NULL AND ComponentRN._pageNamespace="0" |
| + | |format=template | ||
|group by=ComponentRN.ComponentId | |group by=ComponentRN.ComponentId | ||
|format=template | |format=template | ||
| Line 20: | Line 21: | ||
}}</includeonly><noinclude>[[Category:RNAutomtion]]</noinclude> | }}</includeonly><noinclude>[[Category:RNAutomtion]]</noinclude> | ||
| − | + | <!-- | |
{{#cargo_query: | {{#cargo_query: | ||
| Line 39: | Line 40: | ||
|where=authorA._value='Leo Tolstoy' OR authorA._value='Dostoevsky' | |where=authorA._value='Leo Tolstoy' OR authorA._value='Dostoevsky' | ||
|group by=Books._pageName | |group by=Books._pageName | ||
| − | }} | + | }}--> |
Revision as of 12:58, April 29, 2022