Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to capture the SLA breach date for running on incident form

Go to solution
Atik
Tera Contributor

‎02-15-2024 02:02 AM

Hi, 

I am working on the Incident management where I have to capture the value of breach time(planned end date) field value,

I am trying with the below code with INC sys_id in background script it is giving the expected result but when using the same code in my Business Rule which is running on the Incident table where I have to capture the value of that field and have to hit other API for integration it is not giving the expected result...

 

var gr = GlideRecord('task_sla');
gr.addEncodedQuery('stage=in_progress^sla.target=resolution');
gr.addQuery('task','f2020ead1bd1f9101bc76280604bcb89');
gr.query();
if(gr.next()){
//obj_custom_field = gr.planned_end_time
gs.print(gr.planned_end_time);
}

 

Please help me with this...

 

 

 

Thanks in advance,

Atik

0 Helpfuls
  • 892 Views
1 ACCEPTED SOLUTION

Go to solution
kps sumanth
Mega Guru

‎02-15-2024 02:53 AM - edited ‎02-15-2024 02:56 AM

Hello @Atik ,

I have created a before insert and update business rule to retrieve the same and its returning the expected result, below is the screenshot.

kps2_0-1707994334433.png

 

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

	var grContract = new GlideRecord('contract_sla');
    var gr = GlideRecord('task_sla');
    gr.addQuery('task', current.sys_id);
    gr.addEncodedQuery('stage=in_progress^sla.target=resolution');
    //gr.addQuery('stage', 'in_progress');
    gr.query();
    if (gr.next()) {
        //obj_custom_field = gr.planned_end_time
        gs.log('BreachDateQuery ' + gr.planned_end_time.getDisplayValue());
    }

})(current, previous);

 

Could you please let me know the exact scenario when you need this value, so that I can help you with the script.

View solution in original post

7 REPLIES 7

Go to solution
kps sumanth
Mega Guru

‎02-15-2024 02:10 AM

Hello @Atik ,

 

Could be able to share the code you have written in business rule..?

0 Helpfuls

Go to solution
Atik
Tera Contributor
In response to kps sumanth

‎02-15-2024 02:19 AM - edited ‎02-15-2024 02:21 AM

Hi @kps sumanth ,

below is the code which I had added in my business rule,

 

 var gr = GlideRecord('task_sla');
    gr.addQuery('task', current.sys_id);
    gr.addEncodedQuery('stage=in_progress^grContract.target=resolution');
    //gr.addQuery('stage', 'in_progress');
    gr.query();
    if (gr.next()) {
        //obj_custom_field = gr.planned_end_time
        gs.log('BreachDateQuery ' + gr.planned_end_time.getDisplayValue());
 
Actually, I wanted to capture the Resolution one only not the response one..
0 Helpfuls

Go to solution
kps sumanth
Mega Guru

‎02-15-2024 02:33 AM

Hello @Atik ,

 

In line 3 the encoded query is having "grContract.target=resolution", I believe this is coming from sla definition and it should be sla.target=resolution.

 

Could you please let me know the use of this variable in your script "grContract".

0 Helpfuls

Go to solution
Atik
Tera Contributor
In response to kps sumanth

‎02-15-2024 02:38 AM

 //Breach Date
    var grContract = new GlideRecord('contract_sla');
    var gr = GlideRecord('task_sla');
    gr.addQuery('task', current.sys_id);
    gr.addEncodedQuery('stage=in_progress^sla.target=resolution');
    //gr.addQuery('stage', 'in_progress');
    gr.query();
    if (gr.next()) {
        //obj_custom_field = gr.planned_end_time
        gs.log('BreachDateQuery ' + gr.planned_end_time.getDisplayValue());
    }
actually i got this from community itself I was using this code, In earlier reply i forgot to add first line.. Please suggest me the correct code.
 
Thank,
Atik.
0 Helpfuls