Adding journal notes to incidents via script

[Venjamin]

I have an ask to update 300+ records. While this is doable, the ask includes adding notes to the update, which is always a little trickier. I'm not sure how to dotwalk or access the attached activity list to update it.

var gr = new GlideRecord('incident')

gr.addEncodedQuery('major_incident_state=accepted^hold_reasonIN13,12,14,16^incident_state=6')
gr.query();

while(gr.next()) { 
gr.setWorkflow(false);
gr.setValue('work_notes', '"Bulk VP Review RCA cleanup: All VPs were provided a list of RCAs in their orgs, identified by their teams as "Ready for Review".  VPs were given two weeks to review, and either request additional review, or the RCAs would be closed. Closing this RCA in accordance with that effort. Any open tasks will be marked Closed/Skipped; the RCA Management task was completed, but for purposes of the update it will reflect Closed/Skipped too."');
gr.setValue('u_origin_of_incident', 'notapp');
gr.setValue('incident_state', '7');
gr.setValue('hold_reason', '9');
gr.update(); }

I tried this version, but of course I discovered I was using outdated dictionary references - work_notes doesn't exist on the incident table. 

Does anyone know how to add notes via a background script? I'm also trying to close any related incident tasks, which shouldn't be as difficult, I think, but this was the big one I wanted to knock out first.  

[Karan Chhabra6 · Accepted solution]

Hi @Venjamin 

setValue will not work on journal type fields,use gr['work_notes'] instead, so, your script should be:

var gr = new GlideRecord('incident')

gr.addEncodedQuery('major_incident_state=accepted^hold_reasonIN13,12,14,16^incident_state=6');
gr.query();

while(gr.next()) { 
gr.setWorkflow(false);
gr['work_notes'] = 'Bulk VP Review RCA cleanup: All VPs were provided a list of RCAs in their orgs, identified by their teams as "Ready for Review".  VPs were given two weeks to review, and either request additional review, or the RCAs would be closed. Closing this RCA in accordance with that effort. Any open tasks will be marked Closed/Skipped; the RCA Management task was completed, but for purposes of the update it will reflect Closed/Skipped too.';
gr.setValue('u_origin_of_incident', 'notapp');
gr.setValue('incident_state', '7');
gr.setValue('hold_reason', '9');
gr.update(); 
}

If my answer has helped with your question, please mark it as correct and helpful

Thanks,

Karan

[Venjamin]

That did it! Thank you very much, Karan. I've never seen the syntax for gr.[], so this is a great new learning experience.