Need to update Incident field based on sla business percentage

[Bijender]

Hi,
I need to update incident field when incident resolves check the SLA business percentage , if less than 100% update the field with yes else no.

Tried creating a before update business rule on incident table  but not working

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

    var slaGR = new GlideRecord('task_sla');

    slaGR.addQuery('task', current.sys_id); 

    slaGR.addQuery('sla.name', 'P3 resolution'); // Match SLA name

    slaGR.query();

    if (slaGR.next()) {

           if (slaGR.business_percentage < 100) {

            current.u_sla_cal = 'Yes';

        } else {

            current.u_sla_cal = 'No';

        }  

    }

})(current, previous);

Regards,
B

[Shree_G]

@Bijender ,

Use below format to set value :

current.setValue('u_sla_cal','Yes');

current.update();

[Bijender]

no still not working,  tried to log the SLA name to see if its picking up the sla, but the logs shows undefined

[Shree_G]

Hello @Bijender ,

The script is working fine. Check the business rule conditions. try setting up when "State" changes to Resolve.

Tried in the Background scripts and working fine.

Output

[J Siva]

Hi @Bijender 

Try the below script.

(function executeRule(current, previous /*null when async*/ ) {
    var slaGR = new GlideRecord('task_sla');
    slaGR.addQuery('task', current.sys_id);
    slaGR.addEncodedQuery('business_percentage<100^sla.name=P3 resolution'); // CHANGE THE SLA NAME AS REQUIRED
    slaGR.query();
    if (slaGR.next()) {
        current.u_sla_cal = 'Yes';
    } else {
        current.u_sla_cal = 'No';
    }

})(current, previous);

Regards,
Siva