ServiceNow Things to Know 102: GlideMultipleUpdate

[PrashantLearnIT]

Hello Everyone,

While scrolling community to get an answer to my requirement, i found something useful worth sharing.
Have you ever heard of GlideMultipleUpdate ?

When you absolutely, positively have to change every record in the table, accept no substitutes.

var mu = new GlideMultipleUpdate(table_name);
mu.addQuery('field_name', value);
mu.setValue('field_name', value);
mu.execute();

This will update all records that follow the query set. It is very fast, does not touch any system fields (sys_updated_on, sys_updated_by, etc.) and does not run any business rules, so its usefulness is limited to just that. If you have to update 600k records, and you do not care that the system fields are not updated, use this.

If my content helped you in anyway, please mark this content as BOOKMARK, SUBSCRIBE & HELPFUL

Best Regards,

Prashant Kumar (LearnIT)

YouTube Channel LearnIT: https://www.youtube.com/@learnitwithprashant

Blog LearnIT: https://medium.com/@LearnITbyPrashant

Prashant Kumar LinkedIn: https://www.linkedin.com/in/learnitbyprashant/

ServiceNow Community Prashant Kumar - https://www.servicenow.com/community/user/viewprofilepage/user-id/19635