Database Triggers based on document date

Hi Pavel.

A lot may have changed since this post was created… I am still having an issue of easily triggering a function based on a document value (i.e date value) Cron expressions are ment to be run multipole times, however I only want to run a function once (like send an email based on a date/time)

Currently i poll the database daily and check the dates for all records, and launch the function (but seems very inefficient)

Note that I do not want to delete the document, I only want to check if the date field is passed. Can i still use a TTl trigger for this?)

Is the above solution still the best option ? Thanks