There is a update_recordset method built on the global Query object which can be used for quick updates in a single database trip of all the records that the query would retrieve without traversing through them. We can use it on the pre-built query or we can build it in our code. The only other thing that should be created is a map of strings that will map the field id that we need to update with the value to set.

____________________________________________________________________________

We hope that this blog post is helpful! If you are interested to join our team of Masters, check out our careers page, we have open positions for Microsoft Dynamics enthusiasts in every field.