Get a list of Stories with status A where their sub-tasks with status B

amit_m

Hi,

I'm using Jira cloud and trying to get a list of all my stories with the status="Open" only if they have sub-tasks with different status then "Open"

Using this query, I don't get any results

 

project = XX AND (issuetype in standardIssueTypes() AND Status=Open) AND (issuetype in subtaskIssueTypes() AND status!=Open)

 

Please advise

Thanks,

Amit 

Jack Brickey

I mean to say that you cannot create a JQL query to achieve your goal. You will need an add-on application such as Scriptrunner. There are other solutions in the marketplace as well.