Refresh a filter via a db update instead of clicking refresh filter cache?
I have a piece of master data that is common across hundreds of reports.
The list of valid values in the data has changed. It is taking too long to try to update each report by clicking refresh filter cache. Is there a way to do it at the database level instead?
If so can you please share the sql to do so