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 a year 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

    a year 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

    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

    • fibrecrm member avatar

      FibreCRM Provider Affiliate

      a year 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...
  • "We now have amazing automatic target lists. Support from fibreCRM was very fast and spot on."

    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.