Creating a new Catalog Task using a Script?

[dianemiro]

Hi,

Basically, my requirement is to create a new Catalog Task if user commented on the RITM and no Open Catalog Tasks available. Here is my code:

function onBefore(current, previous) {

  var cmt = current.comments;

  var verifyTask = 0;

  var task = new GlideRecord("sc_task");

  task.addQuery("parent", "=", current.sys_id);

  task.addQuery("state", "<", 3);

  task.query();

  while (task.next()) {

  task.comments = cmt;

  verifyTask = 1;

  task.update();

  }

  if (verifyTask == 0){

  task.initialize();

  task.insert();

  task.request_item = current.sys_id;

  task.assignment_group.setDisplayValue('Service Desk');

  task.short_description = 'Verify approval';

  task.description = 'Check if Approver replied to RITM';

  task.comments = cmt;

  task.state = 1;

  verifyTask = 1;

  task.update();

  }

}

This code creates a new Catalog Task with State = Open. So this should not create another new Catalog Task anymore but it's creating one. What's wrong with my code?

[niv1]

Thats great

[Mihir Mohanta]

Please try the below script

function onBefore(current, previous) {

  var cmt = current.comments;

  var verifyTask = 0;

  var str = "parent="+current.sys_id+"^state<3";

  var task = new GlideRecord("sc_task");

  task.addEncodedQuery(str);

  task.query();

  while (task.next()) {

  task.comments = cmt;

  verifyTask = 1;

  task.update();

  }

  if (verifyTask == 0){

  task.initialize();

  task.request_item = current.sys_id;

  task.assignment_group.setDisplayValue('Service Desk');

  task.short_description = 'Verify approval';

  task.description = 'Check if Approver replied to RITM';

  task.comments = cmt;

  task.state = 1;

  verifyTask = 1;

  task.insert();

  }

}

[dianemiro]

Hi Mihir,

Not working too It creates another task.

[Sharique Azim]

Hi Diane,

Please note .update() function forces other business rule to work on the form when using onBefore, can you just remove it. the code is fine.

  var cmt = current.comments;

  var verifyTask = 0;

// var str = "parent="+current.sys_id+"^state<3";

  var task = new GlideRecord("sc_task");

  task.addQuery('request_item',current.sys_id.toString()); // changed a bit

task.addQuery('state','<','3');

  task.query();

  while (task.next()) {

  task.comments = cmt;

  verifyTask = 1;

//   task.update();   // comment this

  }

  if (verifyTask == 0){

  task.initialize();

  task.request_item = current.sys_id;

  task.assignment_group.setDisplayValue('Service Desk');

  task.short_description = 'Verify approval';

  task.description = 'Check if Approver replied to RITM';

  task.comments = cmt;

  task.state = 1;

  verifyTask = 1;

  task.insert();

  }