Notification sent via event not working

Moedeb
Tera Guru

‎08-28-2023 05:32 PM

Hi all,

 

I have added a field to the user table that stores peoples end date with the intention of sending notifications to anyone who has an end date 14 days from now.

To do this I have a scheduled job that would be set to fire once a day (currently executing it manually to test it).

Moedeb_0-1693268655228.png

The event registry has the event in it with the table set as sys_user (where the expiry date is stored):

Moedeb_1-1693268758274.png

I then have a notification set to send when the event is fired:

Currently I have no conditions set as I just want to prove the notification is sent at all. 

Moedeb_2-1693268884502.png

 

The "Who will receive" currently is just set to send to myself and what it will contain just has some text in it so it will not be empty.

 

From my understanding this should work however it isn't. In the event log I can see an event being created, called the correct thing, but the table is blank and it also seems to have no other details in it.

Moedeb_3-1693269130159.png

Any help would be much appreciated.

 

0 Helpfuls
  • 481 Views
3 REPLIES 3

SwarnadeepNandy
Mega Sage

‎08-28-2023 05:42 PM

Hello @Moedeb,

You must pass additional parameters while triggering the event.

https://developer.servicenow.com/dev.do#!/learn/learning-plans/tokyo/new_to_servicenow/app_store_lea...

Trigger the event like this.

 

gs.eventQueue('x_60157_employee_spe.employeeOccasion',current,current.number,gs.getUserName());

 

 

The eventQueue() method inserts an event in an event queue. The eventQueue() method is typically passed four parameters but can also take an optional 5th parameter:

  1. Event name. Enclose the event name in quotes.
  2. GlideRecord object, typically current but can be any GlideRecord object from the event's table.
  3. Any value that resolves to a string. This is known as parm1 (Parameter 1). Can be a string, variable that resolves to a string, or method that resolves to a string.
  4. Any value that resolves to a string. This is known as parm2 (Parameter 2). Can be a string, variable that resolves to a string, or method that resolves to a string.
  5. (Optional) Name of the queue to manage the event.

 

Hope this helps.

 

Swarnadeep Nandy

0 Helpfuls

Moedeb
Tera Guru

‎08-28-2023 11:22 PM

@SwarnadeepNandy thank you for the info, I understand now that I need to add more parameters to my script, however I donb't know which ones I need to add, so I'm hoping that you can help me out a bit more please.

 

Here is some info that hopefully helps you to help me?

 

Event Name
check.expiry.date
Expiry Date Fieldu_employeeleavedatetime
Tablesys_user

 

The hope is to send an email notification to the user that meets the criteria, which will ultimately be a date 14 days from 'now'. 

0 Helpfuls

Moedeb
Tera Guru

‎08-31-2023 07:50 PM

Is anyone else able to assist please?

0 Helpfuls