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...

[Dr Atul G- LNG]

Hi @Preethi26 

These are helpful link. Give a try and share teh feedback.

https://www.servicenow.com/community/itsm-forum/create-a-group-from-catalog-item-and-assign-couple-o...

https://www.servicenow.com/community/developer-forum/how-to-dynamically-add-role-to-group/m-p/151076...

https://www.servicenow.com/community/itsm-forum/automatically-add-role-to-group-via-script/m-p/74932...

[Preethi26]

Hi @Dr Atul G- LNG 

Thanks,

I have created catalog item with group as reference , role as list field and created workflow but this script is not adding roles to group can you help.

var roles = [];
var role = new GlideRecord('sys_user_role');
role.addEncodedQuery('name','IN',current.variables.roles_to_be_added);
role.query();

while(role.next()){
roles.push(role.sys_id.toString());
}

var roleID = roles.split(',');
for (var i = 0; i < roleID.length; i++) {
var grRole = new GlideRecord('sys_group_has_role');
grRole.initialize();
grRole.group = current.variables.group;
grRole.role = roleID[i];
grRole.setWorkflow(false);
grRole.insert();
}

[Aman Kumar S]

Hi @Preethi26 

Update your script as below:

var roles = [];
var role = new GlideRecord('sys_user_role');
role.addEncodedQuery('nameIN' +current.variables.roles_to_be_added.toString());
role.query();
while(role.next()){
roles.push(role.getUniqueValue());
}

var roleID = roles.split(',');
for (var i = 0; i < roleID.length; i++) {
var grRole = new GlideRecord('sys_group_has_role');
grRole.initialize();
grRole.group = current.variables.group;
grRole.role = roleID[i];
grRole.setWorkflow(false);
grRole.insert();
}

[Preethi26]

Hi Aman,

I tried it but still its not added.

I have tried checking in background script as well in OOB instance but no success.

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

var roleID = roles.split(',');
for (var i = 0; i < roleID.length; i++) {
var grRole = new GlideRecord('sys_group_has_role');
grRole.initialize();
grRole.group = '019ad92ec7230010393d265c95c260dd';
grRole.role = roleID[i];
grRole.setWorkflow(false);
grRole.insert();
}