Page History
...
Limit cached filter context
Use this parameter to force the filter formatting options 'Ignore Report Filters when Loading Cached Value' and 'Restrict SQL Context to Filter Columns Only' on (see the Dimension filter settings table of events on this page for more info).
When set to FALSE (default), these two options are displayed within the UI and the user can choose whether toggle them on or off.
When set to TRUE, these two options are both forced to be enabled on all filters on all reports on all datasources, and the options within the UI are hidden from display. In this situation, users don't need to remember to switch these settings on, and the only way they can be switched off is by changing this advanced configuration from TRUE to FALSE.
| Code Block |
|---|
INSERT INTO Configuration(1, 'SYSTEM', 'LIMITCACHEDFILTERCONTEXT', 'TRUE'); |
In this sample, 1 signifies the primary/default organization.
Anchor nullvalue nullvalue
Allow empty or null value to be used for cached filter
Use this parameter to get parent filter results to persist when a child filter result contains empty or null values.
When set to FALSE (default), cached filters will ignore empty or null values.
When set to TRUE, cached filters will not ignore empty or null values.
| Code Block |
|---|
INSERT INTO Configuration values(1, 'SYSTEM', 'ALLOWNULLCACHEFILTERS', 'TRUE'); |
In this sample, 1 signifies the primary/default organization.
Disable URL title fetching
...