comparing two issues types against each issue status

Question

I would like to build a filter that does 2 things

1 Find all features that are in ( On Deck, Backlog, Open)

2 Find all issues  that have the feature as a parent that are In Progress

I have tried filter project = xx and Issuetype = feature and status in (On Deck, Backlog, Open) and issuetype = In Progress

nothing is returned but I think my logic is bad. somehow the feature needs to be the parent.

Help

Alexey Matveev · Answer

You are welcome!

Thomas Cucolo · Answer

Thank you the Add in is only accessible to Core admins  in the company, thank you.

Alexey Matveev · Answer

Hello,

You would need an add-on for it. For example, you could use the Power Scripts add-on:

https://marketplace.atlassian.com/apps/43318/power-scripts-jira-script-automation?hosting=cloud&tab=overview

You could write a JQL query like this:

1. project = xx and issuetype = feature and status in ( On Deck, Backlog, Open)

2. key in subtasksOf("project = xx and issuetype = feature and status = \"In Progress\"")