Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Is left join supported on advanced filter

(0) ShareShare
ReportReport
Posted on by 40

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!

pastedimage1683808351663v1.png

  • Verified answer
    Anton Venter Profile Picture
    Anton Venter 19,493 Super User 2025 Season 1 on at
    RE: Is left join supported on advanced filter

    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.

  • Verified answer
    GirishS Profile Picture
    GirishS 27,821 Super User 2024 Season 1 on at
    RE: Is left join supported on advanced filter

    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.

  • Suggested answer
    Helen2021 Profile Picture
    Helen2021 40 on at
    RE: Is left join supported on advanced filter

    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!

  • Verified answer
    Anton Venter Profile Picture
    Anton Venter 19,493 Super User 2025 Season 1 on at
    RE: Is left join supported on advanced filter

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,817 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans