updating a field by scheduled job
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-22-2016 07:20 AM
Hi All
I wrote a scheduled job to update a field. It showed that the count is 15400. But it didnot update around 600 records. When i filter the records i frontend, it shows 15400. How come count is showing correct in log but 600 records didnot get updated.
I again re-run the scheduled job and it said it updated 600. But when i saw those records didnot show any updation of that field.
What could be the possible cause?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-22-2016 12:38 PM
function Check(){
var gr = new GlideRecord('cmdb_ci');
gr.addEncodedQuery("install_status=1^ORsys_updated_on<javascript:gs.dateGenerate('2014-08-01','00:00:00')");
gr.query();
while(gr.next())
{
gr.u_date = 'Retire'; //u_date is a string field
gr.update();
}
gs.log("Executed "+ gr.getRowCount()+ " records.");
}
Check();

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-22-2016 12:39 PM
use gr.setWorkflow(false); before gr.update() line. I have mentioned it in my previous response.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-22-2016 12:46 PM
that also I did try but the same thing.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-22-2016 12:56 PM
Then I really don't know what to say at this point
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-22-2016 12:57 PM