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?
project
in
(AI, HD, CON) AND
issuetype
in
(Bug, Story)
AND (
status = Closed AND updated <= -5d) OR (status
in
(
"In Staging"
,
"Rejected"
)
) 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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Your brackets are not set correctly! The OR clauses must be in in brackets.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.