As title says, I can not get any results by using JQL like * status changed TO "Done" AFTER "2021/08/01" * status changed TO "Done" AFTER "2021-08-01" * status changed TO Done AFTER "2021/08/01" * status CHANGED TO "Done" AFTER "2021/08/01" All JQL does not work. But I have surely these tickets whose status changed to done after 1st August.

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 (status changed TO "Done" AFTER "2021/08/01") is not working

Hiroshi Nishio

As title says, I can not get any results by using JQL like

status changed TO "Done" AFTER "2021/08/01"
status changed TO "Done" AFTER "2021-08-01"
status changed TO Done AFTER "2021/08/01"
status CHANGED TO "Done" AFTER "2021/08/01"

All JQL does not work. But I have surely these tickets whose status changed to done after 1st August.

Screenshot 2022-09-05 171525.png

Accepted answers

Hiroshi Nishio

Not a very direct solution, but I solved it by using status id instead of status name. For example, "Done" was "10006" for me.

It looks like the problem is that the names don't match, but it looks like they do, so I'm out of luck.

The important thing is that it doesn't matter if it is a name or an id, I hope this is the same for all users, and Done is 10006.

All comments

Matthias Gaiser _K15t_

Hi @Hiroshi Nishio

I've verified your JQL statements on my instance and they work properly.

status changed TO "Done" AFTER "2017-11-28"

You can double-check the history on your issue again - other than that, I'm not sure what the problem is. On Server/DC, I'd say perform a reindex, but that's not available on Cloud.

Cheers,
Matthias.

Hiroshi Nishio

Hi @Matthias Gaiser _K15t_

What a surprise. So it doesn't seem to be a problem with the JQL itself. Hmmm, I'll check my ticket.

Hiroshi Nishio

@Matthias Gaiser _K15t_

Doublechecked my ticket and still, it seems I changed this ticket status from Doing to Done 4 hours ago, which is Sep 5, 2022. So it means my JQL should include at least this ticket but does not.

2022-09-05 (1).png

Matthias Gaiser _K15t_

I agree, @Hiroshi Nishio. But I'm afraid, I can give you any other tips. I'll ping some others for advice.

Hiroshi Nishio

Not a very direct solution, but I solved it by using status id instead of status name. For example, "Done" was "10006" for me.

It looks like the problem is that the names don't match, but it looks like they do, so I'm out of luck.

The important thing is that it doesn't matter if it is a name or an id, I hope this is the same for all users, and Done is 10006.

Hiroshi Nishio

Status name is "Done" as a default, whose status id is 10006 for all jira users??

Matthias Gaiser _K15t_

Thank you for sharing your solution @Hiroshi Nishio

In case you didn't know, you can access the list of all status in a JSON format which contains also the status id, e.g.:

https://ecosystem.atlassian.net/rest/api/2/status

Hiroshi Nishio

@Matthias Gaiser _K15t_ I did not know that, very useful.
By the way, I noticed this, but if I wanted to get status = Done in the so-called user sense, perhaps it would be more generic to use status category = Done and status category ID = 3 as the condition?

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

jira-software-cloud