How to set a previous value of a field through Scheduled jobs

[Mishu]

I am running a job to check for a state value that is on On Hold and the date given in a particular field matched todays date, then set the state field back to the previous value (i.e. state value which was before On Hold).

Please suggest.

[Mishu]

@Anil Lande - Could you please suggest

[Anil Lande · Accepted solution]

Hi,

A simple solution would be to create custom field 'Previous state' on your table and set the value of this field using BR on State change.

A BR would be:

When - Before Insert/Update (condition = state changes)

use below line in script part 

current.u_previous_state = previous.state;

This will track the previous state and you can use it in your scheduled job.

[Mishu]

@Anil Lande -- Ok, but we can't make it happen directly by scheduled job or flow designer to fetch the previous value?

[Anil Lande]

Hi,

All records in ServiceNow tables store the current value, previous values available in BR only for the specific transaction.