Difference between revisions of "Template: GetMaxReleaseDate"
| Line 13: | Line 13: | ||
|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 | ||
| − | |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" | + | |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" |
|format=template | |format=template | ||
|group by=ComponentRN.ComponentId | |group by=ComponentRN.ComponentId | ||
| Line 21: | Line 21: | ||
}}</includeonly><noinclude>[[Category:RNAutomtion]]</noinclude> | }}</includeonly><noinclude>[[Category:RNAutomtion]]</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 | ||
| + | }} | ||
<!-- | <!-- | ||
Revision as of 13:17, April 29, 2022
Query: SELECT `cargo__ComponentRN`.`ComponentId` AS `ComponentId`,MAX(ReleaseDate) AS `ReleaseDate` FROM `cargo__ComponentRN` LEFT OUTER JOIN `cargo__ComponentRN__DeploymentTypeId` `DepId` ON ((`cargo__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 `cargo__ComponentRN`.`_pageNamespace`="0" AND `cargo__ComponentRN`.`ComponentId` HOLDS 'acaca529-aedd-4820-8557-4966ab8490db' GROUP BY `cargo__ComponentRN`.`ComponentId` ORDER BY `cargo__ComponentRN`.`ComponentId`,MAX(ReleaseDate) LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS 'acaca529-aedd-4820-8557-4966ab8490db' GROUP BY `cargo__ComponentRN`.`Com' at line 1 (127.0.0.1)