Difference between revisions of "Template: PrintTopRN"
(Update package: RN Automation: Data Structure) |
|||
| Line 10: | Line 10: | ||
|delimiter= | |delimiter= | ||
|where=ComponentId HOLDS "{{{ComponentId|}}}" AND ReleaseDate="{{{ReleaseDate|}}}" AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"}}</td> | |where=ComponentId HOLDS "{{{ComponentId|}}}" AND ReleaseDate="{{{ReleaseDate|}}}" AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"}}</td> | ||
| − | <td>{{{ | + | <td>{{#cargo_query: |
| + | table=ComponentRN,DeploymentType | ||
| + | |join on=ComponentRN.DeploymentTypeId HOLDS DeploymentType.Id | ||
| + | |fields=Highlight | ||
| + | |group by=Highlight | ||
| + | |delimiter= | ||
| + | |where=ComponentId HOLDS "{{{ComponentId|}}}" AND ReleaseDate="{{{ReleaseDate|}}}" AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"}}</td> | ||
</tr> | </tr> | ||
<noinclude>[[Category:RNAutomation]]</noinclude> | <noinclude>[[Category:RNAutomation]]</noinclude> | ||
Revision as of 22:50, April 12, 2021
Query: SELECT CONCAT('50px') FROM `cargo__ComponentRN` LEFT OUTER JOIN `cargo__ComponentRN__DeploymentTypeId` ON ((`cargo__ComponentRN`.`_ID`=`cargo__ComponentRN__DeploymentTypeId`.`_rowID`)) RIGHT OUTER JOIN `cargo__DeploymentType` ON ((`cargo__ComponentRN__DeploymentTypeId`.`_value`=`cargo__DeploymentType`.`Id`)) WHERE ComponentId HOLDS "" AND ReleaseDate="" AND `cargo__ComponentRN`.`_pageNamespace`="10" ORDER BY CONCAT('50px') 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 "" AND ReleaseDate="" AND `cargo__ComponentRN`.`_pageNamespace`="10" ORDE' at line 1 (127.0.0.1)
Query: SELECT `Highlight` AS `Highlight` FROM `cargo__ComponentRN` LEFT OUTER JOIN `cargo__ComponentRN__DeploymentTypeId` ON ((`cargo__ComponentRN`.`_ID`=`cargo__ComponentRN__DeploymentTypeId`.`_rowID`)) RIGHT OUTER JOIN `cargo__DeploymentType` ON ((`cargo__ComponentRN__DeploymentTypeId`.`_value`=`cargo__DeploymentType`.`Id`)) WHERE ComponentId HOLDS "" AND ReleaseDate="" AND `cargo__ComponentRN`.`_pageNamespace`="10" GROUP BY `Highlight` ORDER BY `Highlight` 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 "" AND ReleaseDate="" AND `cargo__ComponentRN`.`_pageNamespace`="10" GROU' at line 1 (127.0.0.1)