I would like to get project issues sorted based on who made the modification to the Issue 'recently'

Question

Mainly I would like to get project issues sorted based on who made the modification to the Issue 'recently' that includes part of the Issues History.

After my JQL query execution, User who made the modification to the Issue 'recently' to be listed for all project Issues based on the specific state of the issues.

Also looking for the way to get "Execution Times" and "Time In Source Status" details for A SPECIFIC transition given that includes part of the Transitions tab of Issue.

Mohamed Riza_s7j38y · Answer

It is not possible to get the user's name who updated in the JQL currently as this information is not present as a custom field that can be leveraged on in the JQL. Rather this is a historic data, therefore you will have to open the issue to view historic information of the issue.

This feature is implemented in an upcoming Jira version, Jira 8.0. You may review https://jira.atlassian.com/browse/JRASERVER-1973. You may get the EAP to check this feature out.

manjunatha.rajappa · Answer

But the below JQL command doesn't give who/user name made the modification to the Issues recently, if issue has been modified by multiple users.

project = SSP ORDER BY updated DESC

Yes, JSU plugin might help me to achieve my requirement, let me re-check and confirm the same.

Mohamed Riza_s7j38y · Answer

Hi @manjunatha.rajappa

To get issues that are most recently modified using JQL, you may use the "ORDER BY updated DESC" like so:

project = SSP ORDER BY updated DESC

With regards to the transition tab data, this from from the JSU plugin. Looking at other posts in the community, this doesn't seem possible to use in the JQL:

* https://community.atlassian.com/t5/Answers-Developer-Questions/JIRA-Suite-Utilities-Issue-Transitions-Tab-gt-gt-gt-Reading-Data/qaq-p/525841
* https://community.atlassian.com/t5/Answers-Developer-Questions/JIRA-Suite-Utilities-Issue-Transitions-Tab-gt-gt-gt-Reading-Data/qaq-p/525841