Dot walk inside business rule to set value

[sndev1099]

Hello, 

I need some assistance setting a field inside my BR. 

The value of Event type 2 needs pushing to a field on the user form. Can I do that by dotwalking to it?

Here is my code:

(function executeRule(current, previous /*null when async*/) {
	
	var event = new GlideRecord('u_insider_risk_population_management');
	event.addQuery('x_lbg_insider_risk_eventtype1', 'Vetting');
	event.addQuery('x_lbg_insider_risk_eventoutcome2','Complete');
	event.query();
	
	while (event.next()) {
		
		//gs.info("AB 30_06 " + event.getRowCount());
		event.setValue(current.u_user.x_lbg_insider_risk_vetting_type, current.x_lbg_insider_risk_eventtype2);
		event.update();
	}

})(current, previous);

[Shane J]

You can't dotwalk to a value on a table to set it.  You'll need to do a GlideRecord query and update the record on the table directly.

[sndev1099]

Ok thanks Shane. Are they any limitations to doing 2 gliderecord queries in one business rule?

[Shane J]

Not that I'm aware of.  😃

[MrMuhammad · Accepted solution]

No, you cannot as you need to force update the value on the user table but with dot-walking you won't have access to user table object that help you with updating the value after setting that. 

You can do something like this

while(event.next()){
 var userGr = current.u_user.getRefRecord(); // get users glide record.

 userGr.setValue('x_lbg_insider_risk_vetting_type', current.x_lbg_insider_risk_eventtype2);
 userGr.update();

}

Please mark this correct & helpful if it answered your question.

Thanks & Regards,
Sharjeel