🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all the hot features!
Get Free Trial

How to filter on multiple values (tags) in a list

abons asked on March 5, 2019

I’d like to filter all results with tag “fugiat” or “quis” from a text-field containing tags (comma separated)
Or maybe as OR-filter over multiple columns with field seperated tags

4 answers

Dmytro Zvazhii Dmytro Zvazhii Flexmonster March 5, 2019

Thank you for your question.
Currently, several filtering queries unioned with logical operations are not supported.
Therefore, please consider using the following workarounds:

Please let us know in case you need more guidance from us.

abons March 5, 2019

Thank you for the quick response.
I’ll extend the filtering functionality for the OR-filter in my case.
It worked great by adding a simple search.split(‘ ‘) in the example.
Is is also possible to extend the filter popup for this specific filter?
> the options list should be separate tags (from members.caption or other source)
> applying the popup should use the new filter

abons March 6, 2019

I got the OR-filter working for my case (after I updated to v2.7.0).

  1. I used the filteropen event to open a custom popup as mentioned in https://www.flexmonster.com/question/is-it-possible-to-access-filter-list/
    > would be nice if the filteropen could be cancelled or replaced (maybe beforeFilterOpen)
  2. It would be even better if the OR-filter could be added to the existing popup to have both filter-options available and the new v2.7 filter
Tanya Gryshko Tanya Gryshko Flexmonster March 7, 2019

Thank you for your feedback.
We are glad you have managed to get the OR-filter working for your case. If you want to hide the existing filtering pop-up window, you can do it with the help of CSS styles. The existing filtering pop-up window provides functionality ‘as is’ so for custom cases we suggest creating your own pop-up window.
I hope this answers your question, but please let me know if you would like to know anything else.

Please login or Register to Submit Answer