gr.update() not updating all records

[Anubhuti]

Hi All,

I am trying to update the work notes of multiple task records, but only one record is getting updated.

Below is the script I am using:

var gr = new GlideRecord('tablename');
gr.addQuery('parent',current.sys_id);
gr.addEncodedQuery('stateNOT IN3,7');
gr.query();
while(gr.next()) {
gr.work_notes = "comments";
gr.update();
}
}

When running it as background script, I am getting the below mentioned error and when I am removing gr.update() i am not getting any error:

Cannot find function getLocation in object com.glide.script.fencing.ScopedUser@@@@@@
Has anybody experienced similar issue?

[Aaron Munoz]

Try to replace this line

gr.work_notes = "comments";

with this one

gr.setValue('work_notes', "comments");

[Anubhuti]

Tried the same but still getting the error

[ChanakyaMekala]

It has to work, however try to replace the encoded query statement with addQuery('work_notes', 'NOT IN', '3,7') Please let me know whether it had worked or not

[Anubhuti]

This also doesn't work.

[Simon Christens]

You can also try:

gr['work_notes'].setJournalEntry('comments');

I just tested this and it works as supposed:

var tasks = [];

var task = new GlideRecord('incident');
task.setLimit(10);
task.query();
while(task.next()){

task['work_notes'].setJournalEntry('tester');
task.update();
  
  tasks.push(task.getDisplayValue());
  
}

gs.print(tasks.toString());