Dynamic Target Lists for SugarCRM enables users to AUTO populate Target Lists based on one or more pre-defined conditions. This module keeps your Target Lists up to date and relevant.
#3843 - Query from report: data i hard coded.
Ask the module.
I create dynamic "Target List" from existing report.
The report contains data from the previous day.
Define filter from report:
"User create " => "yesterday"
When I create a dynamic "Target List", I use the report,
but in SQL generated by the module, date is hard coded. which means that I get the same data all the time.
... .. ..
WHERE (((leads.date_entered >= '2018-08-20 22:00:00' AND leads.date_entered <= '2018-08-21 21:59:59'
(the date is hard coded)
Question: Is it possible to get around?
or do I have to edit the sql question ..?
Other add-ons of interest
Advanced Marketing Lists
Advanced Marketing Lists automatically fill Target Lists and keep updated the Campaigns to which they are associated.
Save Your Team Countless Hours. SugarChimp syncs your lists in both directions so that you can work in your preferred application. Segment and Group your MailChimp subscribers based on SugarCRM data so you can market to the right people at the right time. Fully compatible with all versions and e...