How do I show all Subtasks under an Epic that is marked as "In Progress"?

[Ani.Moller]

I have a kanban board that has a lot of epics for a program of work, and each epic has a lot of subtasks.

I'm trying to set up a second view that will show me ALL subtasks for the epics that are marked IN PROGRESS, so I can use the board in standups to just see the tasks that in progress rather that everything.

One of the scrummasters suggested I use this JQL, but it's only showing me the in progress SUBTASKS, not all subtasks for the in progress EPICS.

project = OCM AND issuetype in standardIssueTypes() AND status = "In Progress"

I'd love some advice! I'm stuck :) Thank you very much.

[Malin Fremnell]

Hi again @Ani.Moller 

Maby you could try this JQL instead. It will filter out Standardissues, status "In Progress" and also linked to an epic:
project = OCM AND issuetype in standardIssueTypes() AND status = "In Progress" and "Parent Link" is not EMPTY

Hope this can help you to get the result you want.

Best Regards
Malin 

[Ani.Moller]

Sadly this just shows me all the in progress subtasks, not the to do subtasks under the in progress epics. Pretty much the same as I had before.

[Malin Fremnell]

Hi @Ani.Moller 

Ok I give one last try :).

I dont know if you have that already, but you are going to need the plugin/App JQL Search Extansion in order to do this kind of advanced JQL. You find it to install at Atlassian marketplace JQL Search Extensions for Jira - the JQL extensions | Atlassian Marketplace

If you install it than you can try this JQL:

Project = OCM AND issue in childrenOfEpicsInQuery("type=Epic AND status='In Progress'") AND resolution is EMPTY

the JQL search needs to be proceeded in the meny under Apps - JQL search Extensions.

II hope this can be the solution for you 

Kind regards 
Malin 

[Ani.Moller]

Hrmm, I had the query set up and working (well someone had set it up for me before on the same instance) and we didn't have paid plugin installed. 

[Malin Fremnell]

Hi Ani.

Maby if you replace standardIssueTypes() to subtaskissuetypes() you will find what you are looking for?

The JQL would in that case be:
project = OCM AND issuetype IN subtaskissuetypes() and status = "In Progress"

Kind regards 

Malin 

[Malin Fremnell]

now realize that my JQL will not bring out what you want. further required needs to filter out only the subtask that belongs to parent epic. 

[Ani.Moller]

Yeah, this one doesn't work either :( I get no results on this one