Experts.
Jira is setup as below:
Subtask ->Tasks -> Stories ->Epic ->Epic/Theme.
Epic/Theme lets say has 4 Epics and 3 Deliverable. And, each Epics has 3 stores and 5 subtasks.
Need Help:
To get everything everything everything under the hood of "Epic/Theme" in one shot( One query ).. Kind of crawling underneath till the last level across all Epics and all Deliverable..
Version: Jira 8.5 and no scriptrunner support.