38
When using the advanced query form the user can add related tables via the JOINS section.
However filters using the 'NotExists join' method is not possible.
EG: create a filter on all sales orders which don't have any lines.
It would be great to have a second tab 'NotExistsJoin' to be able to use such kinds of query logic.
Category: General
STATUS DETAILS
Needs Votes

Comments

N

Excellent, very practical idea. If you look at standard D365 tiles like 'items without routing" you see that the query behind the tile is a lengthy SQL statement. As functional people we cannot replicate that. We need a simple choice.

Category: General