Updating another table field value using Business Rule

[Mohammed Kemal]

Hi everyone,

I have a table 2 called (sn_compliance_control) where I have a custom string field(u_control_id). I would like this field to be updated from another table 1 (sn_compliance_policy_statement)'s field called "Reference"(reference).

N.B. the field reference is a string field found within the table

I wrote after BR in table 1 with

• Condition set to (Reference is not empty),
• When set to async, and
• Advanced checked (insert, update, query)

Here is my script:

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

	var referenceValue = new GlideRecord('sn_compliance_control');
	referenceValue.addQuery('u_control_id', current.reference);
	referenceValue.query();
	
	while (referenceValue.next()){
		
		referenceValue.setValue('u_control_id', current.reference);
		referenceValue.update();
	}

})(current, previous);

My goal is to update all control id in my table 2 with table one value. I need a second eye to my BR/code since it's not doing the way it supposed to do?

Thanks,

Mokemal!

[Mohammed Kemal]

Hi Mark,

It's working when you open the Control objective record and made an update to the field(Reference). It then populate the control id in the control table.

But in my case, the field "Reference" is not going to be updated once it's set in the control objective table.

That's why I set the BR, When = async

but the code isn't running?

[Mark Roethof]

So did you add any debugging? Is the Business Rule itself for example triggered? Maybe you made a mistake somewhere.

I also just tested with the condition you mentioned, reference is not empty + async. Still works here.

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020, 2021 ServiceNow Community MVP
2020, 2021 ServiceNow Developer MVP

---

LinkedIn
Community article, blog, video list

[Mark Roethof]

Attached the Business Rule I setup and which is working on my PDI.

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020, 2021 ServiceNow Community MVP
2020, 2021 ServiceNow Developer MVP

---

LinkedIn
Community article, blog, video list

[Upender Kumar]

@mokemal we can have a zoom or gmeet meeting

[Upender Kumar]

Make sure BR is on sn_compliance_policy_statement table and try below code

var referenceValue = new GlideRecord('sn_compliance_control');
referenceValue.addQuery('u_control_id', current.reference);
referenceValue.setValue('u_control_id', current.reference);
referenceValue.updateMultiple();