Monday, July 13, 2015

The Under Operator in MS CRM 2015

Advanced Find now includes two new operators which work in conjunction with the new hierarchies feature in Dynamics CRM 2015. These operators are called “Under” and “Not Under” and can be used when querying lookup fields in Advanced Find.

Microsoft Dynamics CRM 2015 Advanced Find - The Under Operator
I have currently set up the Users in our Dynamics CRM system such that the Managerfor each user has been specified. This builds a user hierarchy in the system so we can easily see who reports to who. Let’s assume we have an organisational structure where there are multiple managers at different levels.Microsoft Dynamics CRM 2015 Advanced Find - The Under Operator
It would be a tricky in previous versions of Dynamics CRM if I wanted to build a query to show everyone who sat below Bob Jones. In CRM 2015, I can simply use the “Under” operator to find these people.
Microsoft Dynamics CRM 2015 Advanced Find - The Under Operator

Running this query gives me everyone who sits below Bob Jones, whether they are a direct relationship with that record or not.
 Microsoft Dynamics CRM 2015 Advanced Find - The Under Operator

No comments:

Post a Comment

Get files of last hour in Azure Data Factory

  Case I have a Data Factory pipeline that should run each hour and collect all new files added to the data lake since the last run. What is...