query to see if user is in a group

[sigmachiuta]

i am trying to query in a business rule to see if the opened by user of a change is a part of a group.   i cant seem to use current.opened_by.isMemberOf()

so i am querying the group table but i am not returning any results

var usr = current.opened_by.getDisplayValue();
   var gr = new GlideRecord('sys_user_grmember');
   gr.addQuery('group','group name');
   gr.addQuery('user',usr);
   gr.query();
   while (gr.next()){
   gs.log('query ran');
   if (gr.user != null){
   gs.log('query found' + gr.user);
 //do processing
   }else{
gs.log('no user found')
}
   }

[Srinivas Balusu]

So it gives 'no user found'?

[sigmachiuta]

no i put a log at the start and end and i get business rule started, business rule ended without any logs between them thats why i am confused

[Srinivas Balusu]

.getDisplayvalue gives name results like 'Robert', But while querying you have to give sys_id.

SO in your case give

gr.addQuery('user',current.opened_by); which passes the sys_id to query

[Mihir Mohanta]

Hi,

I have modified the script.Please try it

var usr = current.opened_by;  

  var gr = new GlideRecord('sys_user_grmember');  

  gr.addQuery('group','sys_id of the group you want');  

  gr.addQuery('user',usr);  

  gr.query();  

  while (gr.next()){  

  gs.log('query ran');  

  if (gr.user != null){  

  gs.log('query found' + gr.user);  

//do processing  

  }else{  

gs.log('no user found')  

}  

  }  

You can also achieve this by using isMemberOf() function.

Thanks,

Mihir