gliderecord force update

Go to solution
brown9394
Tera Expert

‎06-05-2018 06:35 AM

Hello Experts, 

I'm trying the script below to force update ALL records so the calculated field values gets written in the database, so then I can filter/sort on the calculated fields to run proper reports. The problem I'm having with the background script below is that it keeps saying 'running transaction' for a long time before I end up clicking 'Cancel'. 

Any thoughts on how I can update the table to force update all the records to save the calculated values to the DB? 

 

var gr = new GlideRecord('change_request');

gr.query();

while (gr.next()) {

         gr.setForceUpdate(true);

         gr.autoSysFields(false);

         gr.setWorkflow(false);

         gr.update();

}

Thanks! 

  • 17,888 Views
1 ACCEPTED SOLUTION

Go to solution
Ankur Bawiskar
Tera Patron
Tera Patron
In response to brown9394

‎06-05-2018 06:54 AM

Hi Brown,

I would suggest you to use fix script since using this will allow you to check the status in background. This fix script can run in background and you can monitor that using Progress Workers under System Diagnostics.

https://docs.servicenow.com/bundle/kingston-application-development/page/build/applications/concept/c_FixScripts.html

Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.
Thanks
Ankur

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

View solution in original post

15 REPLIES 15

Go to solution
odijk
Giga Expert

‎06-29-2018 01:15 AM

I try to avoid using Calculated fields if the data is needed Server Side, especially because of the fact that they get recalculated, ad the user may thing the data is actually i the system. Where possible, I would recommend using Business Rules. Calculated fields are for display purposes only (even reporting on them will disappoint you)

0 Helpfuls