web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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

I have the same question (0)
  • Verified answer
    Anton Venter Profile Picture
    20,629 Super User 2026 Season 1 on at

    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.

  • Suggested answer
    Helen2021 Profile Picture
    40 on at

    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
    GirishS Profile Picture
    27,833 Moderator on at

    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.

  • Verified answer
    Anton Venter Profile Picture
    20,629 Super User 2026 Season 1 on at

    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.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 577 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 309

#3
Diego Mancassola Profile Picture

Diego Mancassola 259

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans