how to populate the catalog variable values to RITM description

Pushpa
Mega Expert

Hi Team,

how to populate the current catalog variable values  to RITM description

below variables and variable set fields.

i have 3 variables and one variable set (variable set have 2 fields).

variables 

1. account

2. year

3.quarter 

variable set

4. select location  (location and balance)

how write workflow run script 

 

@Ankur Bawiskar 

 

Regards,

Pushpa

 

1 ACCEPTED SOLUTION

Hi,

account variable should work fine using this

current.variables.account.getDisplayValue();

OR you can query the account table with the sys_id and print the name

then for stockroom showing country do this

var desc = current.variables.description;

if (current.cat_item.name == "Laptop Projection Request") {
    desc += '\nAccount: ' + current.variables.account.getDisplayValue();
    desc += '\nYear: ' + current.variables.year;
    desc += '\nQuarter: ' + current.variables.quarter;

    var parser = JSON.parse(current.variables.add_stockroom_location_and_projection);
    var arr = [];

    for(var i=0;i<parser.length;i++){
        var gr = new GlideRecord("alm_stockroom"); // give here the table name
        gr.addQuery("sys_id", parser[i].stockroom);
        gr.query();
        if (gr.next()) {
            var str = '';
            str = str + "Stockroom: " + gr.location.country + " | " + gr.name + " Projection: " + parser[i].projection;
            arr.push(str);
        }
    }

    desc += '\nAdd Stockroom Location and Projection: ' + arr.join('\n');
    current.description = desc;
    current.update();
}

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

25 REPLIES 25

Hi,

your variable add_stockroom_location_and_projection seems to be MRVS so you need to query everytime to that stockroom table to get the display value

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hi Ankur,

 

below code working only variable vales getting. but variable set getting undefine.

var desc = current.variables.description;


//desc+='\nCost:'+current.cat_item.price.getDisplayValue()+' per month';

if (current.cat_item.name == "Laptop Projection Request") {
    desc += '\nAccount: ' + current.variables.account.getDisplayValue();
    desc += '\nYear: ' + current.variables.year.getDisplayValue();
    desc += '\nQuarter: ' + current.variables.quarter.getDisplayValue();
    desc += '\nAdd Stockroom Location and Projection: ' + current.variables.add_stockroom_location_and_projection.getDisplayValue();
}


current.description = desc;
current.update();

 

output:

test
Account: project1
Year: 2021
Quarter: Q2
Add Stockroom Location and Projection: undefined

 

thanks,

Pushpa

Hi Pushpa,

your variable set add_stockroom_location_and_projection is MRVS so it has JSON

So it won't work directly.

I have already shared the working script in my below post. please check that and use that

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

asifnoor
Kilo Patron

Hi,

Try like this.

var desc = current.variables.description;


//desc+='\nCost:'+current.cat_item.price.getDisplayValue()+' per month';

if (current.cat_item.name == "Laptop Projection Request") {
    desc += '\nAccount: ' + current.variables.account.getDisplayValue();
    desc += '\nYear: ' + current.variables.year.getDisplayValue();
    desc += '\nQuarter: ' + current.variables.quarter.getDisplayValue();
    desc += '\nAdd Stockroom Location and Projection: ' + current.variables.add_stockroom_location_and_projection.getDisplayValue();
}


current.description = desc;
current.update();

Mark the comment as a correct answer and helpful if this helps.

Hi 

below code is working but variable set values not getting 

 

Add Stockroom Location and Projection: undefined