Automation Trigger If No Time Logged Against Issue

[Jason Smith]

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 · Accepted solution]

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)

[Trudy Claspill]

Hello @Jason Smith 

Welcome to the community.

JQL support querying based on a few options associated with Work Log entries. You can filter against the date of a worklog thus:

worklogDate > -1d 

That will give you issues that have a worklog date within the past day.