Totara Learn Open Discussions

Report Builder - Filters

 
WilesJohn
Report Builder - Filters
WilesJohn 发表于 2020年12月14日 Monday 12:16
 

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
Eves (Totara Support)Craig 发表于 2020年12月15日 Tuesday 18:59
小组 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


WilesJohn
Re: Report Builder - Filters
WilesJohn 发表于 2020年12月15日 Tuesday 19:46
 

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.