|
|
| (12 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 |
| − | {{#cargo_query:
| |
| − | tables=ComponentRN,ComponentRN__DeploymentTypeId=DepId,ComponentRN__ComponentId=CompId
| |
| − | |fields=CompId._value=ComponentId,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"
| |
| − | |format=template
| |
| − | |template=GetReleaseDetails
| |
| − | |named args=yes
| |
| − | }}
| |
| − | <!--{{#cargo_query:
| |
| − | tables=ComponentRN,Component
| |
| − | |join on=ComponentRN.ComponentId HOLDS Component.Id
| |
| − | |fields=ComponentRN.ComponentId=ComponentId,MAX(ReleaseDate)=ReleaseDate
| |
| − | |where=PrivateEditionReleaseDate IS NULL AND ComponentId HOLDS '{{{ComponentId|}}}' AND ReleaseDate IS NOT NULL AND ComponentRN._pageNamespace="0"
| |
| − | |format=template
| |
| − | |template=GetReleaseDetails
| |
| − | |named args=yes
| |
| − | }}--></includeonly><noinclude>[[Category:RNAutomtion]]</noinclude>
| |
| | | | |
| − | | + | IMPORTANT: this query uses hard coded uui values --> |
| − | | |
| − | | |
| − | | |
| − | | |
| − | | |
| − | | |
| − | <!--
| |
| | {{#cargo_query: | | {{#cargo_query: |
| − | tables=ComponentRN,ComponentRN__DeploymentTypeId=DepId,ComponentRN__ComponentId=CompId | + | tables=ComponentRN, |
| − | |fields=ComponentRN.ComponentId=ComponentId,MAX(ReleaseDate)=ReleaseDate
| + | ComponentRN__DeploymentTypeId=DepId |
| − | |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:
| |
| − | tables=ComponentRN,ComponentRN__DeploymentTypeId=DepId
| |
| − | |fields=ComponentRN.ComponentId=ComponentId,MAX(ReleaseDate)=ReleaseDate
| |
| | |join on=ComponentRN._ID=DepId._rowID | | |join on=ComponentRN._ID=DepId._rowID |
| − | |where=ComponentRN.ComponentId HOLDS '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" | + | |fields=ComponentRN.ComponentId=ComponentId, |
| − | |format=template
| + | MAX(ReleaseDate)=ReleaseDate |
| − | |group by=ComponentRN.ComponentId
| + | |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> |
| − | | |
| − | {{#cargo_query:
| |
| − | tables=ComponentRN,ComponentRN__DeploymentTypeId=DepId
| |
| − | |fields=ComponentRN.ComponentId=ComponentId,MAX(ReleaseDate)=ReleaseDate
| |
| − | |join on=ComponentRN._ID=DepId._rowID
| |
| − | |where=DepId._value='5439f1be-1868-4091-b058-1667389b6ce1' OR DepId._value='ec194bf2-b79a-436d-8ff6-eaff94d9f43a' AND ReleaseDate IS NOT NULL AND ComponentRN._pageNamespace="0" AND ComponentRN.ComponentId HOLDS 'acaca529-aedd-4820-8557-4966ab8490db'
| |
| − | |format=template
| |
| − | |group by=ComponentRN.ComponentId
| |
| − | |format=template
| |
| − | |template=GetReleaseDetails
| |
| − | |named args=yes
| |
| − | }}
| |
| − | | |
| − | {{#cargo_query:
| |
| − | tables=ComponentRN,ComponentRN__DeploymentTypeId=DepId
| |
| − | |fields=ComponentRN.ComponentId=ComponentId,MAX(ReleaseDate)=ReleaseDate
| |
| − | |join on=ComponentRN._ID=DepId._rowID
| |
| − | |where=DepId._value='5439f1be-1868-4091-b058-1667389b6ce1' OR DepId._value='ec194bf2-b79a-436d-8ff6-eaff94d9f43a'
| |
| − | |group by=ComponentRN.ComponentId
| |
| − | |format=template
| |
| − | |template=GetReleaseDetails
| |
| − | |named args=yes
| |
| − | }}
| |
| − | | |
| − | {{#cargo_query:
| |
| − | tables=Books, Books__Authors=authorA
| |
| − | |fields=Books._pageName,Books.Authors__full
| |
| − | |join on=Books._ID=authorA._rowID
| |
| − | |where=authorA._value='Leo Tolstoy' OR authorA._value='Dostoevsky'
| |
| − | |group by=Books._pageName
| |
| − | }}-->
| |
