Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

email script not running in background script

sinu2
Tera Expert

‎03-07-2024 02:35 AM

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);
}
 


}
0 Helpfuls
  • 336 Views
1 REPLY 1

Shruti
Mega Sage
Mega Sage

‎03-07-2024 02:55 AM

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);
0 Helpfuls