HRSD

abhisek
Tera Contributor

As soon as assigned to person of HR Case becomes inactive or removed from that group, the assigned to field must be changed to empty for that HR Case and email notification needs to be sent to the group members of that assignment group that HR Case is assigned to. Please make sure that the notification (case assigned to your group) is not sent in this scenario since that would be a duplication. How can I implement it in ServiceNow using Flow design ?

 

Can anyone please help me out. It is urgent.

 

Thanks in advance.

1 REPLY 1

Sandeep Rajput
Tera Patron
Tera Patron

@abhisek  Instead of implementing this via a flow, you should create two business rules, one on sys_user table and other on sys_user_grmember table.

 

Business rule on sys_user:

In the first business rule on sys_user table you can check if active changes to false, in the script you can check if the any hr cases are assigned to this user by querying the  sn_hr_core_case table, prepare an array of all such cases and in the end empty the assigned_to field for all such cases.

 

Business rule on sys_user_grmember: A delete business rule can be created on this table and similar to the previous business rule, you can check if the user is assignee of any hr case, prepare a list of such cases and set the assigned_to field to empty. 

 

Since the assignment_group field would not change by the above business rule hence no new notification would get triggered in this case.

Hope this helps.