Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys;
In my organisation I need to make a table with two Columns : Heads (some leads); Subs (employees working under their multilevel hierarchy).
I have 1 table with Heads identifiers, and one table with an identifiers mapping N:N+1 that allows to know for each employee his N+1.
Which formula can I put in the second column (Subs) to have all the employees under a lead what ever level they have ?
Thank you.
With parent/child data, you can use the HierarchyBelongsTo.
The AncestorID will be linked to all the children that belong to them and their descendants.
With parent/child data, you can use the HierarchyBelongsTo.
The AncestorID will be linked to all the children that belong to them and their descendants.
Can you show some sample and expected output?
Thank you Jwjackso !
This is the right function.