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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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 Query to filter out backlog in a project not using sprint functionality

I want to return issues from the Board. What is the JQL Query to filter out Backlog in a project not using Sprint functionality?  Since there no sprints for any issues, "sprint is not EMPTY" does not return any results

Thanks!

 

 

1 answer

0 votes

Hi @Olga Tchuvatkina ,

In fact, the board is based on a query. As I understand, you want this query, so go to the Configuration>General and Saved Filter or Filter Query.

 

Hope it helps !

HI Thomas, thank you for getting back to me

I want to create a filter that returns unassigned tasks from all projects. The query below picks up tasks from Board and Backlog, Is it possible to filter Backlog out?

 issuetype = Task AND assignee in (EMPTY) ORDER BY updated DESC

It looks like I can do it by enabling sprints in my next-gen projects and filtering tasks with empty sprints, but is there another way that does not involve enabling new feature? Hopefully there is some JQL flag that distinguishes board from backlog

I looked through automatically saved queries but did not see any queries for next-gen projects boards. Board queries generated for classic projects were filtering only by project name so they are not really helpful for filtering out backlog. Am I looking in the wrong place?

Thanks!

Olga

Hi Olga,

 

You may use the sprint field like :

 

sprint not in openSprints () 

It should give you all issues that are not present in your active sprints, so present in the Backlog, don't you think?

 

Hope it helps !

Hi @Thomas Magny-Garcia 

Sprints are not enabled in these projects so neither Sprint is not EMPTY nor sprint not in openSprints () will work, unfortunately.  Yet there is something other than sprints that distinguishes board from backlog, since Backlog can be enabled without enabling Sprints

Thanks!

JiraNextGen.png

Suggest an answer

Log in or Sign up to answer
TAGS

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