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

Search issues during future date

Wills_Chou

Trying to search the issue during certain date by DURING.

For example, "Project Name" = Test AND project in (Atest,Btest) AND assignee was in membersOf(RDteam) DURING (2022-12-25, 2022-12-31)

In the future date, the result should be 0, but it still come out some issues.

How to change the JQL to get the right result?

Accepted answers

All comments

Trudy P Claspill

Hello @Wills_Chou

Welcome to the community.

What problem are you trying to solve by specifying a date range that is in the future?

Wills_Chou

Yes, the data range in the past wouldn't be a problem, problem only happens in the date range in the future.

Marta Woźniak-Semeniuk_m044pw

Hey,
take a look at the documentation for DURING operator
I thing using WAS in not the right choice here
1 - you are looking for the future dates
2 - it might have a problem with operating with Assignee being a member of the group.
Try using “IS” and use between dates instead of during.

Trudy P Claspill

Why are you trying to search for issues based on the setting of a field value during a future date range? Since that date range is in the future it is illogical to search based on it.

Wills_Chou

I tried "IS" but it didn't work, the message showed that "IS" is for EMPTY use.

Wills_Chou

Creating a report this year sorting by weeks.

From 01/01/2022 to 12/31/2022 every week, the issue search result would update automatically when the date arrive.

Wills_Chou

I tried another keyword, operator, or function, it still doesn't work.

JIRA JQL seems not support the date in the future searching.

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