Business Rule script to populate the date/time on field incident table level.

LaraReddy · ‎11-06-2023

HI,

When we set the state to on hold and on hold reason field to any one option, then we want to populate the date/time on "On Release" field level.

During the process, when we change the on hold reason field to any other options without changing the state from on hold then we don't want to change the populated date/time.

And the populated the time should change only when we change the state from on hold.

We wrote the below business rule to run when state changes to on hold and it's working fine.

Now the requirement is we don't want to populate date/time when the "on hold reason" field option is either A or C.

Can anyone please help us to adjust the below script to skip the date/time.

(function executeRule(current, previous /*null when async*/ ) {
//functionality configurations
var tz = "America/New_York";
var hours = 48;
var rightNow = new GlideDateTime();
var dur = new GlideDuration(3600000 * hours);

var schedule = new GlideSchedule('021479371bdb99d04649c845604bcb58', tz);
var releaseDT = schedule.add(rightNow, dur);
current.u_hold_release = releaseDT;

})(current, previous);

Thanks,
LARA REDDY

ar1 · ‎11-09-2023

HI Lara,
Hope the below script helps you.

(function executeRule(current, previous /*null when async*/ ) {

//functionality configurations

var tz = "America/New_York";

var hours = 48;

var rightNow = new GlideDateTime();

var dur = new GlideDuration(3600000 * hours);

var popsTime = current.u_capture_time; // getting the pre populated data

// if the hold reason is problem or change , clearing the populated data

if ((current.hold_reason == '3' || current.hold_reason == '5') && (!previous.u_hold_release.nil())) {

gs.addErrorMessage('three');

current.u_hold_release = '';

}

// state is still on hold and on hold field changes to some other options then populating the existing date/time.

else if ((current.state == previous.state) && (current.hold_reason == '1' || current.hold_reason == '2' || current.hold_reason == '4') && (!current.u_capture_time.nil())) {

gs.addErrorMessage('one');

current.u_hold_release = popsTime;

}

// state is on hold and on hold is any one option we are setting the future date/time in on release field level.

else if ((current.state == '3') && (current.hold_reason == '1' || current.hold_reason == '2' || current.hold_reason == '4') && (current.u_capture_time.nil())) {

gs.addErrorMessage('two');

var schedule = new GlideSchedule('021479371bdb99d04649c845604bcb58', tz);

var releaseDT = schedule.add(rightNow, dur);

current.u_hold_release = releaseDT;

current.u_capture_time = releaseDT;

}

})(current, previous);

Thanks,
AR

View solution in original post

Anubhav24 · ‎11-06-2023

Hi @LaraReddy

Can you give a try to this requirement using a SLA , because once the SLA has triggered you can always get the start time from SLA.

Please mark helpful and correct if my response helped you.