Development of Fix Script to change incidents

[lucasjt]

Hey guys!

I need a Fix Script to change the name of the Channel field (contact_type) for 365 incidents:

Basically I need to replace "ChatBot" with "Chatbot".

Thanks!

[Stefan Georgiev]

Hello @lucasjt ,

you can you this code:

var incidentGR = new GlideRecord('incident')
incidentGR.addQuery('contact_type', 'ChatBot') // check if this query returns the 365 records or build the right query to get only the records you want to update

incidentGR.query()

while(incidentGR.next()){

incidentGR.contact_type = "Chatbot";
incidentGR.update()
}

[jonsan09]

You can try the below:

var updateINC = new GlideRecord('incident');
updateINC.addEncodedQuery('contact_type=INSERT BAD CONTACT TYPE');
//updateINC.setLimit(); //Use to limit number of records to update at a time, if a large number of reocrds are to be updated then there might be a performance impact.
updateINC.query();
while (updateINC.next()) {
    updateINC.contact_type = 'GOOD CONTACT TYPE';
    //Prevent BRs/Flows/Workflows from Triggering
    updateINC.setWorkflow(false);
    //Prevent updated by and updated fields from changing
    updateINC.autoSysFields(false);
    updateINC.update();

}

[BalaG]

Hi @LucasJ  using batch update instead of a while loop would be more efficient. Update mutiple will update all records just like the while loop. You should still set  workflow and sysfields to false.

see --

https://docs.servicenow.com/bundle/vancouver-api-reference/page/app-store/dev_portal/API_reference/g...

Hope that helped

--

Bala