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.
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.
STATUS DETAILS
Needs Votes
Comments
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