Can I write a query to return data from parent objects?

[Mike Moores]

I am trying to produce a table of all the tasks that still belong to a particular epic.  Is there a way to write a filter to show all open sub-tasks for a given epic? (grandparent relationship.)

[Brant Schroeder]

If you know the parent you can use parent = JIRA-1234 or if you can use scriptrunner (Cloud or server) - ("Epic Link"=XX-###) OR issueFunction in subtasksOf("\"Epic Link\"=XX-###") or AM utils (server) - issuekey in (issuesSubtasks("'Epic Link' = XXX-99")) ORDER BY Rank ASC.  Both plugins cost money.

[Mike Moores]

@Brant Schroeder, thanks for your speedy reply.  Let me give that a go.

[Mike Moores]

The first suggestion parent = JIRA-1234 worked for stories and sub-tasks, but I can't find a way of deriving the children of an epic...   Will keep hunting.