Email script

Sironi · ‎07-19-2020

Hi,

someone help on incident script,

send incident details list to assigned to if incident state is OnHold on single notification .

ex: DavidLoo hasbeen assigned to 10-incidents , in 10-incidents there are 7 incidents have state -onhold. so DavidLoo should receive 7-incident details (number, shortdescription, caller , priority) in a single email.

i tried with below script, it is getting single incident details, how to get all in single email.

template.print("number :"+"${number}\n");

template.print("number :"+"${priority}\n");

template.print("number :"+"${caler_id}\n");

template.print("number :"+"${short_description}\n");

Ankur Bawiskar · ‎07-28-2020

Hi,

I just updated the job code

It triggered 3 emails to 3 different users

Email triggered to David Loo has incident info Assigned to David Loo

Email triggered to Rosie Mathews has incident info Assigned to Rosie Mathews

Email triggered to Fred Luddy has incident info Assigned to Fred Luddy

Now the only thing you need to check is why it didn't send email to other 6 users

Updated Job Code:

sendEmail();

function sendEmail() {

	var gr = new GlideAggregate("incident");
	gr.addAggregate("COUNT");
	gr.addEncodedQuery('active=true^assigned_toISNOTEMPTY');
	gr.groupBy("assigned_to");
	gr.query();
	while(gr.next()) {
		var user = gr.assigned_to;
		var incRec = new GlideRecord('incident');
		incRec.get('assigned_to', user);
		gs.eventQueue('test_list', incRec, incRec.assigned_to, incRec.assigned_to);
	}
}

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Jafrin Jack · ‎04-19-2021

Hi @Sironi ,

Can you provide your updated code on this.

Jaspal Singh · ‎07-19-2020

Simply replace

template.print("Number: " + current.number + "\n");
        template.print("Priority: " + current.priority + "\n");
        template.print("Caller ID: " + current.caller_id + "\n");
        template.print("Short Desc: " + current.short_description + "\n");
        template.print('-----------------------');

with

template.print("Number: " + current.number + "\n");
        template.print("Priority: " + current.priority.getDisplayValue() + "\n");
        template.print("Caller ID: " + current.caller_id.getDisplayValue() + "\n");
        template.print("Short Desc: " + current.short_description + "\n");
        template.print('-----------------------\n\n');

Since, caller_id is a reference field .getDisplayValue() should do the trick

Sironi · ‎07-20-2020

not working..

i don't want to trigger separate separate email, need to display 3-incident details in single email.

but here it is triggering

separate email

-------------------------------------------------------------------

Ankur Bawiskar · ‎07-20-2020

Hi,

if you require single email with 3 incident details then you need to trigger the eventQueue only once per user

In the email script you can have the query to show those 3 incident details

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Sironi · ‎07-20-2020

how to do that , can you please give more details ,