APAC SD Team
Category
Administration
Product Version
9.0
Refresh all cached filter values
Idea Logged
In the past I remember there was a JSP to refresh all the filter caches for all reports. I dont remember it working for me (YF7), but it was there.
Is there some utility in YF9.6 to perform this Admin task on all reports in a YF instance? Almost all our reports have manual filter cache refreshes. is there some DB command I can run on the 9.6 YF DB to force this refresh?
I like this idea 
also...most of our reports have custom sql queries that pull from smaller tables with distinct metadata values use for filters, not from the view itself.
also...most of our reports have custom sql queries that pull from smaller tables with distinct metadata values use for filters, not from the view itself.
Hey Melissa,
At this point in time there is not utility in the UI or DB option to refresh manually cached filters. What I have done is converted this question into a product idea so this can be reviewed by the product team for a future release.
At the same time, you are correct in that there is a way to do this (as with most admin functions) via our web service calls. In this instance what you're after is this REFRESH_VIEW_CACHED_FILTERS . What this allows you to do is enter a ViewID and then have all the cached filters for that view (including any report level cached filters) to refresh.
I have created a working (albeit simple) .jsp as an example which I've tested as working in 9.6, you just need to modify to match you're environment before running. PLEASE ensure you understand this will refresh ALL filters against that view, which means it can slow down you're system during this process.
As always please let me know if there was anything else you were after that I could assist with.
Regards,
David
Hey Melissa,
At this point in time there is not utility in the UI or DB option to refresh manually cached filters. What I have done is converted this question into a product idea so this can be reviewed by the product team for a future release.
At the same time, you are correct in that there is a way to do this (as with most admin functions) via our web service calls. In this instance what you're after is this REFRESH_VIEW_CACHED_FILTERS . What this allows you to do is enter a ViewID and then have all the cached filters for that view (including any report level cached filters) to refresh.
I have created a working (albeit simple) .jsp as an example which I've tested as working in 9.6, you just need to modify to match you're environment before running. PLEASE ensure you understand this will refresh ALL filters against that view, which means it can slow down you're system during this process.
As always please let me know if there was anything else you were after that I could assist with.
Regards,
David
ok yea i saw the WS example for this in the tomcat folder. I'll take a look at your JSP, but I'll probably just export then reimport (with replace) the reports to get the updated caches. I do need to update some reports anyway.
ok yea i saw the WS example for this in the tomcat folder. I'll take a look at your JSP, but I'll probably just export then reimport (with replace) the reports to get the updated caches. I do need to update some reports anyway.
Replies have been locked on this page!