As title says, I can not get any results by using JQL like
All JQL does not work. But I have surely these tickets whose status changed to done after 1st August.
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.
It depends what you're trying to express. As you might know when you create a status you can assign it to a statusCategory, e.g. Done. So if you search for a statusCategory, this might contain multiple statuses, e.g. Resolved, Closed, Done and not only the Done state. So that's up to you what you want to filter for.
Exactly, I would like to know "Done" as meaning, not "Done" as a string, so maybe status = Resolved and Closed should be treated equally as Done. I am developing an aggregate dashboard (https://workstats.dev/) like the one attached, so I am not the only one who will be using it, but an unspecified number of users.
When I think about it, I feel that perhaps I should make Status Category ID = 3 a condition. Can the status category ID be Null or Undefined?
Ah, I didn't think about that.
But thinking about your use case again. Why don't you filter for the resolutiondate field? When an issue is done in Jira, it should usually get a resolution which will set its resolutiondate field, so you could write a JQL like:
resolutiondate > "2022-09-07"
Thanks for the advice.
Just, please look at lines 2 and 3. By default, it looks like the resolutiondate is still "unresolved".
The first line is resolved, but this is resolved because it was intentionally set to be resolved when the status = Done in the Automation settings. However, there is also the problem that even if the status is changed from Done to Doing, it remains Resolved.
Yeah, I know. This can happen.
Ideally your workflow is configured that way that when an issue is transitioned to an end state, the resolution is set (via a screen or a post-function) and when you move it out of an end state you would clear it again via a post-function.
But this is not the case for all project setups.
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.
Hi @Hiroshi Nishio,
This JQL also works on my side. Can you double-check the "Done" status? Sometimes there is a space hidden somewhere (like " Done" or "Done "). You can use the basic search to select the status you need and then switch to advanced search.
Other than that, you can also try similar JQL queries like:
status changed to Done during (2021-08-01,2022-09-05)
Hope this helps,
Unfortunately... it did not work.
If you do not mind, would I share my project with you??
The reason I want to do it in JQL is that I am in the process of implementing the Jira REST API v3 with OAuth2.0 (3LO) and I need the right JQL. I am experimenting with the web UI for this purpose.