Assistance needed with an RTC Query
I need help writing a query. My tickets are structured as follows:
Epic #123
Story #456 (Parent is 123)
Children:
Task 387 (Parent is 456)
Task 978 (Parent is 456)
Story #789 (Parent is 123)
Children:
Task 657 (Parent is 789)
Task 105 (Parent is 789)
My goal is to write a query that will return all of the stories the Epic. For example
Epic Story & Tasks
123 456
123 387
123 978
123 789
123 657
123 105