Rajeev Pentyala – Technical Blog on Power Platform, Azure and AI

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

🙂