Need a Specific query

Sumit Sharma_ru0gma

We have projects created in JIRA, like ENSD, CNSD, Under which we have tickets. We also have automation in place, where a specific user created sends reminders to Ticket reporter on pending status.

I want to take out a report from JIRA to see last manual update and user who updated the ticket by avoiding/excluding update sent by "Support User".

I have tried <assignee not in (Support User)> but it did not help.

 

Andy Heinzer

Hi Sumit,

If I understand your request here, you are wanting to see what the last update to these issues were, but exclude a specific user account's changes.   However Jira's native JQL can't return to you specific changes made on a Jira issue, or the last person that edited the issue.  These are tracked in the database, but this isn't something you can specifically search for via JQL.

You could try to adjust your JQL to something like

(assignee != "Support User  AND assignee IS NOT EMPTY)

Which should at least be able to return to you all the issues that are unassigned and assigned to other users.  But this doesn't tell us who last updated each issue.

 

If you have Jira Server, and have access to the Jira database, it might help to take a closer look at the kb How to obtain issue change history from database

It provides some sample SQL queries you can run against your database in order to see changes like status or custom field changes on an issue.  It probably is not exactly what you are looking for.  But it could be a stepping stone to unlocking that information contained within the SQL database Jira is using.

Andy