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.
Query Condition:
... .. ..
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 ..?
a year ago
Hi, you can change the Where clause to leads.date_entered between DATE_ADD(CURDATE(),INTERVAL -1 day) and CURDATE()
a year ago
It's ok for me to manually change SQL. just wondering if it should be so.
Thank you for your quick response
a year ago
Hi, yes it is. the Quick 2list allows either selection form a report or writing an SQL query.