How can I query for all subtasks of a set of issues returned from a particular set of issues?

[Rob Horan]

I need to create a query that finds a set of issues based on certain criteria and returns those issues AND all subtasks.

Assume this is the primary JQL:

status in (Open, Working, "ON HOLD") AND resolution = Unresolved AND "User Field" = "my-user"

That will get me all of the parent tickets I'm interested in.  I need to get all the subs of those AND the parents.

DC, not Cloud.

I believe this instance has ScriptRunner, but I am FAR from a power user of SR.

[Trudy Claspill]

Hello @Rob Horan 

If you have ScriptRunner then you can use

(<your query for the parent issues>) or issuefunction in subtasksOf(subquery)

...where subquery is also the query you use to get the parent issues.

Refer to https://docs.adaptavist.com/sr4js/latest/features/jql-functions/included-jql-functions/sub-tasks