Updating the Records by using Background Script

Arun87 · ‎10-18-2021

Hi,

We have created a field called First assigned to incident table. Purpose of the field is to capture the first assignee of the ticket. We have created Business rule it is working for new records. We have to update the existing records. Kindly help me how to update the existing records.

Thanks in Advance !

Ankur Bawiskar · ‎10-18-2021

Hi,

example below

if table is audited then you can do this

You can do GlideRecord from following tables,

sys_history_set and sys_history_line

var incident = new GlideRecord('incident');
incident.addQuery('u_first_assigned',''); // give correct field name here
incident.query();

while(incident.next()){

    var history = new GlideRecord('sys_history_set');
    history.addQuery('id',incident.getValue('sys_id'));
    history.query();
    history.next();

    var auditH = new GlideRecord('sys_history_line');
    auditH.addQuery('set',history.getValue('sys_id'));
    auditH.addEncodedQuery("field=assigned_to^newISNOTEMPTY^oldISEMPTY"); // new is not epmty and old is empty
    auditH.query();
    if(auditH.next()){

        incident.u_first_assigned = auditH.new_value; // give correct field name here
        incident.update();

    }

}

If my response helped you please mark it correct to close the question so that it benefits future readers as well.

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Arun87 · ‎10-18-2021

Hi Ankur,

Do we need to have record in sys_history_line and sys_history_audit in both the tables for performing the above scripts. Please tell me know.

Ankur Bawiskar · ‎10-18-2021

Hi,

I already mentioned that if the table is audited then you can run that script I shared

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Arun87 · ‎10-18-2021

Hi Ankur,

Is there any alternate ways to update in the existing record.

Ankur Bawiskar · ‎10-18-2021

that is the only way

If my response helped you please mark it correct to close the question so that it benefits future readers as well.

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Community Alums · ‎10-18-2021

Use condition like - "First assigned" is empty and later put as value to this field the value of field sys_created_by. So in general your script should look similar to:

function fixEmptyFields(){

var incident_gr = new GlideRecord('incident');

incident_gr.addNullQuery('u_first_assigned');

incident_gr.query();

while(incident_gr .next()){

incident_gr.setValue('u_first_assigned', incident_gr.sys_created_by);

// Or if not working ok, try with next line

// incident_gr.setDisplayValue('u_first_assigned', incident_gr.sys_created_by);

incident_gr.update();

}

fixEmptyFields();