When creating Reports, the table names for joining tables are case-sensitive in the query engine.
Due to the setup of the reporting screen and engine, you cannot make 2 different connections to the same table.
Case: Disappearing relations in a previously saved report.
- create a report with relations between tables
- next add more relations to those tables in the configuration
- display the report definition
The relations will first be loaded from the configuration and next overwritten by the relations defined in the report.
Cause: The report definition saves relation according to their position in the report. If a new relation in the configuration changes the order of the relations, the new relation can be overwritten in the report, making it harder to use that relation.
Solution: In this case you can add the relation manually to the report or recreate the report from scratch.