I'm working on a query to find users who closed an issue. Thisfare I haven't been able to do so. What I found in communities is an example with which you can search on a specific name. This is not what I want. The names are unknown.
This is what I have:
project = "Test" and status changed to closed"
How is it possible to get the name of the person who did close an issue?
Thanks in advance for your help.
Hi Martin - Welcome to the Atlassian Community!
We actually have a post function that assigns the issue to the person who moves the card into the status. So we just look at the assignee.
However, if you don't do that, you might can get to it by the API, but that's out of my expertise. Maybe someone else can chime in here. But you are not going to be able to do it by JQL in the advanced search.
I had a requirement like this in the past and implemented the following - currently we don't know if you are on Server or Cloud - the query we used was on Server, also I am not sure if an App was involved.
sales = this is just the name of a group - I don't think it will work very well from an usage perspective to query all over the userbase, a specific username will be to specific, though - I can understand that.
project = TEST and status CHANGED to "Closed" BY (membersOf("sales"))
I am not sure if there is a field actually holding the data - from my understanding the query reads it (in the background, nothing it would tell the user) from history of some kind.
For showing on a dashboard, indeed, data would have to exist in a field - I don't think you can have this without some kind of scripting, but probably others have an idea on this.
Update: a different idea would be to create a custom field like "Closing user" and to add a post function to resolve (or close) transition. There you could execute a "update a field" post function putting the current user to the "Closing user" field.
Doing so you can filter for the field on a dashboard.
I used in an example Jira Automation Suite - it worked very well, it might depend on what you have available. Other Apps are probably good as well.
Hey there Cloud Community members! We’re excited to give you the first glimpse of the new home for business teams on Jira — Jira Work Management. Jira Work Management is the next generation of J...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events