Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JQL filter to show all issues including subtasks for current sprint.

I'm trying to show ALL project issues, including subtasks in a particular sprint.

project = "Project name" 

Works and shows all the Epics, Stories, Tasks and Subtasks.

However if i just want to show what is allocated to just a particular sprint.

 project = "Project name" AND sprint = "sprint"

 I only get to see the Stories and Tasks.... no subtasks ?

sprint = "sprint"

does the same.
How do i get to show all the stories/tasks and subtasks  in a particular sprint?

4 answers

1 accepted

1 vote
Answer accepted
Ollie Guan Community Leader Jun 05, 2020

Hi @Julian Bowker ,

This is a long term backlog from 2019.

So it is 😢

Thanks for the prompt reply @Ollie Guan - I've added my vote to that item.
Maybe i should try an interim to list all the sub-tasks with parents in the current sprint, even though some of those sub-tasks may not be in the current sprint.

I guess i will have to be patient and hope long term backlog gets nearer some day.

Like # people like this

@Ollie Guan  - wow, a full year with no movement. I don't understand how Atlassian's Next Gen projects functionality was ever released as working software

Like Sergei Wallace likes this

Can you guys please build this? So many super basic features not available in next-gen... regret creating my Jira project as one at this point.

Like Julian Bowker likes this

Yeah, this sort of stinks.  Filters for Epics don't grab the sub-tasks.  Again, basic functionality I don't want to have to use a plugin for to do something that should be the default.

Like Assistenza likes this

Hey everyone,

If you have a strong requirement to get the subtasks that are in the sprint you may consider our indexing service:

Your query will look like this:

sprint = "sprint" OR issue in subtasksOfParentsInQuery("sprint = 'sprint'")

You can read more in the docs.

I hope it's helpful to people who are open to apps.

0 votes

This is basic functionality which you shouldn't need to pay extra for. Must say that I'm disappointed with the JQL functionality that one gets with basic subscription. Reminds me of crippleware. 

I think it could be solved with the ScriptRunner plugin.

But it costs $)

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira

Admins, notify your Jira instance of system-wide changes with the new admin announcement banner

Hi All! We’re excited to share the launch of an announcement banner that lets Jira site administrators communicate directly to their users across their  Jira Cloud instance.  ...

632 views 16 18
Read article

Community Events

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

Events near you