Developer forum

Forum » Development » Send email notification on SQL Query

Send email notification on SQL Query

E-mail notifications
Nuno Aguiar Dynamicweb Employee
Nuno Aguiar
Reply
Posted on 26/11/2021 18:38:54

Hi,

 

I'm not sure if this should be a feature request, custom development or if there's a way to do it already.

 

My requirement is to have a SQL query to run on a schedule and if there are records, send an email to someone.

 

Isolated are pretty simple concepts to implement, but I am not sure if I can achieve this without re-inventing the wheel.

 

Best Regards,

Nuno Aguiar


Replies

 
Nuno Aguiar Dynamicweb Employee
Nuno Aguiar
Posted on 01/12/2021 18:39:42
Reply

bump

 

Maybe a feature request? The starting point for an Email notification feature that's abstract and takes a provider as a source? :P Getting inspiration from PIM's email notifications something like:

  • Notification rule
    • Send if query contains result
    • Send if query contains more than ‘x’ results
    • Always send
 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Posted on 01/12/2021 20:04:26
Reply

It would be fairly simple to build. You can take the "Run SQL" task for the SQL stuff as a starting point and the take the email portion from an existing batch job. If you build it yourself you get lots of control over the input and output of the module.

Imar

 
Nuno Aguiar Dynamicweb Employee
Nuno Aguiar
Posted on 03/12/2021 23:05:48
Reply

Hi Imar,

 

Yeah, I figured as much, thanks.

 

In fact I'm trying a concept of an Email Notification Center and make this then Provider based ;) https://www.screencast.com/t/u34cMHnM

 

Best Regards,

Nuno Aguiar

 

You must be logged in to post in the forum