I'm having some problems getting JIRA's filtering working the way I want, and their JQL documetation isn't helping.
Here's what I'm trying to do:
The idea behind (4) is to keep the filter relatively clean, so it's logical to ignore any "Closed" issue that hasn't been updated in at least 5 days.
Here's my JQL statement
project in (AI, HD, CON) AND issuetype in (Bug, Story) AND status = Closed AND updated <= -5d OR status in ("In Staging", "Rejected") AND issuetype in (Bug, Story) ORDER BY Rank ASC
However, the "updated <= -5d" seems to be ignored, and returns pretty much any story that's closed, regardless of when it was last updated.
Is this just not achievable in JIRA?
(AI, HD, CON) AND
status = Closed AND updated <= -5d) OR (status
) ORDER BY Rank ASC
You need to separate your two separate clauses with parentheses.
Issuetype was in there twice which is redundant.
Thanks Jamie. I'd experimented with Parenthesis but ran into problems, my limited knowledge of "JQL" made me think that perhaps parenthesis wasn't understood so removed them.
I flipped "updated <= -5d" to "updated >= -5d" which seems to finally be giving me what I expected. I found that syntax incredibly odd.
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