We have the following default filter query for a Kanban board.
( (project = "Red Projects" OR component = TeamRed) AND resolution = Unresolved ) OR ( (component = TeamRed OR project = "Red Projects") AND (status = Done OR status = Closed OR status = Resolved) AND updated < 15d ) ORDER BY Rank ASC
What we are doing here is trying to see all unresolved items, as well as any resolved items which have been updated less than 15 days ago. We are still having tasks/bugs/epics/etc show up (going by the last updated date) which are much older than this. There's one right now for example which has a last updated date of 2012/12/01.
So a couple of things which I've noted.
eg. the above actually ends up as the following which makes no sense.
(project = "Red Projects" OR component = TeamRed) AND resolution = Unresolved OR (component = TeamRed OR project = "Red Projects") AND (status = Done OR status = Closed OR status = Resolved) AND updated < 15d ORDER BY Rank ASC
We could of course use the Kanban releases but have yet to see a thorough enough explanation which doesn't sound like it's going to release all of the project tasks/stories/bugs/etc from other boards as well.
I think you've got your relative dates wrong, if I am reading the question correctly. Might be easier to explain the clause:
AND updated < 15d
That means "updated date is before a date 15 days in the future ". I think you actually want:
AND updated > -15d
That means "updated after a date 15 days in the past"
(Also, the default for "no units" is usually minutes, so <15 is the same as <15 minutes)
No problem, I do exactly the same all the time when I'm sketching out JQL I do search in the future, but it's usually something like "due date in the next two weeks", but dates in the past do form the vast majority of everyone's searches in my experience!
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