- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-06-2018 12:13 AM
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
Solved! Go to Solution.
- Labels:
-
Scripting and Coding

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-06-2018 02:28 AM
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();

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-06-2018 02:40 AM
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;