how to find who moved the issues to the Review phase

[Karthika Thangavel]

I would like a query data in JIRA to show the following details:

• JIRA story IDs
• Description,
• Date “approved”...aka ready for grooming.
• Who moved the issues to the Review phase

how we can fetch these details in JIRA .

[Alex Koxaras _Relational_]

Hi @Karthika Thangavel ,

It would be best if you could provide more details on how this specific workflow is created, as well as all of its options (conditions, triggers, validators, post functions etc). Maybe it could be something in there that we could use, in order to get to your results. Do you restrict issue movement by assignee, reporter, or specific group/project role?

However it's going to be rather hard, to nearly impossible, to query the history of an issue natively.

[Karthika Thangavel]

Hi @Alex Koxaras _Relational_ 

I want to know the below detils

• Who moved the issues to the Review phase in particular project .(Marketing -Project name )
• JIRA story IDs
• Description,

shall i go with query or plugin wise? we can use any plugin for fetching those details?

[Alex Koxaras _Relational_]

Natively and out of the box, you can't do that.

What I would propose is:

• Create a User Picker Custom Field (in my example my new field is named "custom user picker field")
• Add a post function to all statuses that leads to Review Phase status, to which you will update a custom field. Set "custom user picker field" to be equal to %%CURRENT_USER%%
  
• Create your query as such and replace the "In Progress" status with your status: project = APS AND status changed TO "In Progress" order by created DESC
  
• Add on the result columns the "custom user picker field"
  

From now on you can get this information without the use of a plugin.
Hope that helps!

Alex