Copying a user from a reference field on one table to another reference field on another table

[matt_a]

I have a reference field on one table that I want to copy to a reference field on another table.

The fields both contain users.

I am wanting these fields to mirror so that when its updated on the master, it updates on the other table.

I am thinking that the best way to do this would be using a before business rule on an update or insert.

This is what I have tried, but its not working:

Can anyone point me in the right direction? and show me what im doing wrong?

Many thanks

[asifnoor]

Hi,

AS you said there are reference fields, do not use displayValue

just mention the column

bu.setValue("u_hr_business_partner",current.u_hr_business_partner);

Mark the comment as a correct answer and helpful once worked.

[Mark Roethof]

Hi there,

Line 4, u_hr_business_unit.sys_id. Don't think you need the .sys_id. u_hr_business_unit is already a sys_id? Unnecessary dotwalking to a sys_id can cause performance issues.

Line 9, did that get logged? If not, your query might not be oke already.

Line 10, the .getDisplayValue() is not needed. If u_hr_business_partner is already the sys_user reference, then this is already a sys_id. Seeing what you wrote, u_hr_business_partner is also a reference to sys_user. So no need for the .getDisplayValue().

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

Kind regards,
Mark

---

LinkedIn
Community article list

[matt_a]

Hi Mark, thanks for taking the time to respond.

I have updated the script to:

function executeRule(current, previous /*null when async*/) {
	
	var bu = new GlideRecord('dl_hr_assignment');
	bu.addQuery('u_hr_business_unit', current.sys_id);
	bu.query();
	
	while (bu.next() ) {
	
		gs.log("Match found - updating " + bu.getDisplayValue());
		bu.setValue('u_hr_business_partner',current.u_hr_business_partner);
		bu.update();
	}
	
}(current, previous);

However, it still doesnt work. Its not even registering the log statement, so as you say, something must be amiss with the query

[Mark Roethof]

Can you simulate your query thru the list? Then right mouse click on the breadcrumb, copy query. How does the query look like? Hopefully something like:
u_hr_business_unit=8564af3adb810410d58ea345ca9619dd

Is the table name also correct? Maybe it comes with HR plugin I don't know, though maybe dl_u_hr_assignment?

Also, do you have conditions on your business rule? Maybe start your business rule for example with a dummy log statement, even before your GlideRecord query, just to see if the business rule is triggered at all.

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

Kind regards,
Mark

---

LinkedIn
Community article list