Script for setting approval from catalog item variable on REQ

Kifrez · ‎03-03-2022

Hi everyone,

How do you set approval in workflow?

I would like to set the approver to be from variable?
the catalog item variable is manager and value will be from manager field.

Thanks in advanced.

Voona Rohila · ‎03-07-2022

If this workflow is on request then you should query the RITM details and use them

somethink like this.

var answer=[];
var grScReqItem = new GlideRecord('sc_req_item');
grScReqItem.addEncodedQuery("request="+current.sys_id+"^cat_item=1391a4db070630100b36f6fd7c1ed0c2");//map you catalog item sysid here.
grScReqItem.query();
if (grScReqItem.next()) {

answer.push(grScReqItem.variables.manager.toString());
}

for below line you should modify the highlated part with the catalog item sysid you want to fetch manager details from.

grScReqItem.addEncodedQuery("request="+current.sys_id+"^cat_item=1391a4db070630100b36f6fd7c1ed0c2");

View solution in original post

Voona Rohila · ‎03-07-2022

HI Freddy

are you using proper variable name ?

You should use below coode in 'Approval - user' activity.

answer=[];
answer.push(current.variables.u_manager.toString()); //give your manager variable name

Can you also check if manager details are filled or not?

Kifrez · ‎03-07-2022

Hi Rohila,

Yes, the variable name is manager and is part of variable set called user_profile_set

answer = [];
answer.push(gr.variables.manager.toString());

Voona Rohila · ‎03-07-2022

Hi freddy

there is a mistake in your code,You cannot use gr as it is not defined.

use current to access the details of current record.

code:

answer=[];
answer.push(current.variables.manager.toString()); //give your manager variable name

Kifrez · ‎03-07-2022

Hi Rohila,

Thanks for your responses.

I've changed it to current.variables.manager.toString()

answer=[];
answer.push(current.variables.manager.toString());

Still doesn't work.

So far it only works, if I add a user , it works

Voona Rohila · ‎03-07-2022

Hi

Manager is a refernce field right? can you keep logs and verify manager value.

you can also try this, both will work

answer=[];
answer.push(current.variable_pool.manager.toString());