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).
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.
After building this query, we will make the results show 3 Columns (attributes): Organisation Name, Address1: City and Status Reason (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.