Filter on Sub-Tasks Related to a Task

Is there a way to use JQL to filter on Tasks and related sub-tasks?  I want to be able to include sub-tasks that are related to specific tasks.  Based on the queries I have looked at I am either including sub-tasks but not the main task OR the main task is included but I am missing sub-tasks in the filter.  This is mainly to feed into BigPicture resource planning tool, but I can't seem to get the query right.

1 answer

1 vote
Jack Brickey Community Champion Dec 19, 2017

There are ways of doing this but determining the best method for you requires more info. Such as, is this an occasional thing you want to do or frequent? How much effort are you willing to put into it? etc.

Let me provide my thoughts and see where it gets us but let me first state that the cleanest way is to use something like Scriptrunner's "issuefunction".

1) you could simply use a JQL like this - project = ABC and issuetype in (task, sub-task). Adding further qualifiers, e.g. status.

2) you could add a label to the tasks and sub-tasks resulting in a JQL like this - labels = stuff.

3) more obscure solution, but may work depending on your needs, is to create a kanban board with a single column and use the filter in #1. this will give you a view w/ sub-tasks grouped under the parent task.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Sarah Schuster
Posted Mar 28, 2018 in Jira Software

Can a company’s culture make or break agile adoption?

Can a new-to-agile team survive and thrive in a non-agile culture? If so, what advice would you give to those trying to be agile in a non-agile culture? What's the key(s) to success? Share your thoug...

12,061 views 15 13
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you