question Re: Business rule to check the updated by is member of assignment group in Developer forum

Business rule to check the updated by is member of assignment group

Twinkle S — Mon, 29 Jul 2019 09:34:32 GMT

I have a requirement to make a custom field Respond set to true if the updated by is the member of current assignment group.Everything works fine except the if condition, if condition is not fulfilling. Below is the code for After update

(function executeRule(current, previous /*null when async*/) {

var a=current.sys_updated_by;
var b=current.assignment_group;
var c=gs.getUser();
gs.addInfoMessage(b);
gs.addInfoMessage(a);
if(current.sys_updated_by.isMemberOf(current.assignment_group))
{
gs.addInfoMessage('inside if loop');
current.u_responed=true;

}

Regards

Twinkle

Re: Business rule to check the updated by is member of assignment group

AbhishekGardade — Mon, 29 Jul 2019 09:37:33 GMT

Hello Twinkl,
Check out the below code: You missed current.update().

var a=current.sys_updated_by;
var b=current.assignment_group;
var c=gs.getUserID();
gs.addInfoMessage(b);
gs.addInfoMessage(a);
if(a.isMemberOf(current.assignment_group))
{
gs.addInfoMessage('inside if loop');
current.u_responed=true;

current.setWorkflow(false);

current.udpate();

}

Please mark as Correct Answer/Helpful, if applicable.
Thanks!
Abhishek Gardade

Re: Business rule to check the updated by is member of assignment group

amaradiswamy — Mon, 29 Jul 2019 09:38:35 GMT

Hi,

In If condition you need to use c.isMemberOf() instead of a.isMemberOf().

var a=current.sys_updated_by;
var b=current.assignment_group;
var c=gs.getUser();
gs.addInfoMessage(b);
gs.addInfoMessage(a);
if(c.isMemberOf(current.assignment_group))
{
gs.addInfoMessage('inside if loop');
current.u_responed=true;

}

Re: Business rule to check the updated by is member of assignment group

amaradiswamy — Mon, 29 Jul 2019 09:40:09 GMT

Also, switch BR to before update as using setWorkflow(false) may have negative impacts as per my previous experience

Re: Business rule to check the updated by is member of assignment group

Ahmmed Ali — Mon, 29 Jul 2019 09:40:35 GMT

try if(gs.getUser().isMemberOf(current.assignment_group))

Re: Business rule to check the updated by is member of assignment group

Twinkle S — Mon, 29 Jul 2019 09:42:27 GMT

Hello all,

I dont want to check the getUser . I need to check updated by. Also, the setworkflow() will only work only if the codition is matched. The if condition itself is not fulfilling

Re: Business rule to check the updated by is member of assignment group

hvrdhn88 — Mon, 29 Jul 2019 09:43:28 GMT

try now.

(function executeRule(current, previous /*null when async*/) {

var a=current.sys_updated_by; // this field return the user_id so you have to glide record here to get the sysid.

var gr = new GlideRecord('sys_user');

gr.addQuery('user_name',a);

gr.query();

if(gr.next()){

var res = gr.sys_id;

var b=current.assignment_group;
var c=gs.getUserID();
gs.addInfoMessage(b);
gs.addInfoMessage(a);
if(res.isMemberOf(current.assignment_group))
{
gs.addInfoMessage('inside if loop');
current.u_responed=true;

}

}

Re: Business rule to check the updated by is member of assignment group

AbhishekGardade — Mon, 29 Jul 2019 09:45:58 GMT

Try this code now:

current.setWorkflow(false);

current.udpate();

}

Re: Business rule to check the updated by is member of assignment group

Twinkle S — Mon, 29 Jul 2019 09:49:16 GMT

Nope. Not happening.Its not going inside the if loop

Re: Business rule to check the updated by is member of assignment group

hvrdhn88 — Mon, 29 Jul 2019 09:53:50 GMT

can you put some log and validate it.


var a=current.sys_updated_by; 

gs.log('Updated By is'+ a);

var gr = new GlideRecord('sys_user');

gr.addQuery('user_name',a);

gr.query();
gs.log('Row Count+ gr.getRowCount());
if(gr.next()){

var res = gr.sys_id;


var b=current.assignment_group;
var c=gs.getUserID();
gs.addInfoMessage(b);
gs.addInfoMessage(a);
if(res.isMemberOf(current.assignment_group))
{
gs.log('Comimng inside if block ');
gs.addInfoMessage('inside if loop');
current.u_responed=true;

}

}

Re: Business rule to check the updated by is member of assignment group

hvrdhn88 — Mon, 29 Jul 2019 09:59:34 GMT

make it more simple.

try with below sample code.

	if(gs.getUser().getUserByID(current.sys_updated_by).isMemberOf(current.assignment_group)){

		gs.log('inside if');
current.u_responed=true;
	}

	else {
		
		gs.log('hey else');
	}

Note: Make sure you have written before business rule on UPDATE and you don't need to use current.update().

Re: Business rule to check the updated by is member of assignment group

AbhishekGardade — Mon, 29 Jul 2019 10:00:16 GMT

HEllo Twinkle,

sys_updated_by is not reference field. its taking th user_name . so you need to gliderecord the user table and fetch the sysid or you can check it their itself.

Please mark as Correct Answer/Helpful, if applicable.
Thanks!
Abhishek Gardade