I want to show event table as related list on case form based on alerts.

ram medikonda
Tera Contributor

‎12-01-2023 10:59 AM

Hi All,

 

could please help me for below script...!

for one case there multiple alerts for those alerts there are multiple events, I want show all alerts events on case in case event related list table.

rammedikonda_0-1701457059465.png

 

rammedikonda_1-1701457059532.png

 

rammedikonda_2-1701457059509.png

 

 

 

For below script I am getting only one alert events.

var alGr = new GlideRecord("em_alert");
alGr.addQuery("u_case",parent.sys_id);
alGr.query();
while(alGr.next()){
var al=[];
al.push(alGr.number.toString());
gs.addInfoMessage("number"+al);

var evGr = new GlideRecord("em_event");
evGr.addQuery("alert",alGr.sys_id);
evGr.query();
while(evGr.next()){
var ev=[];
ev.push(evGr.alert.toString());
gs.addInfoMessage("event:"+ev);
}
}
current.addEncodedQuery("alert="+ev);

 

rammedikonda_3-1701457059610.png

 

 

 

Thanks,

Ram M.

0 Helpfuls
  • 252 Views
1 REPLY 1

Namrata Ghorpad
Mega Sage
Mega Sage

‎12-02-2023 12:16 AM

Hello @ram medikonda ,

Update your script like below and try.

 

var al=[];
var alGr = new GlideRecord("em_alert");
alGr.addQuery("u_case",parent.sys_id);
alGr.query();
while(alGr.next()){
al.push(alGr.getValue('number'));
gs.addInfoMessage("number"+al);
}
for(var i=0;i<al.length;i++)
{
var evGr = new GlideRecord("em_event");
evGr.addQuery("alert",alGr.sys_id);
evGr.query();
while(evGr.next()){
var ev=[];
ev.push(evGr.getValue('alert'));
gs.addInfoMessage("event:"+ev);
}
}
current.addEncodedQuery("alert="+ev);

 

Please mark my answer as correct and helpful if it helps to resolve your issue.

 

Regards,

Namrata

0 Helpfuls