How to filter all tickets, which were reopened per day and to show user name, who reopened ticket?

[Daria Korolkova]

Could you please help to understand, how it is possible to find all tickets which were reopened per day? and it doesn't matter in which status they are in current moment. Accept that we need to see, who reopened this ticket, means that ticket can be reopened not only by assignee. Briefly - we need a statistics for reopens per day and by who ticket was reopened.

Thank you in advance.

[Jobin Kuruvilla [Adaptavist] · Accepted solution]

You can create a filter like this:

status changed from Resolved to Open after startOfDay()

You can also include more statuses or change statuses based on your workflow and include specific users (using 'BY' clause) to filter it further down. If you want to find out who reopened it, you will have to capture that in a user custom field in the relevant workflow transition's post function.

[Daria Korolkova]

Thank you, Jobin. What do you mean under "user custom field"? What kind of field is that?

[Jobin Kuruvilla [Adaptavist]]

A new custom field of type 'User Picker'. See https://confluence.atlassian.com/jira/adding-a-custom-field-185729521.html on how to add a custom field.

[Daria Korolkova]

Jobin, hello. Thank you a lot for your help.