Pulling Approvers from Affected CIs

[olivershields]

Hi,

I am trying to automate the change process to pull a list of approvers from all the affected CIs when the change state is set to 'Approval requested'.

I can get it working when i pull from a single Reference field on a CI but many items have multiple approvers required on them and when i try to pull it from a List field it does nothing at all.

Im using the below script which has been adapted from one i found here.

var answer = [];

var affCIs = new GlideRecord('task_ci');
affCIs.addQuery('task', current.sys_id);
affCIs.query();
while(affCIs.next()){
    answer.push(affCIs.ci_item.u_approver__person_); !
}

u_approver__person is the name of the list field im trying to pull from. If you can suggest a field that can serve this function better or correct the script to pull from the List correctly that would be great.

Thanks

[Kalaiarasan Pus]

Try this

var approvers = (current.u_approver__person.toString() + ',').split(',');

for(i=0;i<approvers.length;i++)

{

if(JSUtil.notNtil(approvers[i]))

{

    answer.push(approvers[i]));

}

}

[olivershields]

Ive tried putting this into the Approval - User bit of the workflow and it hasnt seemed to work.

[Kalaiarasan Pus]

try

{

var approvers = (current.u_approver__person.toString() + ',').split(',');

gs.log('Current Value-'+current.u_approver__person.toString());

gs.log('Approvers-'+approvers);

for(i=0;i<approvers.length;i++)

{

if(JSUtil.notNtil(approvers[i]))

{

answer.push(approvers[i]);

gs.log('Pushing the approvers-'+approvers[i]);

}

}

}

catch(err)

{

gs.log('Error While Processing-'+err);

}

[olivershields]

This is getting skipped due to Syntax errors:

WARNING at line 3: Expected a string and instead saw var.

ERROR at line 3: Expected ':' and instead saw 'approvers'.