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.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
@Rachel Wright (Jira Genie), @Billy Poggi (AUG NOVA, DC), and @Dana Jansen (Confluence Queen) are just some of the folks that lead one of the world's most active Atlassian User Group (AUG)....
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