Fix Script

Shreshta_happy · ‎10-10-2023

They are two tables

1)case table

2)required task table

the case table number is linked to required task table as u_parent

I first want to check a field that is " tech upgrade" contains "add" which is on case table then if it is true

then i have to glide the required task table and check for a assigned group (resolve) and update the assigned group to remote.

Danish Bhairag2 · ‎10-10-2023

Can u try the below code please.

var caseNumber = 'INSERT_CASE_NUMBER_HERE'; // Specify the case number you want to target

var requiredTaskGr = new GlideRecord('required_task');

requiredTaskGr.addQuery('u_parent', caseNumber);

requiredTaskGr.addQuery('assigned_group', 'resolve');

requiredTaskGr.query();

var caseGr = new GlideRecord('case');

caseGr.addQuery('number', caseNumber);

caseGr.addQuery('tech_upgrade', 'CONTAINS', 'add');

caseGr.query();

if (caseGr.next()) {

while (requiredTaskGr.next()) {

requiredTaskGr.assigned_group = 'remote';

requiredTaskGr.update();

}

gs.info('Required Task records updated successfully for Case number: ' + caseNumber);

} else {

gs.info('No action performed. Tech upgrade does not contain "add" for Case number:

' + caseNumber);

}

Mark my answer helpful & accepted if it helps you resolve your issue.

Thanks,

Danish

Shreshta_happy · ‎10-10-2023

This script should be for multiple caseNumber.