Query based on last assignee date

Carlye Petoff

Trying to find a way to query the most recent date of the last user assigned to a ticket and compare that date to the current date to see how long a ticket has been opened while being assigned to the most recent assignee.  As a result, I would like a list of tickets that have been opened and assigned to the most recent assignee for more than 60 days. 

I realize collecting the most recent assignee dates can be done with the api, but I'm wondering if there is a query in the UI filters that would give me the same results.  The api gives me a list of ticket numbers and I can create URLs to each ticket individually, but I can not view a full list of these results in JIRA, which is the goal.

Any suggestions would be appreciated.

Bill Sheboy

Hi @Carlye Petoff 

I do not believe it is possible with out-of-the-box JQL to get the last assignment date. There may be something in the marketplace to do this, or you could pull it from the change history with the REST API (one issue at a time).

A work-around going forward would be to add a custom field to store when the assignee is set using an automation rule.  You would then be able to report on that field with JQL.

Kind regards,
Bill