How to get list of parent issue when all linked issues and all subtask are closed

Question

We have a parent issue that contain subtasks and linked issues.

We need a jql that display the parent issue when all linked issues and subtasks are closed.

we found the following query to get parent issue with all subtasks closed:

project = "xxx" AND issuefunction in parentsOf("issuefunction in subtasksOf(\"issuefunction not in parentsOf('type in subTaskIssueTypes() and status != closed') and status not in(closed, canceled) and type in standardIssueTypes() \") and status = closed ")

And the second display parent issue with all linked issues closed

issuefunction not in linkedIssuesOf("resolution is empty") AND project = "***" AND issuetype != Tasks and status not in (closed,canceled)

we need to combine them.

Thanks in advance.

Houha Amdouni · Answer

Hi Alexandre ,

Thanks for your response.

i ve resolved the problem , its was related to the syntax , it have to be A and (B)

Alexander Pappert · Answer

can you combine the 2 with A or B?

or like mentioned here with scriptrunner

https://community.atlassian.com/t5/Jira-Core-questions/Add-dynamic-filter-to-other-filter-results/qaq-p/264257

If you count with Script Runner, then you'll be able to get the sencond filter like this:

issueFunction in epicsOf("filter='My issue keys'")

Provided you have a saved filter with that name (My issue keys), which would look like this:

key in (EPIC-1, EPIC-57, EPIC-23)