DaDaBIK
This forum is devoted to the discussion about the software DaDaBIK database front-end
the PHP Database application generator for MySQL, PostgreSQL and SQLite; also available for Wordpress.

Welcome! Log In Create A New Profile

Advanced

SEND E-MAIL WHEN VIEW CONTENT WILL BE UPDATED

Posted by Amigamerlin 
SEND E-MAIL WHEN VIEW CONTENT WILL BE UPDATED
March 20, 2019 02:49PM
Hello,
I've a view that organize the record according the sql query below:
.... WHERE DATE BETWEEN (NOW() - INTERVAL 2 DAY) AND (NOW() + INTERVAL 30 DAY)
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.
Re: SEND E-MAIL WHEN VIEW CONTENT WILL BE UPDATED
March 21, 2019 10:01AM
No, not automatically, the parameter $enable_insert_notice_email_sending only works when there is an actual insert (using DaDaBK).

Best,

________________________________________________________
Eugenio |\.-./| DaDaBIK developer and project admin
Re: SEND E-MAIL WHEN VIEW CONTENT WILL BE UPDATED
March 21, 2019 11:43PM
Please can you provide a not automatically possible solution?
Thank you .
Re: SEND E-MAIL WHEN VIEW CONTENT WILL BE UPDATED
March 21, 2019 11:51PM
... or a suggestion / how overcome the problem (hooks?)

Thanks.
Re: SEND E-MAIL WHEN VIEW CONTENT WILL BE UPDATED
March 22, 2019 01:23AM
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,

________________________________________________________
Eugenio |\.-./| DaDaBIK developer and project admin
Sorry, only registered users may post in this forum.

Click here to login