by FibreCRM

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.

Cancel at any time!
Free Trial

#3843 - Query from report: data i hard coded.

Open General Question created by nilsottosson Verified Purchase 11 months ago

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 ..?

  1. fibrecrm member avatar

    FibreCRM Provider Affiliate

    11 months ago

    Hi, you can change the Where clause to leads.date_entered between DATE_ADD(CURDATE(),INTERVAL -1 day) and CURDATE()

  2. nilsottosson member avatar

    nilsottosson Verified Purchase

    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

    • fibrecrm member avatar

      FibreCRM Provider Affiliate

      11 months ago

      Hi, yes it is. the Quick 2list allows either selection form a report or writing an SQL query.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • "Our Target list needed to dynamically update when Reports are updated. It worked exactly as the documentation said it would."

    Read More Reviews

Keep up to date on the latest additions

We'll send you an email every month with handpicked add-ons, reviews, tricks and tips. Don't worry, we hate spam as much as you do.