Change Request form in Review state

[NiKhil70]

Hi 

In Change Request form , state should not move to "Review" until the Field inside the Related Task for "Change-Tasks" is closed completed.

Thanks

NR.

[Omkar Mone]

Hi 

try the below business rule

Table: Change request

When: Before (insert and Update)

Script:

function onBefore(current, previous)

{

  var target = new GlideRecord('change_task');

  target.addQuery('change_request', current.sys_id);

  //search for open Change tasks - select the state from change task which you need to query

 // target.addQuery('state', 'your state');

  target.query();

  if(target.hasNext()){

// check if state of change request changes to Closed

  if ((current.state == 4)){

 //do your code here

  }

  }

}

This worked perfectly fine for me.

Mark Correct Answer or HelpFul

Warm Regards,

Omkar Mone

www.dxsherpa.com