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; } } }

JQL to find all the issues which are created in previous months and resolved in current month

Gajanan Sasane

I need JQL to find out all the issues which are created in previous months and resolved in current month.(without using any plugin)

Thanks

Accepted answers

Alexis Robert

Hi @Gajanan Sasane ,

you can use the following JQL :

(created >= startOfMonth(-1) and created <= endOfMonth(-1) )  AND resolutiondate is not EMPTY  AND ( resolutiondate >= startOfMonth() and resolutiondate <= endOfMonth())

Let me know if this helps,

--Alexis

All comments

Alexis Robert

Hi @Gajanan Sasane ,

you can use the following JQL :

(created >= startOfMonth(-1) and created <= endOfMonth(-1) )  AND resolutiondate is not EMPTY  AND ( resolutiondate >= startOfMonth() and resolutiondate <= endOfMonth())

Let me know if this helps,

--Alexis

Gajanan Sasane

Hi @Alexis Robert :

Thanks for your answer.

Is there any option to show all past months issues?

Alexis Robert

Hi @Gajanan Sasane ,

you can modify the function arguments to go back even further : startOfMonth(-1) will give you the previous month, startOfMonth(-2) 2 months ago, etc.

Gajanan Sasane

@Alexis Robert:

Thank you so much.

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-cloud