Community
Q&A
Jira
Questions
Query to show open issues and issues closed in last x days?

Query to show open issues and issues closed in last x days?

I want my query to show all issues that are either open now or were closed within the last x number of days. Essentially, tickets closed more than x days ago will "fall off" the board/query. Here is what I have:

project = FUS AND (resolved >= -1d OR status != "Resolved") ORDER BY cf[10011] ASC, created DESC

Unfortunately I'm still seeing tickets I closed more than 1 day ago. What am I doing wrong?

p.s. ">= -1d" was generated by the simple query. I also tried "<= 1d" and get the same results.

3 answers

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

3 votes

Answer accepted

This works:

project = FUS AND (resolved >= -1d OR status != Done) ORDER BY cf[10011] ASC, created DESC

I thought "Resolved" was the special status that included "Done" and "Closed", etc. No?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

Try this...

AND status = "In Dev" OR resolved > -1d

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

What do you mean by "closed"? Resolved means that the resolution of an issue was set. If you mean by "closed", that the issue was moved to the Closed status, then your JQL query should be like this: