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

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

Yi Liang_2068pm

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

Accepted answers

All comments

Samuel Prathipaty

Hi @Yi Liang

Please share the JQL query that you are using.

Yi Liang_2068pm

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.

Aaron Pavez _ServiceRocket_

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

Jack Brickey

@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_2068pm

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

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