How to get static_filter working in Grid report widget
I have a custom report created that is filtered in the report as I want and it works in OSvC. However, when I display the report using the Grid widget, the report filter is not being applied. Further when I use the static_filter parameter it also is being ignored no matter how I've tried to format it.
The grid report is showing Answers that have a specific category. I put in static_filter="answers.map_cat_hierarchy=Hot Answers"
and none of those returned any records from the table, even though that is the filter applied in the report itself. 470 is the category ID.