JIRA Query help

trevor nagy January 2, 2014

I am trying to run a query with the following:

summary ~ "\"Hot Fix\"" or description ~ "\"Hot Fix\"" AND (resolution = "Fixed" AND status = "Closed") AND (updated >= "2013-10-01" AND updated <= "2013-12-31") ORDER BY key DESC

However it is pulling created and updated dates outside the range that i am requesting above. Does anyone have an idea of what i am doing wrong?

1 answer

1 accepted

0 votes
Answer accepted
Ubisoft
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 2, 2014

Just missing some brackets :-), you want to put them around your ORs, not your ANDs

(summary ~ "\"Hot Fix\"" OR description ~ "\"Hot Fix\"") AND resolution = "Fixed" AND status = "Closed" AND updated >= "2013-10-01" AND updated <= "2013-12-31" ORDER BY key DESC

trevor nagy January 2, 2014

That worked perfectly, thanks! I've been trying to fix this for almost an hour.

Suggest an answer

Log in or Sign up to answer