Alert Composer - Custom SQL in Add Filter is selecting all employees
SummaryAlert Composer - Custom SQL in Add Filter is selecting all employees
To achieve client requirement we have written custom SQL in Add filter in Resource Alert. we have hard coded 4 employees in the custom SQL & ran the process. It had sent alert notifications to all the four employees. Ideally one the employee is not eligible to send the notifications. We have ran the same sql in Data model & see only 3 employees being picked up. Any reason why alert is picking all employees where as in data model it is it not?
Appreciate your quick help on this !