Using updated field in JQL query for automation

Question

I created an automated query where it states whenever this ticket is in a specific status and the ticket has not been updated more than 30 days, this ticket shall be marked completed with a comment: "No response from a client".

Below is the query:
status = "Resolved by Tech" AND updated <= "-30d"

For some reason, Jira Software automatically mark the ticket as completed with a comment once the status is set to "Resolved by Tech" and the ticket has been updated way less than 30 days.

What's wrong with this query?

Andrew Graves_4bg5jk · Answer

So far it does look like it is working.  I need to do additional testing to confirm for sure.

JM Perrot · Answer

Nice, let me know if this function works in your case, I'm curious.

startOfDay(-1) will return, in theory, all issues of yesterday. If you want to include today, you can switch for endOfDay(-2) (or -1, I don't remember)

Andrew Graves_4bg5jk · Answer

I haven't tried using "startOfDay" in the query yet.  I just added it in another Jira project for testing and see how that goes with a test query showing this (see below):

status = "Resolved by Tech" AND updated < startOfDay("-1d") ?