Advanced Find – “NOT IN” Query is Supported in v9.0

Dynamics 365 9.0 supports “Not In” \ “Does Not Have” type of queries as an OOTB feature in Advanced Find. In previous versions of Dynamics 365 had no this feature but there were some custom solutions to facilitate this problem.

The problem in previous versions : 

This post (“Not In” \ “Does Not Have” Query in Dynamics CRM – By Cobalt) explains the problem and it describes a solution for the problem for previous versions.

The solution in 9.0 :

The scenario is to query all the accounts which have no cases under in each account.  Following query returns the expected results using advanced find without installing any third party components.

“Does Not Contain Data” Clause

AdvancedFindNotInQuery

The above advanced find query doesn’t allow users to select any more attributes from the cases as it looks for accounts which have no cases. It’s very logical to restrict the user to filter values from the cases when “Does Not Contain Data” option is selected.

“Contains Data” Clause

AdvancedFindContainsData

“Contains Data” clause allows user to filter more attributes in the Case record. The above query is to get all the Accounts which have Cases having Case Number like “CAS”.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s