It is currently Wed Aug 27, 2014 9:11 am




Post new topic Reply to topic  [ 3 posts ] 
 Alert email addresses from a database table 
Author Message
General
General

Joined: Fri Feb 08, 2008 11:05 am
Posts: 161
Post Alert email addresses from a database table
I have several alerts that go to a particular group of people. The manager of that group would like to be able to select from a list, the members of his group that will receive the emails during the current week. He would like to be able to change that listing every week or even every few days. Is there a way I could have FSQL get the alert distribution list for certain alerts from the database?

_________________
Ron
Sierra Nevada Brewing Co.


Fri Feb 26, 2010 4:26 pm
Profile
Moderator
Moderator

Joined: Sun Apr 02, 2006 3:43 pm
Posts: 2493
Post Re: Alert email addresses from a database table
If you're already using/are familiar with distribution groups, it's useful to note that FactorySQL will load them every minute, specifically in order that they can be changed from time to time.

So, all you really need to do is define the groups, and then create an interface somewhere that lets the managers play around with which contacts are assigned to which groups (the mapping is contained in the "alert_distro_gc_map" table).

If you don't want a user to receive emails, just remove their id from that table. There are a variety of other things you could do (such as perhaps renaming the mapping table and then creating a view that mimics it, but only returns contacts who have a new "enabled" column selected or something), but this direct management is the easiest.

Regards,

_________________
Colby Clegg
Inductive Automation
Software Development


Fri Feb 26, 2010 5:32 pm
Profile
General
General

Joined: Fri Feb 08, 2008 11:05 am
Posts: 161
Post Re: Alert email addresses from a database table
Thanks Colby. That seems pretty straight forward.

_________________
Ron
Sierra Nevada Brewing Co.


Mon Mar 01, 2010 8:11 am
Profile
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 


Who is online

Users browsing this forum: Yahoo [Bot] and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to: