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

Grouping Data for Consolidated Notification

Subject: Grouping Data for Consolidated Notification
From: raj
Date: Sat, 21 Jul 2007 11:06:51 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
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


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