Set the "VIP" flag to true when user is part of the group.

Rakesh40
Tera Contributor

Hello,

How to set the "VIP" flag to true on user record when user is part of the group "GLOBAL-VIP-USERS".

 

Rakesh40_0-1695200399146.png


Thanks

 

1 ACCEPTED SOLUTION

Kalyani Jangam1
Mega Sage
Mega Sage

Hi @Rakesh40 

If this change only for one group, then by using sys_id you can do it 

 

var grp=new GlideRecord("sys_user_grmember");
grp.addQuery('group','287ee6fea9fe198100ada7950d0b1b73'); // sys_id of your Group
grp.query();
while(grp.next()){
gs.info(grp.user);
var gr_user=new GlideRecord("sys_user");
gr_user.addQuery("sys_id",grp.user);
gr_user.query();
while(gr_user.next()){
gs.info("VIP======="+gr_user.vip);
gr_user.vip='true';
gr_user.update();
}

}

 

By Using Business rule it is possible.

Please check and Mark Helpful and Correct if it really helps you

View solution in original post

2 REPLIES 2

Kalyani Jangam1
Mega Sage
Mega Sage

Hi @Rakesh40 

If this change only for one group, then by using sys_id you can do it 

 

var grp=new GlideRecord("sys_user_grmember");
grp.addQuery('group','287ee6fea9fe198100ada7950d0b1b73'); // sys_id of your Group
grp.query();
while(grp.next()){
gs.info(grp.user);
var gr_user=new GlideRecord("sys_user");
gr_user.addQuery("sys_id",grp.user);
gr_user.query();
while(gr_user.next()){
gs.info("VIP======="+gr_user.vip);
gr_user.vip='true';
gr_user.update();
}

}

 

By Using Business rule it is possible.

Please check and Mark Helpful and Correct if it really helps you

Chetan Mahajan
Kilo Sage
Kilo Sage

Hello @Rakesh40 ,

                                 For existing user simply set flag manually to true from user list view. for new entry you can simply write After insert BR on "sys_user_grmember" table.

in when to run add Group is group "GLOBAL-VIP-USERS". and in Action User.Vip is true.

 

Kindly mark correct and helpful if applicable