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 · Accepted solution]

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.

[amit_m]

Thanks for the details 

[Jack Brickey]

You can't achieve this OOTB. Consider an addon like Scriptrunner or similar advanced JQL querying app.

[amit_m]

Can you please explain?