Script rows & columns in an Email Script

[nebula]

Following this resolution, I am creating an email script that lists our CI's and owners in rows and columns. I am able to generate the column, but one side (owners) is significantly shorter. The formatting is making this a big challenge as it does display the information, just not well. I believe an issue could be that I didn't close the </width> but even adding it to line 12 in the screen shot didn't seem to keep the width of the rows short. 

Thank you for reading!

[Voona Rohila]

Hi @nebula 

can you please share the code instead of screenshot.

[nebula]

Hello! Sure, it's:

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

template.print("<table>");
template.print("<tr>");
template.print("<td>");

template.print("<style>table{width:100%;border-collapse:collapse;text-align:left;} th{border:1px solid black;}, td</style><table><tr><th width=100%>Affected CI</th><th width=100%>Owned By</th></tr>");
template.print("</td></tr></width>");

var gr = new GlideRecord('task_cmdb_ci_service');
gr.addQuery('task', current.sys_id);
gr.addNotNullQuery('cmdb_ci_service.owned_by');
gr.query();
template.print("</tr>");
template.print("</td>");
while (gr.next()) {
template.print("<tr><td style=\"border: 1px solid;border-color: black;border-collapse:collapse;\" >");
template.print(gr.cmdb_ci_service.name + "</td>");
template.print("<r><td style=\"border: 1px solid; border-color: black;border-collapse:collapse;\" >");
template.print(gr.cmdb_ci_service.owned_by.name + "</td>");
template.print("</tr>");
}
template.print("</table>");

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

[nebula]

Sure, it's:

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

template.print("<table>");
template.print("<tr>");
template.print("<td>");

template.print("<style>table{width:100%;border-collapse:collapse;text-align:left;} th{border:1px solid black;}, td</style><table><tr><th width=100%>Affected CI</th><th width=100%>Owned By</th></tr>");
template.print("</td></tr></width>");

var gr = new GlideRecord('task_cmdb_ci_service');
gr.addQuery('task', current.sys_id);
gr.addNotNullQuery('cmdb_ci_service.owned_by');
gr.query();
template.print("</tr>");
template.print("</td>");
while (gr.next()) {
template.print("<tr><td style=\"border: 1px solid;border-color: black;border-collapse:collapse;\" >");
template.print(gr.cmdb_ci_service.name + "</td>");
template.print("<r><td style=\"border: 1px solid; border-color: black;border-collapse:collapse;\" >");
template.print(gr.cmdb_ci_service.owned_by.name + "</td>");
template.print("</tr>");
}
template.print("</table>");

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

[nebula]

For those looking for the code: 

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

template.print("<table>");
template.print("<tr>");
template.print("<td>");

template.print("<style>table{width:100%;border-collapse:collapse;text-align:left;} th{border:1px solid black;}, td</style><table><tr><th width=100%>Affected CI</th></tr><th width=100%>Owned By</th></tr>");
template.print("</td></tr></width>");

var gr = new GlideRecord('task_cmdb_ci_service');
gr.addQuery('task', current.sys_id);
gr.addNotNullQuery('cmdb_ci_service.owned_by');
gr.query();
template.print("</tr>");
template.print("</td>");
while (gr.next()) {
template.print("<tr><td style=\"border: 1px solid;border-color: black;border-collapse:collapse;\" >");
template.print(gr.cmdb_ci_service.name + "</td>");
template.print("<r><td style=\"border: 1px solid; border-color: black;border-collapse:collapse;\" >");
template.print(gr.cmdb_ci_service.owned_by.name + "</td>");
template.print("</tr>");
}
template.print("</table>");

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