nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

All comments

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

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.

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

Diogo Nesbitt

Hi Jose, did you solved this?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud