I want to print a table in notification that contains list of tickets raised by a user.

abhaysingh98 · ‎01-09-2025

Hello All,

I want to print a table in a notification that will be sent every month to submitted by user and that notification includes list of tickets that are raised by the user. I have created a mail script that is used to fetch the details of tickets I am able to get the ticket number and it state in table format but now I want that number to be a type of link and the list will sort in ascending or descending order based on ticket created date.

(function runMailScript( /* GlideRecord */ current, /* TemplatePrinter */ template,

/* Optional EmailOutbound */

email, /* Optional GlideRecord */ email_action,

/* Optional GlideRecord */

event) {

// Add your code here

var arr = [];

var gr = new GlideRecord('incident');

gr.addEncodedQuery('active=true^stateIN1,2^activity_leaderDYNAMIC90d1921e5f510100a9ad2572f2b477fe');

gr.query();

while (gr.next()) {

arr.push(gr.number.toString());

}

var rows='';

for (var i = 0; i < arr.length; i++) {

var sr = new GlideRecord('incident');

sr.addQuery('number', arr[i]);

sr.query();

while (sr.next()) {

rows += '<tr>';

rows += '<td>' + sr.number + '</td>';

rows += '<td>' + sr.getDisplayValue('state') + '</td>';

rows += '</tr>';

}

var data='';

data = '<table style="border-collapse: collapse;" border="1" cellpadding="5"><tbody>';

data += '<tr><th>Name</th><th>state</th></tr>';

data += rows;

data += '</tbody></table>';

template.print(data);

})(current, template, email, email_action, event);

Bhavya11 · ‎01-09-2025

Hi @abhaysingh98 ,

could you please try below script

(function (current, /* TemplatePrinter */ template,
/* Optional EmailOutbound */ email, /* Optional GlideRecord */ email_action,
/* Optional GlideRecord */ event) {

// Array to store incident numbers
var arr = [];

// Query active incidents with specified criteria
var gr = new GlideRecord('incident');
gr.addEncodedQuery('active=true^stateIN1,2^activity_leaderDYNAMIC90d1921e5f510100a9ad2572f2b477fe');
gr.orderByDesc('sys_created_on') // add the sorting here
gr.query();
while (gr.next()) {
arr.push(gr.number.toString());
}

// Build rows with clickable URLs
var rows = '';
for (var i = 0; i < arr.length; i++) {
var sr = new GlideRecord('incident');
sr.addQuery('number', arr[i]);
sr.query();
while (sr.next()) {
// Construct the clickable URL
var url = gs.getProperty('glide.servlet.uri') + sr.getTableName() + ".do?sys_id=" + sr.sys_id;

// Add rows to the table
rows += '<tr>';
rows += '<td><a href="' + url + '">' + sr.number + '</a></td>'; // Clickable incident number
rows += '<td>' + sr.getDisplayValue('state') + '</td>';
rows += '</tr>';
}
}

// Build the final table with headers
var data = '';
data = '<table style="border-collapse: collapse;" border="1" cellpadding="5"><thead>';
data += '<tr><th>Incident Number</th><th>State</th></tr></thead><tbody>';
data += rows;
data += '</tbody></table>';

// Print the table in the email
template.print(data);

})(current, template, email, email_action, event);

If my response helped please mark it correct

Thanks,

BK

View solution in original post

Bhavya11 · ‎01-12-2025

Hi @abhaysingh98 ,

Run daily and also pass opened_By parameter via gs.eventQueue and check send to event param1 true in notification

If my response helped please mark it correct

Thanks,

BK

abhaysingh98 · ‎01-19-2025

Hi @Bhavya11 ,

do we need to do glide record of the table before using gs.eventQueue() in scheduled job script.