how to update state field of the records created 7 days ago weekly using scheduled script execution.here is my script ..
var ga= new GlideRecord('x_465600_elegant_i_elegant_requests');
ga.addQuery('active', 'true');
ga.addQuery('created','=',gs.daysAgo(7));
ga.query();
while (ga.next());
if (ga.getValue('state',1)){ // if its state is still open
ga.setValue('state',0); // update them to pending
ga.update();
when m executing the above script it is creating a new record for that record it is setting the state value 0(pending).but i need to update all the records open- to- pending state created 7 days ago...
