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?
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
That worked perfectly, thanks! I've been trying to fix this for almost an hour.
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.