Hello, I need some help on the table join.
When we run a report, there's "record to include" section where I could join other tables for advanced filter.
Is the left join supported when adding table join? for example, I wanted to filter out any transactions has marked as disputed or other status from my dunning letter. but when I add the table join, only transactions with a disputed status will be shown, so I guess, by default, it's inner join, I wonder if there's a way to have left join, so all the transactions can be returned as a result, thanks!
Hi Helen,
As Girisih said, the one report only. It is not a huge task so not a lot of effort for someone with enough experience.
Hi Helen,
It you done development to single report it will be applicable to single report only.
If you want for all the reports - You need to do development on all the reports.
Thanks,
Girish S.
Thank you Anton for your prompt reply, may I have 2 more questions with your answer,
1. If we make a code customisation, can this be applied to all the reports or it has to be done to the specific report?
2. How much effort this development could be? I suppose it's small, but I'm not a developer. thanks!
The default join type in the user interface advanced filter is inner indeed. With a code customisation it is possible to change it to an outer join.
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,817
Most Valuable Professional
nmaenpaa
101,156