Column filter is not working when there is no matching data in the data source

Hello, Alex!
Thank you for contacting us.
 
Here’s a support ticket where the same question was discussed and we provided a workaround: https://www.flexmonster.com/question/members-dont-include/
 
Please let us know if this helps.
 
Regards, 
Solomiia

Hello, Alex!
Hope you are doing well.
 
Our team is wondering if you had some time to check the suggested thread about filtering. Did it help to solve the case?
Looking forward to hearing your response.
 
Regards,
Solomiia

Hello, Alex!

Hope you are having a great week.
 
Just checking in to ask if you've had a chance to try the suggested filtering approaches. Could you please let us know if the thread was helpful?
 
Looking forward to hearing from you.
 
Regards,
Solomiia.

Hello, Alex!

Hope you are doing well.

The Flexmonster team is glad to share that we’ve introduced a new filtering functionality to our pivot grid.

For the JSON and CSV data sources, we have added a new filter.allowEmptyMembersFilter option starting from the 2.9.86 version of Flexmonster. This property allows to show an empty table when the selection filter includes only members that do not exist in the dataset instead of removing the invalid filter.
So, if this approach matches your data source type(JSON or CSV), you are welcome to use it instead of the workaround we provided earlier. For other data source types, we recommend sticking to the approach of combining member and query filters.

Here is the JSFiddle to illustrate the idea: https://jsfiddle.net/flexmonster/vkthmug4/.

You can find more details about the new filtering functionality in our docs: https://www.flexmonster.com/doc/advanced-tips-filtering/#show-empty-grid-when-filtering-by-non-existent-members.

We thought this might be of interest to you, and we’d love to hear your thoughts if you get a chance to try it out.

Kind regards,
Solomiia