Hello All,
We are saving the filters user has applied to dashboard, there are regular filters and action filters(filter where user can select part of a map).
When I am trying to pass the action filter in the URL, i get a message saying "Unexpected server error", my filter name is "Action (State)" and when I pass it in the url i do it like this '&Action (State)=Colorado,Montana,Utah,Wyoming' and this gives the exception.
I have tried passing Action (State) as Action%20%28State%29, Action%20(State) but still the same exception.
But when I try to use the JS API 'applyFilterAsync' it works
activeSheet.getWorksheets().forEach(function(worksheet) {
if (worksheet.getName() == "Filter") {
worksheet.applyFilterAsync('Action (State)', ['Colorado','Montana','Utah', 'Wyoming'], 'replace').otherwise(function(err) {
console.log(err);
});
}
});
How can i get the URL way working? What am i missing. Any help in this would be really great. Thanks.
Hi Akshar,
Yeah, I'm getting the same error. My gut tells me it's because the filter that gets created with when you use a "Filter Action" is a set, instead of the dimension itself. In other words, Action (State) is a set build off of States, not the [State] dimension.
The URL filter works if you filter on the dimension instead of the set. Any action filters after that still work. So, instead of using &Action%20(State)=California...
... use &State=California.
Note the Drilldown sheet still got filter by the action filter. The workbook I used to test is attached in case it helps, but there's nothing special about it.
Hope this helps!
Santiago
