Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Filtering issues in the Backlog page using JQL

In the Backlog page of a project, there are very limited options to filter the different issues.


As a user I like to be able to better filter that list. E.g. to see only certain statuses, or any other filter that I will need.

3 answers

This worked for me: 

project = <your project> AND issuetype in (task, "Task ", Story, Improvement, Improvements, Research, Bug, Incident) AND status not in (Done, CANCELLED, Closed) AND (Sprint in (futureSprints()) OR Sprint is EMPTY) ORDER BY rank

0 votes

Hi @Itay Keller!

Concerning your "order by assignee" question, nothing is that simple as it looks like. Check this question, for example:

I was to see issues ordered by assignee

This field seems to be filtered by userid which is not always a real name.

I haven't tested it in my environment, though.

Hope this helps.

0 votes
Ollie Guan Community Leader Nov 11, 2018

Hi @Itay Keller,

Quick Filters let you further filter the collection of issues appearing on a Scrum or Kanban board. Use Quick Filters to switch between different issue types (e.g. show only bugs), or to show team-specific views of a common backlog.

Hi @Ollie Guan , 

Thanks for your suggestion. It seems very much like what I was looking for.

I got this question:
Even though I added to the JQL and "order by assignee" the list in the backlog is not order in that way. 

Suggest an answer

Log in or Sign up to answer

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