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

[Yi Liang]

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

[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. 

 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

[Samuel Prathipaty]

Hi @Yi Liang

Please share the JQL query that you are using.

[Yi Liang]

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]

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

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]

Ok. So what are your observations at this time?

[Yi Liang]

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