Scheduled jobs

[Phani Pasupulet]

     gs.addInfoMessage("kyaaa");

   var gr=new GlideRecord('x_1088615_final_de_donating');

    gr.addActiveQuery();

    gr.addEncodedQuery('u_choice_6=available');

    gr.query();

    gs.addInfoMessage("hii");

  var p=0;

  var d=0;

  var l=0;

  var m=0;

while(gr.next())

{

if(gr.u_reference_2.getDisplayValue()=="Dolo")

{

d=d+gr.u_integer_4;

gr.u_choice_6="Expired";

}

else if(gr.u_reference_2.getDisplayValue()=="Levotaz")

{

l=l+gr.u_integer_4;

gr.u_choice_6="Expired";

}

else if(gr.u_reference_2.getDisplayValue()=="Macpod")

{

m=m+gr.u_integer_4;

gr.u_choice_6="Expired";

}

else if(gr.u_reference_2.getDisplayValue()=="Paracetamol")

{

p=p+gr.u_integer_4;

gr.u_choice_6="Expired";

}

}

var gr_per=new GlideRecord('x_1088615_final_de_personal_database');

gr_per.addEncodedQuery('u_string_1ISNOTEMPTY');

gr_per.query();

while(gr_per.next())

{

if(gr_per.u_string_1=="Dolo")

{

gr_per.u_integer_2=gr_per.u_integer_2-d;

}

else if(gr_per.u_string_1=="Levotaz")

{

gr_per.u_integer_2=gr_per.u_integer_2-l;

}

else if(gr_per.u_string_1=="Macpod")

{

gr_per.u_integer_2=gr_per.u_integer_2-m;

}

  else if(gr_per.u_string_1=="Paracetamol")

  {

  gr_per.u_integer_2=gr_per.u_integer_2-p;

  }

}


Can any one tell me why it is not executing 

This is a scheduled job script that runs every day
when I click on excute now changes are not effecting 
even it is not showing the message added in first line 

[sushantmalsure · Accepted solution]

Hi @Phani Pasupulet 

Try following, I assume you have all correct values setting in script its just update() missing. 

So I have added it and try following code instead of earlier:

   gs.addInfoMessage("kyaaa");
 
   var gr=new GlideRecord('x_1088615_final_de_donating');
    gr.addActiveQuery();
    gr.addEncodedQuery('u_choice_6=available');
    gr.query();
    gs.addInfoMessage("hii");
  var p=0;
  var d=0;
  var l=0;
  var m=0;
 
while(gr.next())
{
if(gr.u_reference_2.getDisplayValue()=="Dolo")
{
d=d+gr.u_integer_4;
gr.u_choice_6="Expired";
}
else if(gr.u_reference_2.getDisplayValue()=="Levotaz")
{
l=l+gr.u_integer_4;
gr.u_choice_6="Expired";
}
else if(gr.u_reference_2.getDisplayValue()=="Macpod")
{
m=m+gr.u_integer_4;
gr.u_choice_6="Expired";
}
else if(gr.u_reference_2.getDisplayValue()=="Paracetamol")
{
p=p+gr.u_integer_4;
gr.u_choice_6="Expired";
}
gr.update();
}
 
 
var gr_per=new GlideRecord('x_1088615_final_de_personal_database');
 
gr_per.addEncodedQuery('u_string_1ISNOTEMPTY');
gr_per.query();
 
while(gr_per.next())
{
if(gr_per.u_string_1=="Dolo")
{
gr_per.u_integer_2=gr_per.u_integer_2-d;
}
else if(gr_per.u_string_1=="Levotaz")
{
gr_per.u_integer_2=gr_per.u_integer_2-l;
}
else if(gr_per.u_string_1=="Macpod")
{
gr_per.u_integer_2=gr_per.u_integer_2-m;
}
  else if(gr_per.u_string_1=="Paracetamol")
  {
  gr_per.u_integer_2=gr_per.u_integer_2-p;
  }
  gr_per.update();
}

[Phani Pasupulet]

Thank you so much Sir Helped alot