question Re: How to pass dynamic values to single run script based on if condition in ServiceNow AI Platform forum

How to pass dynamic values to single run script based on if condition

Renu9 — Thu, 08 Feb 2024 09:15:30 GMT

Hi All,

I am having multiple if conditions such as if Keyboard needed is selected as Yes, then in the run script , I want to consume a keyboard record and assign to requester.

If mouse needed is selected as Yes, then in the run script , I want to consume a mouse record and assign to requester.

If Webcam needed is selected as Yes, then in the run script , I want to consume a webcam record and assign to requester.

So, for the keyboard, the item name is Ergo Keyboard 123, for the mouse, the item name is Mouse CPA1

So, I am thinking to use a single run script but pass these values from if condition to run script. How it is possible.

var consUtil = new Consumables();

var gr = new GlideRecord('alm_consumable');

gr.addQuery('stockroom', 'Tech distribution center'); //Tech distribution center

gr.addQuery('display_name', 'Ergo Keyboard 123');

gr.addQuery('install_status', '6'); //in stock - state

gr.addQuery('substatus', 'available');

gr.query();

if (gr.next()) {

gs.log("stock is available " + gr.quantity);

workflow.scratchpad.consumable = consUtil.splitForeground('02f2114547083d94785b87d8536d43fc', 1, '10', '', '', '', '', current.request.requested_for);

}

else

{

task.state='2'; //work in progress

task.work_notes ='This task was closed without an item ';

}

This is for keyboard , how can I pass dynamically for all items. Please guide

Re: How to pass dynamic values to single run script based on if condition

Sayali Gurav — Thu, 08 Feb 2024 09:44:06 GMT

Hello @Renu9 ,

// Add your condition to check
if (condition) {
// Dynamic value when condition is true
var dynamicValue = "Dynamic Value 1";
} else {
// Dynamic value when condition is false
var dynamicValue = "Dynamic Value 2";
}

// Use the dynamicValue in your script
gs.info("Dynamic Value: " + dynamicValue);

Replace 'condition', "Dynamic Value 1", and "Dynamic Value 2" with your actual conditions and dynamic values.

If this will helps to resolve your issue then please mark helpful and accept as solution.

Thanks & Regards,

Sayali Gurav

Re: How to pass dynamic values to single run script based on if condition

Renu9 — Thu, 08 Feb 2024 15:29:37 GMT

Hi @Sayali Gurav

I need to put multiple if conditions in the workflow and all should point to same run script

Can you please let me know where we can give the condition and pass the dynamic values?

Re: How to pass dynamic values to single run script based on if condition

Harish KM — Thu, 08 Feb 2024 15:46:32 GMT

Hi @Renu9 in that case go for switch statement where you can have multiple dynamic values to pass to your run script.

Re: How to pass dynamic values to single run script based on if condition

Renu9 — Thu, 08 Feb 2024 15:56:53 GMT

Hi @Harish KM In this case, switch shows the choices for that variable.

But in my case. If keyboard is selected as 'Ergo Keyboard 123', then run script should execute.

If mouse is selected as 'Mouse CPA1', then run script should execute. As a sample below. I want to execute all if statements. How can it be acheived. Single run script but dynamic value should be passed each time.

Re: How to pass dynamic values to single run script based on if condition

Harish KM — Fri, 09 Feb 2024 00:58:07 GMT

HI @Renu9 switch statement will execute based on the choice selected, if you still want to use if, you can use. In your screen shot the 1st if statement, if keyboard is not selected then the "no" option should point to the next if statement. which you have left blank so in this case the if is not moving to next statement.

example

1st statment:

keyboard selected ? Yes --> run script

No --> point to next if statement

Re: How to pass dynamic values to single run script based on if condition

Renu9 — Fri, 09 Feb 2024 01:23:43 GMT

Hi @Harish KM

In this case i have to run all the if statements . Because the user can request for keyboard mouse webcam etc etc. so if i keep if else condition then if keyboard satisfied it is not going to mouse or webcam part. So if else wont work

in switch case can u help me with that. Because if i use switch block it is displaying the choices in that variable .

Re: How to pass dynamic values to single run script based on if condition

Harish KM — Fri, 09 Feb 2024 01:26:10 GMT

Hi @Renu9 switch also will execute either one. May I know your use case ? what needs to be done?

Re: How to pass dynamic values to single run script based on if condition

Renu9 — Fri, 09 Feb 2024 01:32:12 GMT

Hi @Harish KM

my use case is like when new user joined into the company he will be requesting for laptop keyboard mouse webcam all these items

so if he selects all these consumables then when the request is closed complete then quantity of 1 will be reduced from the consumable table

so there is a chance he selects all items right

so in this case if else is not working

Re: How to pass dynamic values to single run script based on if condition

Harish KM — Fri, 09 Feb 2024 02:10:42 GMT

Hi @Renu9 in this cases, instead of while/switch, create a run script and check all the variable value and store it in different scratchpad variables/activity result and in next run script you can check these

if (current.variables.var_name == 'value1') {
activity.result = 'value1';
} else if (current.variables.var_name == 'value2') {
activity.result = 'value2';
}
else if (current.variables.var_name == 'value2' && current.variables.var_name == 'value1') {
activity.result = 'value3';
}

Re: How to pass dynamic values to single run script based on if condition

Renu9 — Fri, 09 Feb 2024 02:59:06 GMT

Hi @Harish KM By mistakenly the previous post was accepted. But in the run script below even the logs are executing and the branches are not going to next run script. It is getting struck there itself.Can you please guide

Please find the screenshot

From the show workflow in RITM

Re: How to pass dynamic values to single run script based on if condition

Harish KM — Fri, 09 Feb 2024 03:20:18 GMT

Hi @Renu9 your run script should look like this, tested in PDI returns result, I have 2 checkbox variables here.

I selected both variables and output

Selected single variable

Output

Re: How to pass dynamic values to single run script based on if condition

Renu9 — Fri, 09 Feb 2024 05:15:18 GMT

Hi @Harish KM

Thanks for it, but I want to keep different dynamic values for keyboard and mouse separately. So, in this case first if statement will not work right. And I am having 6 variables like keyboard, mouse, webcam, monitor, desktop, etc.

There will be multiple combinations .

My use case is the user can request any one of the item in those 6 or all those 6 or few of them.

For each variable it is with different dynamic values.

Re: How to pass dynamic values to single run script based on if condition

Harish KM — Fri, 09 Feb 2024 10:55:12 GMT

Hi @Renu9 you can check the value of variable dynamically as well, what type of variables are you using? share more details on the variables so that i can help you with correct code

Re: How to pass dynamic values to single run script based on if condition

Renu9 — Fri, 09 Feb 2024 13:49:37 GMT

Hi @Harish KM

Below are the variables

1.What kind of keyboard is needed?

2.What kind of mouse is needed?

3.What kind of webcam is needed?

4.What kind of monitor is needed?

5.What kind of laptop is needed?

There are few choices in all these variables. The user can request any one of these , multiple or all based on his requirement.

When keyboard is selected then the corresponding keyboard type from the consumable table if the stock is available then it has to be assigned to the requested user. For this, there is a script include. Same way for mouse, webcam, laptop, monitor ,etc

If keyboard is selected then I want to fetch and store value for the keyboard consumable item in a variable. This value I have to pass it in run script. So, here if else wont work because the user can request multiple items.

For example, if user requests for keyboard, mouse and monitor and not webcam and laptop then one item for keyboard will be assigned to user and deducted from consumable table. Same way for mouse and monitor.