- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-20-2023 02:01 AM
Hello,
How to set the "VIP" flag to true on user record when user is part of the group "GLOBAL-VIP-USERS".
Thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-20-2023 02:23 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-20-2023 02:23 AM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-20-2023 02:50 AM
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