What should be the BR condition if I removed the group from sys_user?

[Santosh Oraon]

Hello team,
I have query that , I wanted to create a BR in sys_user_grmember (group member) Table that if one of the group is removed from that user then ex - Hardware , then this BR will be triggered and i can perform the action. I wanted to know what should be the condition of BR 

[Utpal Dutta]

Hi Santosh,

When you remove a user from a group his record will be deleted from Group member table because there is no more mapping of the user to the group. So you need to create a delete BR and in the scripts you need to get the deleted record User's value to process whatever you want to do in that BR. 

I don't think there is any condition that needs to be added as you must want to run this BR for each deleted record.

If my answer helps then please mark it Helpful or Correct!

Thanks,

Utpal

[Utpal Dutta]

Santosh, If my answer was correct then please mark it Correct as well.

Thanks

[Mark Roethof]

Hi there,

Check Delete and add an condition like Group = xxx.

What's the issue you are facing?

[Sagar Pagar]

Hi @Santosh Oraon,

Your BR will be as

Table: Group Member [sys_user_grmember]

When: After

Delete: true

Condition:

Group IS GroupName

If my response helps to solve your issue. Kindly mark it as helpful & correct. It will be helpful for future readers! 👍🏻
Thanks,
Sagar Pagar