nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

John Funk

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.

All comments

John Funk

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software