Home
> Dynamics 365, Uncategorized > Query using ‘Not In’ filter – Advanced Find – Dynamics 365 – V 9.0
Query using ‘Not In’ filter – Advanced Find – Dynamics 365 – V 9.0
In the previous versions of CRM, there is no option in Advanced Find, to query all ‘Case’ records that do not have a related task, as we don’t have option to execute ‘Outer Join’ (i.e., Not in).
In V9.0 release, a new ‘Does not contain data‘ option added to ‘Advanced Find’ to filter ‘Not In’ records.
Let’s get started to fetch all the ‘Accounts’ which does not have any associated ‘Contacts’
- Open ‘Advanced Find’
- Select ‘Account’ entity and from the Related entities choose OOB ‘Contacts(Company Name)’ relationship.
- Choose ‘Does Not Contain Data’ from filter option.
- Fetch XML will be as below
🙂
Categories: Dynamics 365, Uncategorized
Advanced Find, Dynamics 365, Not In, Outer Join
Comments (0)
Trackbacks (1)
Leave a comment
Trackback
-
October 7, 2017 at 5:21 PMWhat’s new for Developers/Admins/End Users – Dynamics 365 – v 9.0 | Rajeev Pentyala - Dynamics CRM Blog
Rajeev Pentyala - Microsoft Power Platform 