Daily summary notifiactions

[D Sha]

Hi, 

I have a requirement to configure a notification that consists of a list of all the outstanding notifications(from different tables) for a user. This notification is to be send daily to a user depending on what outstanding notifications they might have. I went through the email digest documentation, but it seems that email digest works for a particular table at a time. So email digest will work if there are a number of notifications from a particular table. Is that correct?

Is there any OOB solution for my requirement.

Any kind of help is appreciated

[Narsing1]

Hi,

When you say Outstanding Notification, do you mean the email has already triggered and you are seeing that in email log as "send-ignored" / "send-failed"?

Email digest is very useful for noisy emails such as "RITM comments added" where the user doesn't really required to get each and every time when the comments are added.  Rather, he may also receive a summarized notes at the end of the day.

If you need to resend a Notification that wasn't sent yet, you may consider this.

var gr = new GlideRecord("sys_email");
gr.addQuery("sys_id", < email sysid > );
// You may provide the receipient in your query to get all emails thats failed to send to the user
gr.query();
if (gr.next()) {
    gr.mailbox = "outbox";
    gr.type = "send-ready";
    gr.update();
}

Please mark it as correct answer if it helps so that this thread can be closed.

Thanks,

Narsing

[Jaspal Singh]

Mail relays are scheduled to execute every minute & two. So, kindly elaborate what do you mean here as 'outstanding notifications' for clearer understanding once according to which solution can be proposed.

[D Sha]

Hi Jaspal,

Thanks for acknowledging .

Let me explain it with an example,

So a user receives the following notifications(OOB):

1.regarding an engagement, which is closed -- this notification is on sn_audit_engagement table

2.regarding an audit task, which is expired --this notification is on sn_audit_task table

3.regarding a milestone. for which assigned to has changed ---this notification is on sn_advanced_milestone table

So all these notifications a user received and all these are a part of different tables and are different notifications. 

Now the requirement is that I should have 1 email notification configured that consists of a list of all these outstanding notifications(mentioned above) for a user. 

Can we use email digest here? 

Or Is there any OOB solution for this?

How can this be achieved?

[Swapnil Shirsik]

You mentioned two contradictory things? 1-user received above mentioned emails. 2-one email consisting of these outstanding notifications?

If user has already received multiple notifications, then what is the purpose of sending all the consolidated notifications again in one more notification? Also, since the email logs table contains huge data, querying it might cause performance issues.