- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-28-2021 09:48 PM
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
Regards,
Pushpa
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-29-2021 12:21 AM
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
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-28-2021 10:57 PM
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
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-28-2021 11:11 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-28-2021 11:20 PM
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
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-28-2021 10:52 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-28-2021 11:01 PM
Hi
below code is working but variable set values not getting
Add Stockroom Location and Projection: undefined