Assignee was in for last 24 hours and not done any changes in the issue

Rajesh Ramankutty May 1, 2024

Dear Team

i  need to find users assigned to a task for 24 hours and not done any changes in the issue using JQL can anyone give me a suggision in Jira Data center 

1 answer

2 votes
Calvin
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 1, 2024

Not sure if I'm understanding correctly, but could you do:

  • assignee is not empty AND updated > -1d

As the thing is, if it hasn't had any changes, then the assignee hasn't been updated too.

Or are you looking for a particular task, and displaying all the users on that task that was assigned and not done anything for over 24 hours?

Rajesh Ramankutty May 1, 2024

Hi thank you for your response 

basically what am trying to do is 

the users who is assigned before 24 hours and not updated anything in that task we need to send an escalation mail to them so am trying to do it with AFJ

Rajesh Ramankutty May 1, 2024

so assigned before 24hours and updated before 24 hours

Matt Parks
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 1, 2024

Unless I am mis-understanding, you don't need to worry about the assignee changing in the last 24 hours, since an assignee change would cause the issue to be updated (as Calvin stated)

Your query will just be updated <= -1d, which will return all work items that have NOT been updated in the last 24 hours. Then configure your email to be sent to the Assignee.

Since you'd probably not want to send an email for any unassigned issues, then I think Calvin's response makes the most sense (although I think you want to look for issues where the updated is less than one day ago, not more than one day ago):  assignee is not empty and updated <= -1d

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events