You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to get static_filter working in Grid report widget

Received Response
5
Views
2
Comments
edited Jun 7, 2022 1:23PM in General Technical Discussions 2 comments

Summary:


Content (required):

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"

static_filter="answers.map_cat_hierarchy='Hot Answers'"

static_filter="answers.map_cat_hierarchy=470"

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!