1 ACCEPTED SOLUTION
Hi
You can achieve this using a Notification Email Script and use the code as below which will check if users of the group are belonging to same portfolio or not and will trigger accordingly as you require:
Use the Script as below:
(function runMailScript(/* GlideRecord */ current, /* TemplatePrinter */ template,
/* Optional EmailOutbound */ email, /* Optional GlideRecord */ email_action,
/* Optional GlideRecord */ event) {
// Add your code here
var getUserRoleGroup = current.FieldName; //Replace "FieldName" with your Field i.e.User Role Group
var port = current.FieldName; //Replace "FieldName" with your Field i.e.Portfolio
var getGroupMembers = fetchGroupMembers(getUserRoleGroup);
var getUserDetails = validateUser(getGroupMembers,port);
function fetchGroupMembers(groupID){
var arr = [];
var gr = new GlideRecord('sys_user_grmember');
gr.addQuery('group',groupID);
gr.query();
while(gr.next()){
arr.push(gr.user.toString());
}
return arr.toString();
}
function validateUser(users,port){
var splitUsers = users.split(',');
for(var i =0;i<splitUsers.length;i++){
var checkPortfolio = validatePortfolio(splitUsers[i]);
}
}
function validatePortfolio(userID,port){
var gr1 = new GlideRecord('sys_user');
gr1.addQuery('sys_id',userID);
gr1.query();
if(gr1.next()){
if(gr1.FieldName == port){
email.setReplyTo(gr1.email.toString());
}
}
}
})(current, template, email, email_action, event);Now call this Notification Script in your Notification body with below syntax as below:
${mail_script:Mail Script Name}Just replace the field names in script above and let me know if you are stuck.
Hope this helps. Please mark the answer as correct/helpful based on impact.
Regards,
Shloke
Hi Kalyani,
What is your requirement, You want to add the statis users in email notifiication or it should come dynamically from group based on some conditions?
If static, then yes you can add the users like below in email notification.
