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

[shrinivasprasad]

i dot walkin to the service_owner but it is sysapproval notification right i am not getting the expected result

[Sukhbir Singh2]

Hi

Assuming "current" is the problem GlideRecord.

You need to make one modification in your code, replace

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

with

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

The field on the problem_task table that stores the reference to problem is "problem".

If it answers your question, please mark correct/helpful.

Thanks

[shrinivasprasad]

Hi Sukhbir,

I tryed this aswell no 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

[Sukhbir Singh2]

Can you share some details of the notification? What is your "current"? 

[shrinivasprasad]

It is on sysapproval table, before approval i am trying to add the problem task.

Please let me know if any details needed