Introduction to Advanced Find – Part 2

In the first part of our blog we discussed and demonstrated the power of the Microsoft Dynamics 365 Advanced Find and how it can be used for basic filtering.

In part two of this blog we will be using the Advanced Find to search for information on related entity records (i.e. an organisation and an associated opportunity record) and exploring the “Under” and “Not Under” operators.

In our first example, we will build an Advanced Find query that searches our database for all Active Organisations located in Oxford with an Opportunity created within the last 6 months (Figure I and Figure ii).

Figure i


Now that we have built the filter criteria using fields on the organisation entity, we want to add additional criteria so that the query finds organisations with at least one opportunity created within the last 6 months. To do this, you will need to scroll down to the Related section after clicking Select. Make your query look like the one below.

Figure ii

After building this query, we will make the results show 3 Columns (attributes): Organisation Name, Address1: City and Status Reason (Figure iii).​

Figure iii

In our second example, we will build an advanced find query that uses the “under” and “not under” operators.

  • Under – finds all records below a specific hierarchy level (e.g. branches under a specific organisation record)
  • Not Under – opposite to the above

In this example, we will use the “under” operator to find all branches (subsidiaries) who are placed under the Core Technology Group hierarchy – as shown using the CRM hierarchy chart below:

When we look at the setup of the hierarchy structure using the organisation chart, we can see it spans 3 hierarchical levels and only involves a small number of records – easy enough to interpret on a single screen but imagine if hundreds of records were included in your hierarchy across various organisations.

To easily review this information, we can build an advanced find to list all the organisations who are placed below Core Technology Group.

On clicking Results the following records are shown:

CRM has confirmed 5 organisations (branches) sit under Core Technology Group.

Selecting “Not Under” gives an inverted result so in this example it this would find all organisation records excluding the 5 sub-ordinate organisations above.

Matthew Duhig
Matthew Ballard

Principal Microsoft Dynamics CRM consultant and delivery team lead experienced in all aspects of CRM consultancy including implementation, business analysis, customisation as well as delivery of support. Has over 13 years’ experience in CRM based software solutions ranging from off the shelf CRM packages to larger more scalable CRM software systems.

Related Insights

Stephen Hynes

Restricting Access to Office 365

Blog : Azure, Office365

Problem Office 365 offers some fantastic benefits over traditional on-premise infrastructure.  No costly infrastructure required, no advanced IT knowledge required, 100 GB mailbox, online meetings, document collaboration, 99.9 % uptime, flexibility allowing businesses to provide users...

Laura Lopez

MemberWise Recognised Supplier Programme

News : Core

Core are delighted to announce that they continue to be part of the MemberWise Recognised Supplier Programme. This programme is a division of The MemberWise Network which is an independent professional network that helps and supports to around...