Above and Under operator to query hierarchical data in Dynamics 365 – Nishant Rana’s Weblog

above and under were the 2 new operators introduced with Dynamic CRM 2015.

Let us see some of the examples.

Suppose I have the following hierarchy defined, wherein User 2 is manager of user Nishant Rana who in turn is manager of User 1.

And following are the contacts record owned by them.

In context of user Nishant Rana, if I apply Under operator, we’d get the following result

Only the records owned by child

And for Not Under

All the records owned by the user and its manager(s) or…

Continue Reading Nishant Rana’s Article on their blog

Above and Under operator to query hierarchical data in Dynamics 365 – Nishant Rana’s Weblog

Blog Syndicated with Nishant Rana’s Permission

More About This Author

Nishant Rana
Nishant Rana
• Microsoft Certified Professional in Microsoft Dynamics CRM (CRM 3.0 to CRM 2016), Microsoft SharePoint (2007 and 2013) and Microsoft .NET with 10+ years of experience.
• 10 years of working experience with Microsoft Dynamics CRM starting with CRM 3.0 to CRM 2016 on various project aspects: analysis, designing, developing, leading team etc.
• An avid blogger who likes to learn, help, share and contribute in Community.
• Author of “Nishant Rana’s Weblog” (https://nishantrana.wordpress.com/), technical blog on Microsoft .NET technologies with more than 2.5 million hits and 800 followers. The blog is also recognized as one of the top 35 blogs on Microsoft Dynamics CRM.
• Twitter account https://twitter.com/nishantranaCRM with more than 500 followers, which includes MVP(s) and experts in Microsoft Dynamics CRM.
• Technical Reviewer of following books on Microsoft Dynamics CRM.
https://nishantrana.wordpress.com/books-reviewed/

Author: Nishant Rana

• Microsoft Certified Professional in Microsoft Dynamics CRM (CRM 3.0 to CRM 2016), Microsoft SharePoint (2007 and 2013) and Microsoft .NET with 10+ years of experience. • 10 years of working experience with Microsoft Dynamics CRM starting with CRM 3.0 to CRM 2016 on various project aspects: analysis, designing, developing, leading team etc. • An avid blogger who likes to learn, help, share and contribute in Community. • Author of “Nishant Rana’s Weblog” (https://nishantrana.wordpress.com/), technical blog on Microsoft .NET technologies with more than 2.5 million hits and 800 followers. The blog is also recognized as one of the top 35 blogs on Microsoft Dynamics CRM. • Twitter account https://twitter.com/nishantranaCRM with more than 500 followers, which includes MVP(s) and experts in Microsoft Dynamics CRM. • Technical Reviewer of following books on Microsoft Dynamics CRM. https://nishantrana.wordpress.com/books-reviewed/

Share This Post On