sql server notification services: custom content formatter -- sql server notification services

custom content formatter

puneetdk NO[at]SPAM gmail.com
12/12/2006 11:58:31 AM

sql server notification services:

Hi!

Is there a way to access the SubscriptionId, SubscriberId and
DeviceName fields inside a class for a custom content formatter?

I need to personalize the email depending on the SubscriberId (I will
retrieve Subscriber's info from a Db table) and I also need to format
the message depending on the SubscriptionId - so diff. subscription's
can have a diff. format (again retrieved from DB tables based on
SubscriptionId)

Any help is greatly appreciated.

Thanks
DK

Re: custom content formatter

Joe Webb
1/18/2007 8:18:56 AM

[quoted text, click to view]

Hi DK -

Check out the FormatContent method in the Custom Content Formatter. It has
the following signature:

public string FormatContent (
string subscriberLocale
,string deviceTypeName
,RecipientInfo recipientInfo
,HashTable[] rawContent)

Try the recipientInfo argument.

HTH...

Joe

--
Joe Webb
SQL Server MVP
http://www.sqlns.com