email script not running in background script

sinu2
Tera Expert

Hi 

 

I am trying to print below email in background script but it is showing function is not defined

var gr = new GlideRecord('sc_req_item');
gr.addQuery('sys_id','71735a911b300a108caa64e1604bcb68');
gr.query();
if (gr.next()) {
var mrvs_data_group = '';
var mrvs_group = gr.variables.group_move_mrvs; //replace with the internal name of your MRVS
var rowCount = mrvs_group.getRowCount();
for (var i = 0; i < rowCount; i++) {
    var row_group = mrvs_group.getRow(i);
    mrvs_data_group += '\n----------' + '\n' +
        'User: ' + getName('sys_user', row_group.user) + '\n' +
        'To Home Base: ' + getName('x_nuvo_eam_space', row_group.to_home_base_bulk) + '\n' +
        'To Floor: ' + getName('x_nuvo_eam_space', row_group.to_floor_bulk) + '\n' +
        'To Space: ' + getName('x_nuvo_eam_space', row_group.to_space_bulk) + '\n' +
        'Date: ' + row_group.employee_requested_move_date + '\n' +
        'From Home Base: ' + getName('x_nuvo_eam_space', row_group.from_home_base) + '\n' +
        'From Floor: ' + getName('x_nuvo_eam_space', row_group.from_floor) + '\n' +
        'From Space: ' + getName1('x_nuvo_eam_space', row_group.from_space) + '\n';
 
}
function getName(table, sys_id) {
    var grName = new GlideRecord(table);
    if (grName.get(sys_id)) {
        return grName.name.toString();
    }
    else{
        return 'Not selected';
    }
gs.print('Move Participants: ' + mrvs_data_group);
}
 


}
1 REPLY 1

Shruti
Mega Sage
Mega Sage
var gr = new GlideRecord('sc_req_item');
gr.addQuery('sys_id', '71735a911b300a108caa64e1604bcb68');
gr.query();
if (gr.next()) {
    var mrvs_data_group = '';
    var mrvs_group = gr.variables.group_move_mrvs; //replace with the internal name of your MRVS
    var rowCount = mrvs_group.getRowCount();
    for (var i = 0; i < rowCount; i++) {
        var row_group = mrvs_group.getRow(i);
        mrvs_data_group += '\n----------' + '\n' +
            'User: ' + getName('sys_user', row_group.user) + '\n' +
            'To Home Base: ' + getName('x_nuvo_eam_space', row_group.to_home_base_bulk) + '\n' +
            'To Floor: ' + getName('x_nuvo_eam_space', row_group.to_floor_bulk) + '\n' +
            'To Space: ' + getName('x_nuvo_eam_space', row_group.to_space_bulk) + '\n' +
            'Date: ' + row_group.employee_requested_move_date + '\n' +
            'From Home Base: ' + getName('x_nuvo_eam_space', row_group.from_home_base) + '\n' +
            'From Floor: ' + getName('x_nuvo_eam_space', row_group.from_floor) + '\n' +
            'From Space: ' + getName1('x_nuvo_eam_space', row_group.from_space) + '\n';

    }
}

function getName(table, sys_id) {
    var grName = new GlideRecord(table);
    if (grName.get(sys_id)) {
        return grName.name.toString();
    } else {
        return 'Not selected';
    }
}
gs.print('Move Participants: ' + mrvs_data_group);