Workflow Approval User Via Script

[stevejarman]

I'm attempting to set up an approval using the "Advanced Additional Approvers Script". The script I'm using is shown below. u_capacity_managers is a User reference, and I can confirm that answer ends up being set to the sys_id of the correct user (I've printed it into a field to check via current.description = answer), BUT, the approval step just skips through as though no one is being set as the approver. Can anyone identify any problems with what I'm doing?

// Set the variable 'answer' to a comma-separated list of user ids and/or group ids or an array of user/group ids to add as approvers.
//
// For example:
//             answer = [];
//             answer.push('id1');
//             answer.push('id2');
var rs = new GlideRecord("u_provisioning_approvers");
rs.addQuery("u_company", current.opened_by.company);
rs.query();
while (rs.next())
{
       answer = String(rs.u_capacity_managers);
}

[samiul1]

Could you test your script in Background-Scripts and see if it's generating any result?

[samiul1]

Also, can you test this:

1. var answer = [];
3. var rs = new GlideRecord("u_provisioning_approvers");  
4. rs.addQuery("u_company", current.opened_by.company);  
5. rs.query();  
6.  
7. while (rs.next()) {  
8.       answer.push(rs.getValue('u_capacity_managers'));  
9. }  

[stevejarman]

I was trying to avoid that as my u_capacity_managers field already has the ability to either be a single sys_id or a comma separated list of sys_ids if there's more than one approver. I guess I could split that into an array, but that seems silly when I already have it in one of the formats expected. I'll try it though and see what happens.

[samiul1]

Did you manage to get any results using that method?