all groups > sql server notification services > march 2006 >
You're in the

sql server notification services

group:

Subscription Fields - Multiple values...


Subscription Fields - Multiple values... matt roberts
3/24/2006 12:00:00 AM
sql server notification services: Hi,

Is it possible to have subscription fields that hold "multiple values". I
want to allow subscriptions for "records" of a certain category, but I need
to let my subscriber choose one or more categories. Is this supported in
SSNS? They may even choose not to filter the category (in which case they
want all record notifications regardless of the category).... is it possible?

Thanks

Matt

Re: Subscription Fields - Multiple values... CoreyB
3/24/2006 11:11:04 AM
I'm kind of unsure of your question. It seems like you could just
create multiple subscriptions, and let your user pick which
subscription they want.
RE: Subscription Fields - Multiple values... Shashidhara
3/26/2006 8:47:01 PM
Hi Matt,

As a suggestion I would tell you to change your data model
slightly to have a map table of the "subscriber type" and their "category" of
subscriptions, also have a master table that consists of the "type of
subscriber". Now once that is in place you can place this subsciber type as a
field in your subscription tables which would map accordingly to send
notifications to subscribers based on their category of subscriptions.

Hope this helps you.
Shashidhara K


[quoted text, click to view]
RE: Subscription Fields - Multiple values... matt roberts
3/27/2006 12:00:00 AM
Hello Shashidhara,

Thanks for the info. I'll prototype this and a few other ideas and see what
works best :)



[quoted text, click to view]

AddThis Social Bookmark Button