Forum Discussion
Parent-child hierarchy Rows Based on Parent Id
Hello Experts,
Need help to have a visual that will represent the below data in expandable/collapsable or Parent-child hierarchy rows.
I have data in the following format where the Parent Column for each row will store the Parent Row ID.
If the value in the Parent column is present in Dataset's ID column then the row should be expandable under the Parent Id Row - second level row and will be visible only after expand icon is clicked.
If the Parent is Blank then the row has no parent - first level row.
If the Parent value is not found in the dataset then the row has no parent - first level row.
| ID | Type | Status | Title | SP | Estimated Hrs | Completed Hr | Remaining Hr | Parent |
| 1001 | User Story | Active | Title-1 | 2 | 1000 | |||
| 1002 | Bug | New | Title-2 | 1 | 5 | 0 | 5 | 1000 |
| 1003 | Bug | New | Title-3 | 2 | 12 | 0 | 12 | 905 |
| 1004 | Task | Active | Title-4 | 5 | 3 | 2 | 1001 | |
| 1005 | Task | Active | Title-5 | 6 | 4 | 2 | 1001 | |
| 1006 | Task | New | Title-6 | 3 | 0 | 3 | 1001 | |
| 1007 | Task | Closed | Title-7 | 1 | 1 | 0 | ||
| 1008 | User Story | New | Title-8 | 3 | ||||
| 1009 | User Story | New | Title-9 | 5 | 906 | |||
| 1010 | Task | New | Title-10 | 1 | 0 | 1 | 1009 | |
| 1011 | User Story | New | Title-11 | 2 | 906 | |||
| 1012 | User Story | Resolved | Title-12 | 2 | 906 | |||
| 1013 | Task | Closed | Title-13 | 1 | 1 | 0 | 1012 | |
| 1014 | Task | Closed | Title-14 | 2 | 1 | 0 | 1012 |
Posting a table image from the internet to show the expandable and collapsable under Task Name for reference with other columns showing related data:
Thanks,
Prabhat