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