Bulk update using fix script

[Community Alums]

Hi, how to bulk update using fix script i just want to try update the company field using dummy data from Microsoft company to Tesla company.

Thak you in Advance

[AnveshKumar M · Accepted solution]

Hi @Community Alums 

You can use updateMultiple() method on GlideRecord class. For example,

var gr = new GlideRecord("YOUR_TABLE_NAME");

gr.addEncodedQuery("Your_Query"); //if you want to update all records in table you can remove this line

gr.query();

gr.company = "Sys ID of your company record from core_company field"; //I assume your field is reference to core_company table.

gr.updateMultiple();

Please mark my answer helpful and accept as solution if it helped you 👍✅

[AnveshKumar M · Accepted solution]

Hi @Community Alums 

You can use updateMultiple() method on GlideRecord class. For example,

var gr = new GlideRecord("YOUR_TABLE_NAME");

gr.addEncodedQuery("Your_Query"); //if you want to update all records in table you can remove this line

gr.query();

gr.company = "Sys ID of your company record from core_company field"; //I assume your field is reference to core_company table.

gr.updateMultiple();

Please mark my answer helpful and accept as solution if it helped you 👍✅

[Community Alums]

Thank you!

[Danish Bhairag2 · Accepted solution]

Hi @Community Alums ,

You can try something like this

// Define a GlideRecord query to find records with the current company name "Microsoft"

var gr = new GlideRecord('your_table_name'); // Replace 'your_table_name' with the actual table name you want to update

gr.addQuery('company', 'Microsoft');

gr.query();

// Loop through the records and update the company name to "Tesla"

while (gr.next()) {

    gr.company = 'Tesla';

    gr.update();

}

gs.info('Bulk update completed. Records with company name "Microsoft" changed to

"Tesla".');

Thanks,

Danish

[Community Alums]

Thank you so much!