Hello,
I have a scenario i.e. there is a Custom Parent table and Task table. when any Parent Record created under that 4 tasks are creating itself. So whenever
1. if at least one task went to 'Closed Complete' state(i.e. 1 task= Closed Complete, 3 tasks= Closed Skipped) Parent record should set to 'Closed Complete' or
2. if all Tasks(4) states are 'Canceled' (4 tasks = Closed Skipped) Parent Record state should set to 'Closed Skipped'.
I am using below After Business rule, It is working properly for 2nd Scenario but not working for 1st one.
Can anyone help me on this. Thanks in advance!😊
Please see the below code and screen shots for your reference.
(function executeRule(current, previous /*null when async*/ ) {
var count = 0;
var count1 = 0;
var count2 = 0;
var tasks = new GlideRecord('x_1309288_hr_new_0_hr_task');
tasks.addQuery('parent', current.parent);
tasks.query();
var taskcount = tasks.getRowCount();
while (tasks.next()) {
if (tasks.state == 3 ) //change as required
{
count++;
}
else if (tasks.state == 7 ) //change as required
{
count1++;
}
else if (tasks.active == false){
count2++;
}
}
if (count >= 0 && count2 == taskcount ) {
var req = new GlideRecord('x_1309288_hr_new_0_hr_onboarding_request');
req.addQuery('sys_id', current.parent);
req.query();
if (req.next()) {
req.state = 3;
req.update();
}
}
else if (count1 == taskcount) {
var req1 = new GlideRecord('x_1309288_hr_new_0_hr_onboarding_request');
req1.addQuery('sys_id', current.parent);
req1.query();
if (req1.next()) {
req1.state = 7;
req1.update();
}
}
})(current, previous);
2 ACCEPTED SOLUTIONS
