I created a notification when any user got role flow_designer then a notification is sent

[AnjiBabu_Ve]

Whenever the Flow Designer role is assigned to a user, a notification should be sent.

To achieve this, I created:

• An event on the sys_user_has_role table

• An after Business Rule on the sys_user_has_role table to queue the event

• A notification configured on the sys_user_has_role table

However, when the role is removed from the user, the notification email is not visible in the Email Logs (sys_email).

Could you help identify the reason for this behavior?

[svirkar420]

Hi @AnjiBabu_Ve , 

The notification might not be triggered because removing a role deletes the record from the sys_user_has_role table, whereas assigning a role inserts a new record.

If your Business Rule is configured only for Insert, it will run when the role is assigned but not when it is removed. As a result, no event is queued and no notification is generated, which is why you do not see any entry in sys_email.

To handle role removal, create a separate Business Rule on sys_user_has_role for the Delete operation and queue the event from there. Also check the Event Log to confirm that the event is being generated when the role is removed.

If this answer helps you then please mark this response as accepted solution and make sure to give a thumbs up 👍.

Regards,

Saurabh V.

[AnjiBabu_Ve]

Hi @svirkar420 
Actually this is the question

However, after the role is removed from the user, the notification email that was previously generated is no longer visible in the Email Logs (sys_email).