That’s right! There is no entry in the logs for this. The automation only notifies you about changes that are logged in the staff action logs. That’s why I suggested that an entry should always be created for such changes.
This query deliberately only queries a short period of time. When I comment out the time restriction, I see at least some changes, but there are no log entries for most changes.
- AND uh.updated_at > CURRENT_TIMESTAMP - INTERVAL '60 minutes'
+ --AND uh.updated_at > CURRENT_TIMESTAMP - INTERVAL '60 minutes'
However, to prevent the automation script from reporting those old changes, I have added this time restriction.