how to populate the catalog variable values to RITM description

[Pushpa]

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

[Pushpa]

Hi Ankur,

 account field type is reference.

Stock room field type "Lockup Select Box"

please find below images

[Ankur Bawiskar · 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

[Pushpa]

Thanks ankur for your help. working fine now.

Regards,

Pushpa

[Ankur Bawiskar]

Glad to help.

Please mark response helpful as well.

[Pushpa]

Hi Ankur,

task description not getting all data getting (only catalog variable description value getting)

Regards,

Pushpa