Fix Script

[Shreshta_happy]

They are some inflight tasks that I need to reassign to the other group.

i have written this fix script:

var techUpgrade= new GlideRecord('case table');

techUpgrade.addEncodedQuery('u_tech_upgrade_type=');

techUpgrade.query();

while (techUpgrade.next()) {

    gs.log("it is for non tu" + techUpgrade.number);

    var GroupUpdate = new GlideRecord('task table');

    GroupUpdate .addQuery('u_parent', techUpgrade.sys_id);

GroupUpdate .addQuery('u_type', 'task');

    GroupUpdate .addQuery('u_assigned_group', 'IN', 'f53cecacdbf8f5109aa69reerrwer');

    GroupUpdate .query();

    if (GroupUpdate .next()) {

        gs.log("checking for the second remtask + techUpgrade.number);

        GroupUpdate .seValue('u_assigned_group ', '6ebd91f387593510f484b806dabdfdf443');

        GroupUpdate .setWorkflow(false);

        GroupUpdate .update();

    }

}

The logs are getting executed but the group is not getting updated

Please help.

[Sandeep Rajput]

@Shreshta_happy 

Please update the line number 13 as follows.

GroupUpdate.setValue('u_assigned_group ', '6ebd91f387593510f484b806dabdfdf443');

You missed a t in setValue method.

The updated script should be.

var techUpgrade= new GlideRecord('case table');
techUpgrade.addEncodedQuery('u_tech_upgrade_type=');
techUpgrade.query();
while (techUpgrade.next()) {
    gs.log("it is for non tu" + techUpgrade.number);
    var GroupUpdate = new GlideRecord('task table');
    GroupUpdate.addQuery('u_parent', techUpgrade.sys_id);
    GroupUpdate.addQuery('u_type', 'task');
    GroupUpdate.addQuery('u_assigned_group', 'IN', 'f53cecacdbf8f5109aa69reerrwer');
    GroupUpdate.query();
    if (GroupUpdate.next()) {
        gs.log("checking for the second remtask + techUpgrade.number);
        GroupUpdate.setValue('u_assigned_group ', '6ebd91f387593510f484b806dabdfdf443');
        GroupUpdate.setWorkflow(false);
        GroupUpdate.update();
    }
}

[Shreshta_happy]

hey @Sandeep Rajput ,

Still not working. Can you please check

[Sandeep Rajput]

Here is slightly updated version. Should work now.

var techUpgrade= new GlideRecord('case table');
techUpgrade.addEncodedQuery('u_tech_upgrade_type=');
techUpgrade.query();
while (techUpgrade.next()) {
    gs.log("it is for non tu" + techUpgrade.number);
    var GroupUpdate = new GlideRecord('task table');
    GroupUpdate.addQuery('u_parent', techUpgrade.sys_id);
    GroupUpdate.addQuery('u_type', 'task');
    GroupUpdate.addQuery('u_assigned_group', 'IN', 'f53cecacdbf8f5109aa69reerrwer');
    GroupUpdate.query();
    if (GroupUpdate.next()) {
        gs.log("checking for the second remtask" + techUpgrade.number);
        GroupUpdate.setValue('u_assigned_group ', '6ebd91f387593510f484b806dabdfdf443');
        GroupUpdate.setWorkflow(false);
        GroupUpdate.update();
    }
}

[psphanindrakuma]

@Sandeep Rajput 

Still won;t update because sysid hase only 29 characters

GroupUpdate.addQuery('u_assigned_group', 'IN', 'f53cecacdbf8f5109aa69reerrwer');