how to get related incidents for a problem record

rudra8
Kilo Contributor

hi everyone,

 i have a doubt. how to get all related incidents which are attached to a problem record  . for example if 3 incidents are attached to a problem i want to display those incident number in a field ( let us say  for ex: description field).

i written the code using business rules:

var string=[];
var obj={};
var gr=new GlideRecord("incident");
gr.addQuery("problem_id","=",current.sys_id);
gr.query();
while(gr.next())
{
//current.work_notes=gr.getDisplayValue('number');
string.push(gr.getDisplayValue('number'));
}
for (var i=0;i<string.length;i++)
{
current.description=string[i].number;
}

 

any help is appreciated.. thank you

1 ACCEPTED SOLUTION

Can you try below :

 

var string=[];

var gr=new GlideRecord("incident");
gr.addQuery("problem_id",current.sys_id);
gr.query();

while(gr.next())
{
string.push(gr.number.toString());
for (var i=0;i<string.length;i++)

}
current.description=string.join(',');
current.update();

View solution in original post

5 REPLIES 5

Harsh Vardhan
Giga Patron

if you are using business rule then you should not use current.update().

on which table are you running this business rule? problem or incident?  if you are running on problem table then 

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

if on incident table 

gr.addQuery('problem_id',current.problem_id);

i assume you are running on problem table .just try.

 

var check=[];
var gr = new GlideRecord('incident');
gr.addQuery('problem_id',current.sys_id);
gr.query();
while(gr.next())
{
check.push(gr.number);
}
current.description=check;