Parent-Child Hierarchy

[Warghi]

Hello,

I hope you can help me with this topic.

I have a table with Epic, and each Epic has its Epic-ID and its Parent-ID (the ID of its parent) as you can see in the table:

I wanted to build a Parent-Child Hierarchy between the column (Epic-ID) and (Parent-ID), to be able to see the children from an epic, not only the parent.

I used this script to do the hierarchy thing:

can you please tell if this script does the needed task?

and if yes, how can see the children when clicking on the Epic-ID, should I use a second table for that?

Thank you very much.

Best Regards,

Warghi

[pravinboniface]

@Warghi Hierachy is useful if you have a depth greater than 1.  If you only have one level, meaning, all the children (Epic-ID) are only one level below the parent (Parent-ID), you may be better off building a table for the children with the parent key (Parent-ID).