How to display/print the value of Configuration Item field of Task table via email script (condition mentioned in description below)?

[rishabh31]

Dear Community,

Through email script how to get the value of field Configuration item (cmdb_ci) of Task table, condition is- it only displays its value when the 'name' of configuration item is of class (sys_class_name)- Computer (Only), rest for any other class it does not show Configuration Item on Tabular format

I tried below email script but not getting result please help, I am new on Coding.

    template.print("<tr><td style=\"padding: 5px; border: 1px solid; border-color: grey;\" >");
    template.print('Configuration item');
    template.print("</td><td style=\"padding: 5px; border: 1px solid; border-color: grey;\" >");

 var gr1 = new GlideRecord('cmdb_ci');
    gr1.addQuery('name', current.getValue(cmdb_ci));
    gr1.addQuery('sys_class_name', "Computer");
    gr1.query();
    if (gr1.next()) {

        template.print(current.getValue(cmdb_ci) == gr1.sys_id);
        template.print("</td></tr>");
    }
   
    template.print("</table>");

Please provide the revision on code, I shall be grateful.

Thanks!

[Nick Zitzer1]

Hi,

You have a few typos in your script that are impacting you. Try something more like this:

 var grCI = current.cmdb_ci.getRefRecord();

if(grCI.getValue('sys_class_name') == 'cmdb_ci_computer') {

template.print("<tr><td style=\"padding: 5px; border: 1px solid; border-color: grey;\" >");
template.print('Configuration item');
template.print("</td><td style=\"padding: 5px; border: 1px solid; border-color: grey;\" >");

        template.print(current.cmdb_ci.getDisplayValue());
        template.print("</td></tr>");
    }
   
    template.print("</table>");

[Mohith Devatte]

hello Rishab,

on which table is your notification configured?

[rishabh31]

Hi Mohith- Its configured on Custom Task Table (extended from Task table)

[rishabh31]

on Table- u_custom_task_table, extended from task table