Report: Inactive opportunities

Hi Kristjan,

I would probably recommend using the "is between" operator for the filter so that you can choose to display all of the opportunities last modified between two specified dates.  You could select something like 01/01/1999 as your first date (unless you happen to have opportunities from prior to 1999 that you want to include) and then you could choose 10 days ago as your second date, as shown in the following screenshot:

There might be a few other ways to do this, but I think that this would likely be the most straightforward.  Please keep in mind that if you are going to be using this report long-term into the future, you will have to change the second date on the filter to represent the date that was 10 days ago.

Regards,

Patrick Sullivan

SugarCRM Support

Thanks Patrick for your input.

But that´s the thing, this report needs to be dynamic in order to be scheduled. I assume that both dates in your example are fixed and would not change at the time this report´s schedule would run, correct?

Hi Kristjan,

Correct, the dates would be fixed and would not change when a report is scheduled to be sent via email.  We have a Knowledge Base article on a similar topic (http://support.sugarcrm.com/Knowledge_Base/Administration/Workflows/Tracking_Last_Activity_Date/index.html) but I tested out a few different things and I don't believe that is going to meet our needs in this case as it still would provide a fixed date.

The functions that are used in the report filters are stored in a file at the following location: ./include/generic/SugarWidgets/SugarWidgetFielddatetime.php

It may be possible to create a custom file, overriding that stock file, which would also include a "more than 10 days ago" filter.  I'll give others the opportunity to provide feedback on the exact code that would be used but it would probably incorporate something like the stock "queryFilterTP_last_7_days" function but for 10 days instead of 7, and then returning everything prior to that.

Regards,

Patrick

Thanks Patrick Sullivan

Thanks Patrick Sullivan