How to get the email from watch list in inbound email condition

[narenreddy]

Hi,

I am using the inbound email notification Update Case via AcceptReject, Where I need to modify the condition on this. Given the requirement below.

Current Logic:   ((new CSEMailUtil).isUserExist(email.from)) && (current.contact.email == email.from)

New Logic:     ((new CSEMailUtil).isUserExist(email.from)) && ((current.contact.email == email.from)     OR   (user is on the customer update list))

It has to accept the email from who are there in watch list. So please assist me.

[Abhinay Erra]

narender,

Create a new script include and name it as getEmails and add this script in there

function getEmails(id){
var arr=[];
var gr= new GlideRecord('sys_user');
gr.addQuery('sys_id','IN',id);
gr.query();
while(gr.next()){
arr.push(gr.getValue('email'));
}
return arr.toString();
}

Your modified condition will be

((new CSEMailUtil).isUserExist(email.from)) && ((current.contact.email == email.from) || (getEmails(current.<put your watch_list field name here>.toString()).indexOf(email.from.toString())>-1))

[Chuck Tomasi]

That was my approach first, but then realized you don't need to get ALL the users in the watch list, you only need to get one (the one you are checking) and see if their sys_id is in the list.

[Abhinay Erra]

LOL, I agree. I was in a hurry to provide an answer.

[Chuck Tomasi]

Here's how I would do it. Create a script include called isEmailInList. Take out the sample code and replace it with this function.

function isEmailInList(list, email) {

  var u = new GlideRecord('sys_user');

  if (u.get('email', email)) {

  if (list.indexOf(u.getValue('sys_id')) > 0)

  return true;

  }

  return false;

}

Now in your condition, add

|| isEmailInList(current.watch_list, email.from)

Modify current.watch_list to what ever list field you want to use.

Note: completely untested.