SEND E-MAIL WHEN VIEW CONTENT WILL BE UPDATED

  • Thread starter Deleted member 75341
  • Start date
D

Deleted member 75341

Guest
Hello,
I've a view that organize the record according the sql query below:
[pre]
.... WHERE DATE BETWEEN (NOW() - INTERVAL 2 DAY) AND (NOW() + INTERVAL 30 DAY)
[/pre]
So when the date inserted into the record will be in the sql condition, view will be updated with the new item.

I would like to know if there's a way to can send an e-mail when a new row will be added in this view.
Thank you.
 

eugenio

Administrator
Staff member
No, not automatically, the parameter $enable_insert_notice_email_sending only works when there is an actual insert (using DaDaBK).

Best,
 
D

Deleted member 75341

Guest
Please can you provide a not automatically possible solution?
Thank you .
 
D

Deleted member 75341

Guest
... or a suggestion / how overcome the problem (hooks?)

Thanks.
 

eugenio

Administrator
Staff member
You could check the condition after insert and / or after update in the original table and send the email if the condition is true. However, you should keep track somewhere of the record you already sent the email for.


Best,
 
Top