Rank: Member
Groups: Registered
Joined: 6/9/2017(UTC) Posts: 29  Thanks: 1 times
|
Hello,
The pre-defined joined in our application are defined as inner joins, which works fine for most reports. But on some occasions, a user may need to use outer joins to get the results they need. An example could be getting a list of customers and their orders over the last month, the user would want to see all customers listed even if they didn't place an order during this period.
Is there a way to override the pre-defined joins to user outer joins instead for a given report? I'm looking for a simple option a non-technical user could use, such as selecting an 'outer join' property at the model level.
Thanks
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Normally the Join type is defined in the Data Source...so the first try could be to change this.
You cannot change the join type in the model (in this current version)...
A way to do it could be: Define another table in the Data Source with another alias (copy of the initial table) and define another Join type on this table, change the element category.
This will duplicate your elements definition, but depending on the elements chosen in the model, the join will be inner or outer.
Good luck.
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 6/9/2017(UTC) Posts: 29 Thanks: 1 times
|
Thanks for the quick reply.
I tried what you suggested and it worked, although it means that I would need quite a lot of tables to be copied.
Any chance a feature like this could be added to the model definition?
YC
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Yes, this could be a feature request...but no plan to do it so far.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
