Automation Trigger If No Time Logged Against Issue

Jason Smith_gems8k

I am attempting to create an automation to identify issues in a project with a certain status that have not had any time logged against them in the given day.  I want this to check to occur at a specific time each weekday.

 

I know to use the scheduled option on the automation so that piece is complete and the status is being checked to see if it meets the status to take action against.

 

I am assuming I will need to add a JQL condition to validate against {{issue.timeSpent}}, but I am not certain how to write the JQL condition to determine if that field was updated in the current day.

Any suggestions are welcome.

 

Jason Smith_gems8k

So this ended up being a bit more involved.  Sharing below in case this helps others in the future.

 

I set up a scheduled automation to run each weekday and used this JQL to limit the issues that are flagged:

 

status IN ("In Progress", "Design", "Testing") and type != "Epic"

 

I then added a JQL condition as follows:

 

statusCategory != "To Do" AND ((worklogDate <= -1d AND NOT worklogdate > -1d) OR timespent is empty)