- 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 11:03 PM
Hi Pushpa,
update your script as this
var desc = current.variables.description;
if (current.cat_item.name == "Laptop Projection Request") {
desc += '\nAccount: ' + current.variables.account.getDispayValue();
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("stockroom table"); // give here the table name
gr.addQuery("sys_id", parser[i].stockroom);
gr.query();
if (gr.next()) {
var str = '';
str = str + "Stockroom: " + gr.getDisplayValue() + " 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 11:22 PM
Hi Ankur,
Thanks for your reply
now account getting undefined.
and same update it into Task (now only populate catalog description value into task description) how to get all ritm description into task
Regards,
Pushpa
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-28-2021 11:27 PM
Hi,
account variable line of code was not touched.
you are still using getDisplayValue() on the account variable
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:32 PM
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.getDisplayValue() + " Projection: " + parser[i].projection;
arr.push(str);
}
}
desc += '\nAdd Stockroom Location and Projection: ' + arr.join('\n');
current.description = desc;
current.update();
}
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-28-2021 11:41 PM
Hi,
is the stockroom related information coming fine?
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader