Forum Discussion

prabhatnath's avatar
prabhatnath
Icon for Advocate III rankAdvocate III
3 years ago

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.   

IDTypeStatusTitleSPEstimated HrsCompleted HrRemaining HrParent
1001User StoryActiveTitle-12   1000
1002BugNewTitle-215051000
1003BugNewTitle-3212012905
1004TaskActiveTitle-4 5321001
1005TaskActiveTitle-5 6421001
1006TaskNewTitle-6 3031001
1007TaskClosedTitle-7 110 
1008User StoryNewTitle-83    
1009User StoryNewTitle-95   906
1010TaskNewTitle-10 1011009
1011User StoryNewTitle-112   906
1012User StoryResolvedTitle-122   906
1013TaskClosedTitle-13 1101012
1014TaskClosedTitle-14 2101012

 

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

No RepliesBe the first to reply