Catalog item to add role to group

[Preethi26]

Hi Team,

I need to create catalog item when role and group selected, role has to be added to selected group.

Can we please help me out, Can i use flow designers to achieve easily or workflow.

Thank You

[Aman Kumar S · Accepted solution]

Hi @Preethi26 

try this:

var roles = [];
var role = new GlideRecord('sys_user_role');
role.addEncodedQuery('nameINitil,admin');
role.query();
while(role.next()){
roles.push(role.getUniqueValue());
}
gs.info(roles);

//var roleID = roles.split(',');/// comment this line, not needed

for (var i = 0; i < roles.length; i++) {

var grRole = new GlideRecord('sys_group_has_role');
grRole.initialize();
grRole.group = '019ad92ec7230010393d265c95c260dd';
grRole.role = roles[i];
grRole.setWorkflow(false);
grRole.insert();
}

[Vishal Birajdar · Accepted solution]

Hi @Preethi26 

Can you try below script background script :

var roles = [];
var role = new GlideRecord('sys_user_role');
role.addEncodedQuery('nameINitil,admin');
role.query();
while(role.next()){
roles.push(role.getUniqueValue());
}

for (var i = 0; i < roles.length; i++) {
var grRole = new GlideRecord('sys_group_has_role');
grRole.initialize();
grRole.setValue('group','477a05d153013010b846ddeeff7b1225');   ///use sys_id of your group
grRole.setValue('role',roles[i]);
grRole.insert();
}

Also, check by putting some logs if you are getting sys_id of roles or name in workflow for   'current.variables.roles_to_be_added' variable. If you are getting the sys_ids then no need to loop through 

var roles = current.variables.roles_to_be_added.toString().split(',');

for (var i = 0; i < roles.length; i++) {
var grRole = new GlideRecord('sys_group_has_role');
grRole.initialize();
grRole.setValue('group', current.variables.group);   ///use sys_id of your group
grRole.setValue('role',roles[i]);
grRole.insert();
}

You can do this using flow designer also which is better option i guess...

[Vishal Birajdar]

Hi @Preethi26 

For flow designer you first need to use for each flow logic and then create record in 'sys_group_has_role'

1. Loop through list of roles

2. Create a record 

[Vishal Birajdar]

Hi @Preethi26 

Please try updated logic below :

1. After Get catalog variables action , use 'Look up records' action & put condition script as below

var roles = fd_data.trigger.request_item.variables.roles; //use your variable name 
 return 'sys_idIN' + roles;

2. use for each flow logic on  look up records >> Role records 

3. Create Record 

Group = Get catalog variables >> Groups >> Sys id

Role = For each >> Role record >> sys id

I have checked & its working ....

Hope this helps....!!

[Preethi26]

Hi @Vishal Birajdar 

Iam trying to do but i cant able to select look up role record Why its happening.

[Vishal Birajdar]

Hi @Preethi26 

Its because you have selected 'Look up Record' action (will work for only one record).

Use 'Look up Records' action.

[Preethi26]

Thanks @Vishal Birajdar  It worked for Add role to group.

Iam trying to do same to remove roles from group, but its stuck in delete record action can you help