Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Is the Field/Column(Person Name, Who closed the Ticket) is available in Filters ?

Is there any Filter option available for the field(Person name,Who closed the Ticket) in Issues to Export this Column for all the JIRA Issues as Excel


No, Jira doesn't show this information, although you could obtain it from the database.

Rachel Wright Community Leader Apr 29, 2018

Hi @Ravi Vadlamudi, Steven is absolutely right; although you could also start logging this information if you really need it.  

To do it:

  • Create a custom field.  I recommend the type "user picker" so a Jira user's username is recorded.
  • Go to the transition in the workflow just before an issue is "closed".
  • Add a post function called "Update Issue Custom Field" where you can capture the current user's name and store it in your new custom field.
    • You may need a plugin to get the "Update Issue Custom Field" function.  It's available in one called "Suite Utilities for Jira" (JSU) among others.
    • Insert the variable "%%CURRENT_USER%%" in the "Custom Field Value" field.

Here's some quick documentation on this method:

As always, be sure you really really need this info before creating custom fields, installing plugins, and customizing your Jira instance!  Sometimes we add shiny things and find out, years down the road, that they weren't really needed and now we have to do extra work to clean them up!

Hope this helps,

Rachel Wright
Author, Jira Strategy Admin Workbook

Thank you Rachel,For your prompt response.

But here,JSU Plugin is only available in server.Currently we're on Cloud.Is there any other Alternative(Plugin's which supports Cloud) to work with !!

Even though I've tried this Steps in Cloud,It failed.Let me Show You :

My Requirement :- To get The Field/Column(Person,Who closed the Ticket) in Filters while sorting the Issues for Particular Project.

So, I've configured the Above steps as you said,

1)Created one Custom field named,Ticket Solved by Person

2)Also added a post function named "Update Issue Custom Field".

I'm attaching the Images of Executed Steps for better Understanding of my Issue,Please Advice after having a Glance.

Image 1 :(Created Custom Field with name)


Image 2: (Added in the Post Functions by Inserting CURRENT_USER :)


Image 3:(Field Enabled in Filters Dropdown also,Still Not Appearing this Field in Excel while Exporting)


Have you moved the issues through the transition that has this post function on it?

Thanks for the Response,I've moved the Issues as per the transaction.But It's not working.Problem is JSU Plugin Is not available in cloud.And as I created the Field(Ticket solved by person) is been Created.But Not showing any Response.. 

Is there any other Alternative!!

No.  You need an add-on that can provide a function to pull the data from the history, or catch and record it at the time the transition is executed.

Could you pls suggest the add-on!!  @Nic

I'd use ScriptRunner (I am, of course, biased there, as I work for Adaptavist.  I try not to plug us too much, hence the slightly neutral answer above.  There are other options, just not ones I'd choose when I have SR available)


Log in or Sign up to comment