Totara Learn Open Discussions

Report Builder - Filters

 
John Wiles
Report Builder - Filters
door John Wiles - Monday, 14 December 2020, 12:16 PM
 

I'm having an issue with some rather large reports that I have set to Restrict Initial Display. They're working as expected if the user has made their first attempt at viewing the report. However, if they leave the report and come back to it through the navigation they will see the old data. 

Is it possible to clear out those filters on page load if the visit was not from the report itself? For example a form submit from the report.

Thanks!

Craig Eves
Re: Report Builder - Filters
door Craig Eves (Totara Support) - Tuesday, 15 December 2020, 18:59 PM
Groep Totara

Hi John

Can you provide what Totara version you are using - in theory the report will not generate results until a filter is applied or an empty search is run.

Have you got report caching enabled for the report?

Regards


John Wiles
Re: Report Builder - Filters
door John Wiles - Tuesday, 15 December 2020, 19:46 PM
 

Totara 11.2. Caching is disabled.

If the report has never been run during my current session then it will not show results as it is set to restrict initial display. If I use the "clear" button on the filters it will clear the results and not show any results when navigating back to it.

The workaround I've put in place is that I have three different reports that are treated as embedded reports (but aren't flagged that way) inside a page under the "my" directory. This page determines if the data is POSTed to the page or GETted from it. If it is posted then it just passes the values along to the reports. Otherwise it passes my preferred defaults for each filter to the report. The data is being passed through the session.

This seems to work ok.... for now.