nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to include sub-tasks in a filter

Morgan Canfield

I have this filter to give me what was completed this week across a couple projects. I only get the Tasks, but no Sub-tasks. Anyone know how to get the done tasks and done sub-tasks? I would want the done sub-tasks even when the parent tasl may still be open.

project in (project1, project2) AND status = Done AND resolved >= -1w AND assignee in (user1, user2, user3) ORDER BY "Epic Link"

Thanks,

Morgan

Accepted answers

All comments

Jobin Kuruvilla [Adaptavist]

Are there any subtasks macthing this query? If you expect the subtasks that belong to all the tasks matching this query, that is not how it works.

Subtasks are just another issuetype and they will be returned in the result only if they match the conditions in the query. If you need subtasks from tasks matching to certain criteria, you will need a pliugin like JQL Tricks.

Morgan Canfield

Thanks! I will look into that. We're using the Cloud version...

AnnWorley

This plugin is compatible with Cloud and promises to "find issues by Link, work log, subtasks, comments, etc"

JQL Plus (Mongo Search)

RituM

I don't think we should have to buy a plugin for such a basic functionality

Cathleen Griffeth

you can include subtasks in filters without a plugin... here is an example that works - we used components to segregate boards on PROJECTNAME:

project = PROJECTNAME AND component = COMPONENTFORFILTER OR issueFunction in subtasksOf("component = COMPONENTFORFILTER ") ORDER BY Rank ASC

Tim_7i2tz0

IssueFunction isn't OTB JQL

Cathleen Griffeth

the question doesn't mention OTB as a requirement - just that a solution is required. I believe I answered the question with yet another option.

Tim_7i2tz0

Apologies Cathleen, I mistakenly thought you were reply to another post.

SrikanthNarayan

Hi all,
I have the same issue in Jira Next Gen, I cant filter based on Subtasks. Any help, please?

Michael Ballenger_ib2gzm

Same here- seems to be a glitch of some sort. If I create a simple filter 'project = GSTA ORDER BY Rank ASC', I get subtasks. As soon as I add to the filter 'project = GSTA AND labels != Post_MVP ORDER BY Rank ASC' my subtasks disappear.

Frank Janisch

Reason is, that the subtasks have no labels and are therefore excluded from the result when you filter by label...

Daniel Turczanski - JQL Search Extensions

Hi community!

This is an old question but I'm sure this answer is helpful today.

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. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

After you install the app, you can simply search:

issue in subtasksOfParentsInQuery("project in (project1, project2) AND status = Done AND resolved >= -1w AND assignee in (user1, user2, user3)")

Check out the documentation for more examples.

I hope this helps!
Daniel

Tomer Madmon

I have found more practical solution:

Goto parent task in Jira
Click on 3dots above the subtasks list
Click on view in search

You will get JQL like:

issueKey in (ABC-111,ABC-222,ABC-333,...)

Thanks

@Tomer Madmon

Rod_cw62fo

sub tasks is a major defect in Jira I think. always makes for confusion and problems. would be better if stories could hold tasks

epic -> stories -> tasks

simples.

Guru Darbar

Hi everyone,

I was able to filter subtasks from an issue using:

`project=MYPROJECTKEY AND parent=KEY`

Atilla Bedel

hi all,

I am using jql query that ı sharing below for showing subtask, may be it can useful for you.

project = PROJECTNAME/CODE AND issuetype in (standardIssueTypes(),subTaskIssueTypes()) ORDER BY Rank ASC(or you can order issues with different parameter)

Also you can user this query for multiple project with "in" operation for project parameter.

I hope it will work for you.

Itai Shturm_g5ztgc

Updating here - there is now a simple way directly without any plugins.
Just add a filter on issuetype = Sub-task

For example:
issuetype in (Epic, Bug, Sub-task)

Kevin Dickson_o2tc47

Rod, try using checklists in place of subtasks to achieve this.

I'm in no way affiliated with this company, but have found this extremely useful for my projects.

https://ecentric-jira.atlassian.net/jira/marketplace/discover/app/checklists-jira

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

atl-gruland