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 for find issue resolved in next 3 days

Gajanan Sasane

Hi Team,

I want this kind of JQL to show how many tickets will be closed in the next 3 days.

Please suggest.

Thanks In Advance.

Accepted answers

Walter Buggenhout

Hi @Gajanan Sasane,

That seems more like fortune telling than JQL, if I may open this one with a wink 😉

You cannot filter for things that are unknown. However, if you are using due dates on your issues, you can filter for those issues having a due date in the next 3 days like this:

due <= StartOfDay(3)

This will select all issues with a due date smaller than or equal today + 3 days. You can extend your filter to this:

due <= StartOfDay(3) AND resolution = Unresolved

if you only want to return issues that aren't resolved yet.

All comments

Moses Thomas_08kyb0

@Gajanan Sasane I don't thing this make any sense in JQL language. This is more like writing a script to resolve tickets in next three 3days. We can get info from JQL once they are resolved

Kind regards,

Moses

Gajanan Sasane

Hi @Moses Thomas,

Thanks for your quick response.

Let me check with the script.

Walter Buggenhout

Hi @Gajanan Sasane,

That seems more like fortune telling than JQL, if I may open this one with a wink 😉

You cannot filter for things that are unknown. However, if you are using due dates on your issues, you can filter for those issues having a due date in the next 3 days like this:

due <= StartOfDay(3)

This will select all issues with a due date smaller than or equal today + 3 days. You can extend your filter to this:

due <= StartOfDay(3) AND resolution = Unresolved

if you only want to return issues that aren't resolved yet.

Gajanan Sasane

Hi @Walter Buggenhout,

Great, this works.
I used the due date field in my issue.
Thanks for your suggestion, I appreciate it.

Gajanan Sasane

Hi @Walter Buggenhout

I have a confusion, above mentioned JQL showed also past due date issues.

Please suggest.@Walter Buggenhout,

Jack Brickey

If you wish to exclude issues that are still open but we’re do greater than three days from now then consider the following.

due <= StartOfDay(3) AND due > StartOfDay() AND resolution = Unresolved

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud