Difference between revisions of "Template: ListRNs"
From Genesys Documentation
| Line 5: | Line 5: | ||
|join on=ComponentRN.ComponentId HOLDS Component.Id | |join on=ComponentRN.ComponentId HOLDS Component.Id | ||
|fields=ComponentRN._pageName=URL,ReleaseNumber,ReleaseDate | |fields=ComponentRN._pageName=URL,ReleaseNumber,ReleaseDate | ||
| − | |where=ComponentRN.ComponentId HOLDS "{{{ComponentId|}}}" | + | |where=ComponentRN.ComponentId HOLDS "{{{ComponentId|}}}" AND ComponentRN._pageNamespace="620" |
|limit=10000 | |limit=10000 | ||
|default=No RNs - yet! | |default=No RNs - yet! | ||
}} | }} | ||
Revision as of 20:04, August 24, 2021
{{{Component}}}
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__ComponentRN`.`_pageName` AS `URL`,`ReleaseNumber` AS `ReleaseNumber`,`ReleaseDate` AS `ReleaseDate` FROM `cargo__ComponentRN` LEFT OUTER JOIN `cargo__Component` ON ((`cargo__ComponentRN`.`ComponentId` HOLDS `cargo__Component`.`Id`)) WHERE `cargo__ComponentRN`.`ComponentId` HOLDS "" AND `cargo__ComponentRN`.`_pageNamespace`="620" ORDER BY `cargo__ComponentRN`.`_pageName`,`ReleaseNumber`,`ReleaseDate` LIMIT 5000 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 `cargo__Component`.`Id`)) WHERE `cargo__ComponentRN`.`ComponentId` HOLDS' at line 1 (127.0.0.1)