Is there a way to track if the assignee has updated an issue/ ticket within x amount of days

[Craig Pringle]

I'd love to be able to see issues in a filter where the Assignee has not updated the ticket within a certain number of days (e.g. within the last 3 days).

The updated date field isn't enough because if the ticket creator chases with a comment, then the updated date is of course also updated to todays date again, even though the assignee has not been active on this ticket.

[Bill Sheboy]

Hi @Craig Pringle -- Welcome to the Atlassian Community!

To dynamically do what you ask about comparing an issue field (Assignee) to the issue change history, you are going to need to purchase a marketplace addon for JQL. Or...

As a work-around, you could add a custom field (e.g. LastUpdatedByAssignee) and an automation rule to set the field whenever the assignee changes the issue.  For example:

• trigger: issue updated
• condition if/else:
  • advanced compare condition: check changelog to see if the assignee changed
  • action: clear the custom field, setting it to empty
  • action: re-fetch the issue
• advanced compare condition: {{initiator}} equals {{issue.assignee}}
• action: edit the custom field, setting it to {{now}}

You would then be able to query on the custom field as you note, checking for no/stale updates:

project = myProject
 AND (LastUpdatedByAssignee <= startOfDay(-3) OR LastUpdatedByAssignee IS EMPTY)
 AND statusCategory = "In Progress"

Kind regards,
Bill

[John Funk]

Hi Craig - Welcome to the Atlassian Community!

Maybe try: Project = ABC and updatedDate <= startOfDay(-3) and status = "In Progress"

Obviously, you would want to change the status value to whatever value you use in your workflow, and same with Project. 

[Jose Luis Gaitan]

hello, @Craig Pringle 

You can now use the updatedby() JQL function to get this information:

https://confluence.atlassian.com/jirasoftwareserver081/advanced-searching-functions-reference-970611548.html

I hope this can be useful for you.

If you need more support about it, please tell us.

[Craig Pringle]

Many thanks for your speedy response @Jose Luis Gaitan 

Is there a way to move away from having updatedby(user) and using a generic updatedby(assignee).

The use case is really that we want to track which issues have been sitting with an assignee for 3+ days without having been updated at all.

Somewhere in the query I guess we'd need to stress that the assignee was since 3 days the assignee and the assignee only hasn't updated the ticket in that same timeframe.

Thanks,
Craig

[Diogo Nesbitt]

Hi Jose, did you solved this?