Fetching all the task numbers from the problem task table.

shrinivasprasad
Tera Expert

Hi Community,

In problem record i have created only one problem task and trying to display in the notification but it is showing all the notification from the problem task table.

I have written mail script to get these problem tasks.

Code:

var gr = new GlideRecord("problem_task");
gr.addQuery("problem_id", current.sys_id);
gr.query();
while(gr.next()) {
template.print(gr.getDisplayValue('number') + "<br>");
}

find_real_file.png

find_real_file.png

Any suggestions please.

Thanks,

Shrinivasprasad

1 ACCEPTED SOLUTION

Made some edits to the code. Can you use the recent one. Also, use the exact field name for the known_error_field_name. I just used a variable name.

View solution in original post

25 REPLIES 25

yes, and it is referenced to kb_template_faq table

 

find_real_file.png

Try the below code to print the link:

known_error_field_name -- Filed name for the known error number field, asssuming it to be on problem record

var known_error = ''+current.sysapproval.known_error_field_name;
var known_error_number = ''+current.sysapproval.known_error_field_name.getDisplayValue();

var link = "/kb_template_faq.do?sys_id="+known_error;

var kb_link = "<a href='" + link +"'>" + known_error_number+ "</a>";

template.print("Known error  : " + kb_link+ "<br/>");

 

Thanks

It is showing below error and record not visible in the ITIL view

find_real_file.png

Made some edits to the code. Can you use the recent one. Also, use the exact field name for the known_error_field_name. I just used a variable name.

yes it is working now thank you so much for your time