Using a background script to fill a field on all values of a table

[SC10]

With a background script, I am trying to query all of the records of my dmn_demand table, and fill in a field with matching data from another field already present on each record.

This is the code that I have tried and didn't have work. Thought I'd reach out to the community for some pointers on where I am going wrong:

var gr = new GlideRecord('dmn_demand');
gr.query();
while (gr.next()) {
gr.autoSysFields(false);
gr.u_task_for = gr.u_requestedfor;
gr.update();
}

Thank you

[Pradeep Sharma]

There might be a business rule which might be aborting the change. Please check for the same.

Let me know if you have any questions.