Fetching all the task numbers from the problem task table.

[shrinivasprasad]

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

Any suggestions please.

Thanks,

Shrinivasprasad

[Jaspal Singh]

Replace

gr.addQuery("problem_id", current.sys_id);

with

gr.addQuery("problem", current.sys_id);

[shrinivasprasad]

Hi Jaspal,

i didnt get any results.

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

Thanks,

shrinivasprasad

[Jaspal Singh]

Notification is on which table?

[shrinivasprasad]

it is on sysapproval table