web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / guyterry's Microsoft Dynamics AX blog / Not Exist Joins in F&O ...

Not Exist Joins in F&O 10.0.9 Advanced query?!

Views (612)
Guy Terry Profile Picture Guy Terry 28,844 Moderator

Big thank you to someone on a Yammer group for spotting that the Advanced filter or sort function in 10.0.9 supports Not Exist Joins:

There’s nothing in the F&O release plan that specifically mentions that this functionality was being added, but it could well have come from a Community Driven Engineering pull request submitted last year.

But does it work? I did a quick test: Customers with no records in CustTrans.

And the result looks very encouraging:


This was originally posted here.

Comments

*This post is locked for comments