microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Grouping Data for Consolidated Notification

Subject: Re: Grouping Data for Consolidated Notification
From: Joe Webb
Date: Mon, 23 Jul 2007 05:18:20 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
On Sat, 21 Jul 2007 11:06:51 -0700, raj wrote:

> We have a requirement where we need to send a single consolidated list
> of items belonging to a user which get active on particular date.
> 
> 
> 
> So, for example Item 1, Item 2, Item 3 gets active. These entries are
> inserted as Events. Now, we need to send single notification to the
> user with the email as:
> 
> =========================
> 
> Dear User,
> 
> 
> 
> Your following items got active today:
> 
> Item 1
> 
> Item 2
> 
> Item 3
> 
> 
> 
> Thanks,
> 
> Customer Care
> 
> =========================
> 
> 
> 
> For this we set the DigestDelievery to true and the emails indeed were
> consolidated. But, what it did was that it send single email
> notification repeating the entire content for each item as follows:
> 
> =========================
> 
> Dear User,
> 
> 
> 
> Your following items got active today:
> 
> Item 1
> 
> 
> 
> Thanks,
> 
> Customer Care
> 
> 
> 
> Dear User,
> 
> 
> 
> Your following items got active today:
> 
> Item 2
> 
> 
> 
> Thanks,
> 
> Customer Care
> 
> 
> 
> Dear User,
> 
> 
> 
> Your following items got active today:
> 
> Item 3
> 
> 
> 
> Thanks,
> 
> Customer Care
> 
> =========================
> 
> 
> 
> Please let me know if we are missing any setting or any changes need
> to be made in the .xslt for this to work.
> 
> 
> 
> regards,
> 
> Rajiv


Hi Rajiv - 

<Prev in Thread] Current Thread [Next in Thread>