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 ..?
-
"Our Target list needed to dynamically update when Reports are updated. It worked exactly as the documentation said it would."
Read More Reviews
- Most Recent Love from Users
BradLohoar- michelleredmond
- michellewright
- mattb
11 months ago
Hi, you can change the Where clause to leads.date_entered between DATE_ADD(CURDATE(),INTERVAL -1 day) and CURDATE()
11 months ago
It's ok for me to manually change SQL. just wondering if it should be so.
Thank you for your quick response
11 months ago
Hi, yes it is. the Quick 2list allows either selection form a report or writing an SQL query.