JQL for backlogged tasks whose parents are in progress

[McKenna Hogan]

Hello, I want to create a custom filter for finding backlogged tasks whose parent epics are in the current sprint or in schedules sprints. I know I have tasks that match this criteria but the JQL's I'm trying aren't working. I have tried:

statusCategory != done and (Sprint not IN openSprints() or sprint not in futureSprints()) and (parentEpic in opensprints() or parentepic in futuresprints())

Any recommendations?

[Bill Sheboy · Accepted solution]

Hi @McKenna Hogan 

What you describe is not possible with out-of-the-box JQL features.  That is, querying an issue's parent's fields which meet certain criteria to find the child issues.  You will need a marketplace addon for JQL to do this with a query.

The parentEpic() function returns the child issues associated to an Epic in a company managed project, and it does not search the fields of the Epic itself.

https://support.atlassian.com/jira-software-cloud/docs/jql-functions/#parentEpic--

Kind regards,
Bill