How to get the child issues list by using a JQL filter?

[Edgardo Martinez Narvaez]

I need to have all the child issues of multiple TLE within a project. For example, I created/saved a filter with these details:

project = xxx AND type = "Team Level Epic" AND fixVersion IN (EMPTY, "xxx") AND (resolution NOT IN ("Won't Do", Cancelled, Duplicate) OR resolution = Unresolved) AND "SAFe Work Type[Select List (cascading)]" IN (EMPTY, Business)

I have the concerned TLEs with the above filter, but I need to get the child issues with an open status for validation purposes. For example, if a child issue is opened but the TLE is closed, this is not correct, so my team should fix it.

I was not able to get the child issue status, nor the list of child issues per the TLEs list of the above filter.

[Mendel Liang · Accepted solution]

Hi Edgardo,

As noted by Piyush, if you want all descendants of a particular issue (e.g for an Epic, all the stories under it and all the subtasks under the stories), you can use 

key in portfolioChildIssuesOf("WORK-123") AND project = xxx ...(other JQL)

where WORK-123 is the key of the relevant Epic.

If you want just the direct children, you can use

parent = WORK-123 AND project = xxx ...(other JQL)

which will only include the work with WORK-123 as the value in the Parent field.

[Piyush Annadate _ACE Pune_ · Accepted solution]

Hello @Edgardo Martinez Narvaez 
Welcome to the Community !
And related to child issue by JQL filter - Welcome to the party !

JIRA Native functionality doesn't have this feature wherein you can fetch child issues of result based on JQL. With a single issue you can via portfolioChildIssuesOf()

Additional plugin can help you with that, [paid] such as Script Runner enhanced search, JQL Search extension., 
Checkout free version as well https://marketplace.atlassian.com/search?query=jql&product=jira&price=paid

[Rekha Dayananda Babu]

Hi, We are using JIRA DC 9.12.28 and need a standard JQL query to display this data in dashboard which is crucial for customer to see the entire hierarchy under specific initiatives. Issue in ChildIssuesof() query is not giving any results. ScriptRunner Version: 8.56.0. Please suggest.