I am attempting to write a client script to cover all artifacts in the task table.
Upon change to state to any of the closed states (I believe out of the box they are 3, 4, 7, 8, 5, 6, 106, 107, 157), have the script check the parent to the child and list records with states that open. If there are more than zero do nothing, if less than zero then close the parent.
Is this possible? I was hoping to modify this script that I found from https://community.servicenow.com/community?id=community_question&sys_id=24848d6cdb77cc942be0a851ca961918.
(function executeRule(current, previous /*null when async*/ ) {
// Add your code here
var wo = new GlideRecord("u_navision_sales_order");
wo.addQuery("u_request_item", current.u_request_item);
wo.addQuery("u_status", '!=', <<status value>>); //replace with completed value
wo.orderBy('sys_created_on');
wo.query();
if (wo.next()) {
//Don't close the parent record as one of the child is not completed .
gs.addInfoMessage('Parent can't be closed because one of the child is in Open');
}
else
{
var req = new GlideRecord("sc_req_item");
req.addQuery("number", current.u_request_item);
req.addQuery('state', 'IN', '1 , 2');
req.query();
if (req.next()) {
req.state = '3';
req.update();
}
}
})(current, previous);
I'm thinking something like this might work?
(function executeRule(current, previous /*null when async*/ ) {
// Add your code here
var wo = new GlideRecord("task");
wo.addQuery("task", current.task);
wo.addQuery("state", '!=', '3 , 4 , 7 , 8 , 5 , 6 , 106 , 107 , 157'); //replace with completed value
wo.orderBy('sys_created_on');
wo.query();
if (wo.next()) {
//Don't close the parent record as one of the child is not completed .
gs.addInfoMessage('Parent cannot be closed because one of the child is in Open');
}
else
{
var req = new GlideRecord("task");
req.addQuery("number", current.task);
req.addQuery('state', 'IN', '1 , 2 , -5 , -4 , -3 , -2 , -1 , 0 , 101 , 102 , 103 , 104 , 151 , 152 , 154 , 9');
req.query();
if (req.next()) {
req.state = '3';
req.update();
}
}
})(current, previous);
