question Re: Script for setting approval from catalog item variable on REQ in ServiceNow AI Platform forum

Script for setting approval from catalog item variable on REQ

Kifrez — Fri, 04 Mar 2022 07:10:14 GMT

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.

Re: Script for setting approval from catalog item variable on REQ

Monika13 — Fri, 04 Mar 2022 07:59:30 GMT

In workflow approval activity, you can write something like this:

var manager=current.variables.manager;
answer=manager;

Re: Script for setting approval from catalog item variable on REQ

Shikha puri — Fri, 04 Mar 2022 08:07:40 GMT

Use the below code under workflow approval activity.

answer = [];

answer.push(current.variables.variable-name.sys_id);

where variable name is backend value of variable like If i created Manager Variable so I use backend name of variable manager then the code will be :

answer = [];

answer.push(current.variables.manager.sys_id);

Re: Script for setting approval from catalog item variable on REQ

Murthy Ch — Fri, 04 Mar 2022 08:13:46 GMT

@Freddy

Create Approval User activity and try below code in advanced script:

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

Hope it helps

Thanks

Murthy

Re: Script for setting approval from catalog item variable on REQ

Kifrez — Tue, 08 Mar 2022 06:35:37 GMT

hi Monika, this doesn't seem to work. Do you have another idea?

Re: Script for setting approval from catalog item variable on REQ

Kifrez — Tue, 08 Mar 2022 06:35:51 GMT

Hi Shikha, this doesn't seem to work. Do you have another idea?

Re: Script for setting approval from catalog item variable on REQ

Kifrez — Tue, 08 Mar 2022 06:36:11 GMT

Hi Murthy, , this doesn't seem to work. Do you have another idea?

Re: Script for setting approval from catalog item variable on REQ

Voona Rohila — Tue, 08 Mar 2022 06:40:32 GMT

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?

Re: Script for setting approval from catalog item variable on REQ

Murthy Ch — Tue, 08 Mar 2022 06:41:37 GMT

Hi Freddy,

Can you share the scrrenshot?

Thanks

Re: Script for setting approval from catalog item variable on REQ

Kifrez — Tue, 08 Mar 2022 06:47:35 GMT

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());

Re: Script for setting approval from catalog item variable on REQ

Murthy Ch — Tue, 08 Mar 2022 06:50:29 GMT

Hi,

Please replace with gr with current

Re: Script for setting approval from catalog item variable on REQ

Voona Rohila — Tue, 08 Mar 2022 06:53:15 GMT

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

Re: Script for setting approval from catalog item variable on REQ

Kifrez — Tue, 08 Mar 2022 06:58:52 GMT

Hi Murthy,

thanks for the response.

Variable name on order guide is manager

this variable = manager is part of a variable set.

I just changed to gr.variables.manager.toString() or current.variables.manager.toString()

Both don't work.

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

Re: Script for setting approval from catalog item variable on REQ

Ankur Bawiskar — Tue, 08 Mar 2022 07:11:15 GMT

Hi,

I assume your workflow is on RITM table

then this should work fine

Did you add logs what came in manager variable?

answer = [];

answer.push(current.variables.manager.toString());

Regards
Ankur

Re: Script for setting approval from catalog item variable on REQ

Kifrez — Tue, 08 Mar 2022 07:11:24 GMT

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

Re: Script for setting approval from catalog item variable on REQ

Voona Rohila — Tue, 08 Mar 2022 07:15:31 GMT

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());

Re: Script for setting approval from catalog item variable on REQ

Kifrez — Tue, 08 Mar 2022 07:17:14 GMT

Hi @Ankur Bawiskar ,

No, this is on sc_request

This is a follow up after the If statement.

No , I did not.

variable name is manager and part of variable set = user_profile_set

manager is reference to sys_user table

I tried below but doesn't work

answer.push(current.variables.manager.toString());
OR
answer.push(gr.variables.manager.toString());
OR
answer.push(gr.variables.manager.getValue());

Re: Script for setting approval from catalog item variable on REQ

Voona Rohila — Tue, 08 Mar 2022 07:22:11 GMT

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");

Re: Script for setting approval from catalog item variable on REQ

Ankur Bawiskar — Tue, 08 Mar 2022 07:23:17 GMT

then query RITM

answer = [];
var gr = new GlideRecord("sc_req_item");
gr.addQuery("request", current.request);
gr.query();
if (gr.next()) {
	answer.push(gr.variables.manager.toString());
}

Regards
Ankur

Re: Script for setting approval from catalog item variable on REQ

Kifrez — Tue, 08 Mar 2022 23:24:04 GMT

Hi @Rohila Voona thanks that works with cat item sys id !! 🙂