logo

Warning: The forum is now for consultation only. Please use GitHub Discussions to post any questions or comments.


Welcome Guest ! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Ott  
#1 Posted : Tuesday, June 27, 2017 9:08:51 PM(UTC)
Ott

Rank: Member

Groups: Registered
Joined: 6/9/2017(UTC)
Posts: 29
Canada

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
epf  
#2 Posted : Wednesday, June 28, 2017 7:06:37 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 205 time(s) in 198 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.
Ott  
#3 Posted : Wednesday, June 28, 2017 4:50:34 PM(UTC)
Ott

Rank: Member

Groups: Registered
Joined: 6/9/2017(UTC)
Posts: 29
Canada

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
epf  
#4 Posted : Thursday, June 29, 2017 6:27:16 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 205 time(s) in 198 post(s)
Yes, this could be a feature request...but no plan to do it so far.
Users browsing this topic
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.