Query hierarchical data

Retiring hierarchical data is easy, we don’t need to iterate by for/while loop. just use ‘Above’ or ‘Under’ keywords, then it will serve you all parents or all child available.

in regular query, just ‘ConditionOperator.Above’ to get all parents.

in regular query, just ‘ConditionOperator.Under’ to get all child.

How to create this type of structure

Continue reading “Query hierarchical data”

Configure and visualise hierarchical data

In MS Dynamics CRM, Self join has special powers, with self join we can create hierarchical data structure, as shown below,

hirarchy Continue reading “Configure and visualise hierarchical data”