I am creating a Saved Search of ALL open (Status = Not Closed) Cases.
Some cases have no User Notes, some have auto generated notes and some have actively added by employees.
I need to include any cases with no User Notes, the User Notes actively added by employees, while excluding Auto Generated notes
When my criteria = Case:User Notes: Title is not CHANGE Reply to Customer, I do not get the Open Case with only this User Note.
Can someone suggest a formula that would include All Open (not closed) Cases and the Maximum User Note that is not “An Auto Generated note”?
Looking for ALL the Not Closed Cases and I need the latest informative User Note Memos.
I have defined which User Note Memos are not informative as the number 1 using Formula (Numeric) CASE WHEN {usernotes.note} LIKE 'Reply was sent' THEN 1 ELSE 0 END.
I need ALL Not Closed Cases where there is no User Note Memo (0) and the Maximum informative User Note Memo (0) when there is also a not informative User Note Memo (1) for the same case.
Additionally, How do I prevent the auto generated user notes from being created when the case is updated. It is not in Setup>Support>Support Preferences>Notification>Update.