We use the DotSyntac & Dynamic archive provider extensively when building custom apps & integration, a situation we have a lot, especially with the use of extra tables, is that we want to join from an extra table to another table but that relation isn't defined in the database model. The DotSyntax documentation says the following about this:
"Additionally, all join field and table names must be valid, by reference to the runtime dictionary; but note that right-joins as well as left-joins using the square-bracket syntax to specify target table do not need to correspond to relations declared in the dictionary. "
I have tried to to make this work multiple times but have not come up succesfull.
Extra table name "y_sample', containing the field x_associate_id (not an relation that is possible to defined on an extra table).
We want to join immediately to the associate table to get the name, so we dont need to use a seperate query.
Could an example be provided how to join a table using an relation which isn't defined in the database model?