How to extract the issues which are resolved and resolution updated between certain time frame

[chanish NA]

How to write a JQL filter for issues which are resolved and resolution updated between certain time frame

[John Funk · Accepted solution]

Hi Chanish,

Try something like:

Project = ABC and Resolution is not empty and Resolved >= 2020-06-01 and Resolved <= 2020-06-30

That will show all issues resolved in the month of June.

[chanish NA]

Hi,

Thank you for the suggestion.

But even i want to filter the resolution field also based on time frame.

For example:

Project = ABC and Resolution is not empty during ("2020/06/01", "2020/06/30") and Resolved >= 2020-06-01 and Resolved <= 2020-06-30

I'm getting some syntax error for the above.

Any suggestions?

[John Funk]

Basically, if it was Resolved during that time then it cannot also be empty during that same time. 

And the syntax problems are due to your using "during" which is not available in that context. You would need to use the combination of >= and <= like the end part. 

[chanish NA]

can you please put it in a query.

thank you.

[John Funk]

I am not understanding what query you want. Any issue resolved during a specific time frame cannot be empty during that same time frame. 

You put in words what you want to see instead of trying to write the query first. 

[chanish NA]

Basically i am looking for a filter which filters issues resolved during a specific time frame and resolution is not empty at that same period

[John Funk]

Just to be clear - saying the issue is not empty in the same time period is redundant and would not change the results at all. The original query I provided solves your need. 🙂

[chanish NA]

Ok got it. Thank you.