Add an user to a Group with a Business Rule?

[ricardorodrigu1]

Hi everyone!

I have the followings requirements:

1. Add a user to a Group based on specific conditions;
2. If the user already exists on the group do not add another record with an update;
3. If we have an update on the database and the user that exists on the group fail to match the specific conditions must be removed from the group;

I have created the following Business Rule on the [sys_user] Table:

      var rec1 = new GlideRecord('sys_user_grmember');

                rec1.initialize();  

                rec1.user = current.sys_id;  

                rec1.group.setDisplayValue('Testing');

                rec1.insert();

This script only answer to my first need (1), anyone can help me for the 2 and 3 requirements?

Thanks in advance,

Ricardo Rodrigues

[veena_kvkk88]

I understand the requirement now.

You could add this inside the script, so when it runs on every update, the conditions will be checked.

1. var rec1 = new GlideRecord('sys_user_grmember');  
2. rec1.addQuery('user', current.sys_id);  
3. rec1.query();  
4. if(!rec1.next())  
5.   {  
6.   rec1.initialize();  
7.   rec1.user = current.sys_id;  
8.   rec1.group.setDisplayValue('Testing');  
9.   rec1.insert();  
10. }
11. else if(current.title != 'IT'){
12.   rec1.delete();
13. }

**Untested code. Might not work

[Mike Allen]

All of these fail to take into account the user AND the group in the general query.   Should it not be:

1. var rec1 = new GlideRecord('sys_user_grmember');
2. rec1.addQuery('group.name', 'Testing');
3. rec1.addQuery('user', current.sys_id);
4. rec1.query();
5. if(!rec1.next())

[Pradeep Sharma]

Good Catch Mike. Updated code with the changes.

[Pradeep Sharma]

Hi Ricardo,

Let me know if that answered your question. If so, please mark it as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list. Thank you

P.S :   If you are viewing this discussion from your "inbox", use the "mark as correct" option under actions. If you are viewing it directly from the thread use the Correct Answer link (red with a star).

[Daniel Shock]

I am trying to do this same thing...but not getting code to work.  Here is my version of script:

var rec1 = new GlideRecord('sys_user_grmember');

rec1.addQuery('user', current.sys_id);

rec1.addQuery('group.name', "Becks Managers");

rec1.query();

if(!rec1.next())

{

rec1.initialize();

rec1.user = current.sys_id;

rec1.group.setDisplayValue('Becks Managers');

rec1.insert();

}