I am trying to create a filter that will show me items that are in the backlog, but am having difficulty. I hope that someone can help point me in the right direction, and that it is not an issue of JIRA lacking another feature that I need!
My current filter looks like this:
status != Done AND (Sprint not in (openSprints(), futureSprints()) OR Sprint is not EMPTY) ORDER BY createdDate ASC
If I change it to say only
Sprint not in (openSprints(), futureSprints()
then I get results that are not in the current sprint - exactly what I need. The only problem is that it excludes items that have previously been assigned to a sprint, but were never completed. If I change it to say only
Sprint is not EMPTY
then I get results that have been previously assigned to a sprint - again, exactly what I need! The only problem is that it excludes items that have never been assigned to a sprint.
When I try to combine the two inside of a parenthesis grouping, I get most of what I need - but for some reason, it is including the items that are in my current (active) sprint.
I feel like this would all be solved by having Atlassian implement a simple "currentSprint()" operator, so that I could say
Sprint not in currentSprint()
Can anyone help me out - or am I out of luck?
Hi Boris, thanks for responding! This definitely gets me much closer to where I need to be. There are a few items that I'd still like to get rid of though; I see issues carried over from our last sprint (closed) that have been assigned to the current sprint. I really appreciate you taking the time to reply!
Yes. Essentially, I want to...
It seems like the query above is filtering out items that have never been assigned to a previous sprint (i.e. sprint is EMPTY), but I actually need them to be included!
Thanks again for taking the time to respond!
Here's a query similar to the one above with some explanation:
sprint IS EMPTY OR sprint IN closedSprints() AND sprint NOT IN (openSprints(), futureSprints()) AND status != Done
sprint IS EMPTY OR sprint IN closedSprints()
sprint NOT IN (openSprints(), futureSprints()) AND status != Done
I'm in the same boat. It's absurd that I can't see what's in my backlog at a glance. Right now I'm using this:
project = NAME and sprint IS EMPTY and status = open OR project = NAME and sprint IN closedSprints() AND sprint NOT IN (openSprints(), futureSprints()) AND status = Open
Hello Atlassian Community! My name is Emilee, and I’m a Product Marketing Manager for the Marketplace team. Starting with this post, I'm kicking off a monthly series of Spotlights to highlight Ma...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot