Details about this thread
  • State Verified Answer
  • Replies 2 replies
  • Subscribers 324 subscribers
  • Views 1374 views
  • Users 0 members are here

Expose filters in advanced report

Bethel Dumbiri

Hi, I've created a report in the advanced module and the query has filters in the SQL. I can send the link to users to run the report. My issue is I want to expose these filters in the advanced report, so when the users want to run the report, they can change the filter. For example, in the custom query, I have date modified as a filter, which should be changed every time the query is run. I want the users to be able to change this when the report is run. Is there any way the filter can be exposed to the users.

Thanks.

Parents
  • +1

    Hi ,

    There is no way to expose the filters on advanced reports to be changed at run-time like you can with the standard report UI. For something like a filter on date modified, the best option you have is to make the SQL query more dynamic. For example, if you want it to always return records modified in the last 30 days, the filter would look like:

    Fullscreen
    1
    SELECT * FROM table WHERE date_modified BETWEEN NOW() - INTERVAL 30 DAY AND NOW();
    XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

    Co-Founder | SugarCRM's 2024 Global Outfitters Partner of the Year

  • 0 in reply to Chris Raffle

    Thanks, didn't think about that. It will resolve my issue.

Reply Children
No Data