I'd like to create a JQL filter to show all the issues and subtasks in an epic. There was already a discussion on it that's been marked as solved (https://community.atlassian.com/t5/Jira-Software-questions/JQL-to-show-all-issues-AND-subtasks-in-the-Epic/qaq-p/346433), but none of the answers provided solve the problem - they can show the issues in an epic, but none of them show subtasks as well (note that I only tried the JQL and didn't try any of the third part tools recommended).
Basically, I have an annual epic with weekly issues and daily subtasks. Each week gets cloned, with the details of the daily tasks being updated, but the cloning works because the structure of each week is the same.
I'd like to create a filter that shows all the subtasks. Note that because we're not creating all of these tasks up front, I can't create a filter with 52 tasks and then be done for the year, so it needs to be something that can update as new tasks are added. I was hoping to do something based on the epic, but since the subtasks are only linked to the epic through the issues (so, no direct link), this doesn't seem to be possible.
Has anyone found a way to make this work?
Hi ya, this is Nolddor from SweetBananas vendor.
Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. Using i.e. JQL Booster Pack (if you are on Server / DataCenter) you can type the following:
1) Find all task under a given Epic (i.e. EMEA-2459)
"Epic Link" = EMEA-2459
2) Find all subtasks under returned issues above
issue IN subtasksOf(' "Epic Link" = EMEA-2459 ')
3) All together (Epic, Task & Subtask)
key = EMEA-2459 OR "Epic Link" = EMEA-2459 OR issue IN subtasksOf(' "Epic Link" = EMEA-2459 ')
(*) Note that this is just an example, you must tune above query to fit your needs.
Using this app you can also query other issues relations, check:
This also does not work for me, and I can't tell if I'm missing something because this also seems very intuitive and like it should be simple to me.
-Like OP, I want to see all the issues and subtasks in an epic.
-I don't know how to answer the question of what platform I am on (using enterprise software from my company).
For example, let's say I am in my project of "Running a Household", and working on an Epic of "Cooking Dinner", and this Epic of cooking dinner might be grouped in with other Epics under the initiative "Eating Healthy". I am in the backlog of Running a Household, and I want to take a look and review how things are going for our "Cooking Dinner" Epic - what user stories have been made, what problems and issues and subtasks need to be worked on all in one view. Intuitively I want to just search for my Epic or initiative in the backlog or use advanced search.
Right now, I can see *all* the issues for a project. But, I can't seem to just search for the epic name or number (TD-236) and have the same view but filtered for anything in that Epic. I also would like to use this same strategy for initiatives to view all epics with their issues in an initiative, and using the search/advanced search option.
If you have the epic panel turned on, then in the backlog view you can select your Epic to filter (which is basically what I am going for here!). However, if you have a lot of epics going that is still not ideal because you have to do a lot of scanning and scrolling to find your epic. And it does not help you in the advanced search field, or if you don't have epic panel, or if you want to search by initiative.
@Paul Matteucci What do you mean by "platform"? We are using Atlassian cloud Jira. This happens in Chrome, Firefox, Edge, Safari, everywhere. It is limitation of Jira, one of the dozens if not thousands of them. Mind blowing that no one thought to write this...although I seem to remember Green Hopper (or whatever the original Agile tool was called) doing this. Likely got deleted by some over zealous object oriented developer.
@Steve Gonzales ah, sorry, the solution I proposed was on an instance with Jira premium including advanced roadmaps. The portfolio commands are tied to premium as they are advanced roadmap functions.
I just tested this on a trial plan and it worked:
parentEpic = TD-236
From @Paul Matteucci 's solution below
That's pretty confusing! It's working for me on my personal cloud test instance following the same query.
I ran this in my instance and it worked:
project = SCRUM and parentEpic in (SCRUM-1, SCRUM-2)
As you can see, I got results with stories and subtasks!
@Roberto Rolon That actually works! Thank you so much. It's not great because it crams all the results in like half a column, but it does work. It's mind blowing that Atlassian doesn't document this and won't even monitor threads like these. I know some people who refuse to use any Atlassian product and it's stuff like this that drives people mad.
Hi @Jacqui Pretty ,
As you're on Jira Cloud the correct answer is to get an app that provides JQL extensions you're looking for.
With standard JQL you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. Your use case is more dynamic than that.
Standard JQL doesn't easily allow it but the results can be quickly found using our professional indexing service:
After you install the app you can simply search:
issue in childrenOfIssuesInQueryRecursive("project='ACME' and type=Epic") and type=Subtask
The query finds all children of your epics and even children of their children - these are your subtasks. You may want to check out the docs as well.
I hope this helps!
That's right. Standard JQL has support for basic searches like that. If you have a static list of issue keys then you're fine with vanilla JQL. If you need the queries to be more dynamic then it's a good idea to search for JQL extensions.
👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events