MRV email Script returning SYS_ID from the reference fields

Peter Williams · ‎06-08-2023

Good Day everyone,

I created this email script to read the information from my MRV to be added to the email notification.

However, in my MRV i have three reference fields that when i submit the form will only display their sys_id.

How do i get to display their actual values on the email script.

here is the code i am using:

var record = new GlideRecord('sc_req_item');
var sysCurrentRecordSysId = current.sys_id;
record.addQuery('sys_id', sysCurrentRecordSysId);
record.query();
while (record.next()) {
var obj = JSON.parse(record.variables.bill_to_office_mrv);//mvr name
for (var k = 0; k < obj.length; k++) {

' + obj[k].office_office + ' - ' + obj[k].department_office.getDisplayValue() + ' //Office & Department field you see in the pic above

' + obj[k].gl_code_office + ' // gl code

}

i tried using the .getDisplayedValue() on the department and it comes back with undefined.

any help is appricated here

Mark Roethof · ‎06-08-2023

Oke no worries, I thought lets spend 5 minutes before bedtime 😅

I just modified the example slightly, works immediately on Catalog Item. You just need to replace the MRVS name and place the logic of your HTML table since I just used an example of building the description field.

var current = new GlideRecord('sc_req_item');
current.get('da8fa1bd479f29100692249bd36d43f5');

///

var description = [];
var mrvs = current.variables.mobile_devices_set;

var l = mrvs.getRowCount();
for(var i = 0; i < l; i++) {
    var row = mrvs.getRow(i);
    var cells = row.getCells();

    var m = cells.length;
    for(var j = 0; j < m; j++) {
        description.push(cells[j].getLabel() + ': ' + cells[j].getCellDisplayValue());
    }

    if(i < l) {
        description.push('');
    }
}

gs.info(description);

Kind regards,
Mark

Kind regards,

Mark Roethof

Independent ServiceNow Consultant

10x ServiceNow MVP

---

~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field

View solution in original post

DrewW · ‎06-08-2023

You have to lookup the records in the appropriate tables and get the records display value.

Peter Williams · ‎06-08-2023

office is referencing to the cmd_location table

department is referencing to the cmd_department table

Gl Code is referencing to a custom table called u_gl_code

Mark Roethof · ‎06-08-2023

Hi there,

https://www.servicenow.com/community/developer-articles/creating-records-or-a-summary-from-multi-row...

In this article I've used .getLabel() and .getCellDisplayValue(). Worked fine.