Copy value field from one table to another table in Business Rule

[Diorella Angulo]

Hi,

I couldn't fine a solution for my requirement. I'm learning scripting.

I want to copy a value from Request [sc_request] table to Catalog Task [sc_task] table. It should happen when the field in the Request table is either updated or inserted.

I have the following in the When to run tab.

This is the script and obviously there is something wrong. I think it is in the gr.addQuery line? Can someone help me with that?

var a = current.work_start;

var gr = new GlideRecord('sc_task')

gr.addQuery('request',current.request)

gr.query();

gr.u_quote_approval_date = a;
gr.update();

[Community Alums]

Hi, 

You can do this to set when to run:




The table sc_request extends sc_task then you're working with fields of the same table. 

Since you're working on the same record, your script can be as simple as this:

Please mark my response as Correct or Helpful, if you find it appropriate. 

________________________

Carlos Camacho
https://www.linkedin.com/in/camachojunior

[Diorella Angulo]

Hi,

It did not work. Any ideas? 

[Ankur Bawiskar · Accepted solution]

Hi,

the BR should be after update on sc_request

Ensure you give correct condition so that the BR triggers

Update script as this

I hope work_start and u_quote_approval_date fields are of same type

var a = current.work_start;
var gr = new GlideRecord('sc_task');
gr.addQuery('request',current.getUniqueValue());
gr.query();
while(gr.next()){
	gr.u_quote_approval_date = a;
	gr.update();
}

Regards
Ankur

[Diorella Angulo]

Thank Ankur. I tried your script and worked fine. 

Yes, both fields are the same. 

What does the getUniqueValue(); do? Does it get the request number?

Here is the solution: