We have a search set up for un-replied tickets that looks something like this:
Owner = '__CurrentUser__' AND LastUpdatedBy != '__CurrentUser__' AND LastUpdated > '3 days ago' AND Status = '__Active__'
The problem with this is that any update of the ticket, such as adding watchers, or changing custom fields will change LastUpdated and LastUpdatedBy.
I’m basically looking for a search that will trigger the same way that the ‘New Messages’ do in a ticket. Is this possible in TicketSQL?