Creating new Entity with uppercase letter in the middle of entity name causes errors

Q&A
1

When attempting to create a new hierarchy Entity with the name “PrintCatalog” errors occur when creating the database structure. The system creates a database table named “print_category_hierarchy”, but the frontend code appears to be looking for a table named “printcategory_hierarchy”.

Work_—_AtroPIM___Entities
Work_—_AtroPIM___Entities902×390 22.3 KB

Database tables:

Navicat_Premium
Navicat_Premium824×184 27.7 KB

Front-end error:

Work_—_AtroPIM___Trade_Product_Guide_2024
Work_—_AtroPIM___Trade_Product_Guide_20241148×171 17.6 KB

Removing the second uppercase character in the Entity name appears to resolve the issue. ie. Changing “PrintCatalog” to “Printcatalog”.

Work_—_AtroPIM___Entities-2
Work_—_AtroPIM___Entities-2895×316 16 KB

2

Quite strange. All uppercases should mutate into underscore. Our QA department will check it.