Why did I get the JIRAs after the date I defined: Example "status was not closed on "2024/03/31"

Yi Liang November 19, 2024

Hi,

I feel a little bit confused on the JIRA Query

Example 1

status was open on "2024/03/31", for this one, I didn't get any JIRAs opened after 2024-03-31

 

Example 2

issuetype in (bug, feature) and status was not closed on "2024/03/31" and (resolution is empty or resolution in (fixed, done))

status was not closed on "2024/03/31",  for this one, I kept getting the JIRAs opened after 2024-03-31, like July.

 

any clue?

Thanks

2 answers

0 votes
Aaron Pavez _ServiceRocket_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 20, 2024

HI @Yi Liang 

It seems that the WAS ON is not working as expected. I can't filter. It seems this is a Bug. I'll look for it so you can vote (I'm still not sure its a bug though).

But taking a second look:

project = test and type = Task and status WAS Open DURING (startOfDay(),endOfDay())

When I run this I get a lot of tickets, but the thing is WAS OPEN DURING TODAY, means all the tickets are still OPEN today. 

2024-11-20 10_38_57-Issue navigator - Jira — Mozilla Firefox.jpg

 I moved the status of those tickets and left one open. I still get the same result. because they were in OPEN status (was open) during today.

So the JQL is correct. and the result too.

Can you send us a screenshot of the results from your JQL?

Are the old tickets still in OPEN? did you changed from OPEN today?

Regards

0 votes
Samuel Prathipaty
Contributor
November 19, 2024

Hi @Yi Liang

Please share the JQL query that you are using.

Yi Liang November 20, 2024

issuetype in (bug, feature) and status was not closed on "2024/03/31" and (resolution is empty or resolution in (fixed, done))

I can see jiras opened in July.

Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 28, 2025

@Yi Liang , I am confused. Could you restate what your query goal is exactly? Are you trying to find all bugs & features that currently have a resolution of fixed, done or empty that were not in a closed status on 2024/03/31? That is what the JQL describes. Or something else? 

Yi Liang February 5, 2025

Hi Jack,

I added another criteria to define the creation date.

See the example.

"Fix Version" = T2024 and type in (bug, feature) and (status was not closed on "2024/07/01" and createdDate <= "2024/09/30 23:59") and (resolution is empty or resolution in (fixed, done))

Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 5, 2025

Ok. So what are your observations at this time?

Yi Liang February 5, 2025

After I defined the created date and time, I have got what I expected.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
TAGS
AUG Leaders

Atlassian Community Events