Find users in certain status in the past

[Aleksandar Colic]

Hi Team,

I want to get a list of all assigned users with a certain status of an issue in the past. Is it possible?

Regards,

Aleksandar

[Yuliia_Borivets__SaaSJet_ · Accepted solution]

Hi @Aleksandar Colic 

Do you need to find all assignees for a particular issue or list of issues?

There are a few options you can try:

1. History tab for a single issue: you will see all users assigned at different time, including when it was in progress.

  

2. JQL search for the list of issues, depending on your needs can be something like this:

status WAS "In Progress" DURING ("2023/01/01","2023/04/01")

Add issue key (id = MARC-1587) to see particular issue assignee changes 

3. Issue History for Jira app from my team. There you can see all changes in the table view. There are separate columns for the assignee, status or other fields. So, you can clearly see who was assigned to the task when it was in progress:

Test to find the best result for you and let us know.

[RVS_Support · Accepted solution]

Hi @Aleksandar Colic 

You can get the data from the History tab on the issue detail screen.

Or for a better reporting capabilities and viewing multiple issues history at once, you can try out our app

Issue History Reports

You can view the complete change log for your filtered issues along with issue key changes as in the screen below. 

Do Try it out.

Disclaimer : I am part of the team which developed this app

[Nic Brough -Adaptavist-]

Users don't have status, so your question does not make a lot of sense.

My guess is that you mean you want to find issues in a certain status and list out their assignee.  If you search for issues, then "status in (x, y, z)" will give you a list of issues, and you can use that in the issue navigator to see the assignee for each, or save the filter and use it in a dashboard gadget to show assignees.

[Aleksandar Colic]

If the issue is closed, I need historically who was assigned when it was in status "in progress".