Difference between revisions of "User: Bgrenon/3"
From Genesys Documentation
(Replaced content with "{{#cargo_query: tables=ComponentRN,Component |join on=ComponentRN.ComponentId HOLDS Component.Id |fields=Component.Name=Component,ComponentRN.ComponentId=ComponentId |form...") (Tag: Replaced) |
|||
| Line 1: | Line 1: | ||
| + | ==Find all draft Base Unit RNs for your component== | ||
| + | |||
{{#cargo_query: | {{#cargo_query: | ||
tables=ComponentRN,Component | tables=ComponentRN,Component | ||
Revision as of 19:46, August 24, 2021
Find all draft Base Unit RNs for your component[ | edit source]
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__Component`.`Name` AS `Component`,`cargo__ComponentRN`.`ComponentId` AS `ComponentId` FROM `cargo__ComponentRN` LEFT OUTER JOIN `cargo__Component` ON ((`cargo__ComponentRN`.`ComponentId` HOLDS `cargo__Component`.`Id`)) GROUP BY `cargo__Component`.`Name` ORDER BY `cargo__Component`.`Name`,`cargo__ComponentRN`.`ComponentId` 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`)) GROUP BY `cargo__Component`.`Name` ORDER BY `' at line 1 (127.0.0.1)