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

How to filter by multiple values

Cedric Gaines asked on January 30, 2020

How do I filter by multiple values.
Example:  I set the filter to Contains and i want to see if a field contains either “ValueA” and / or “ValueB”?
Does flex monster see what the field type is and can only show filters that are relivent to the field type.
Example: if the field I want to filter is “Name” and Name is a sting.  Can we set a setting on the control that will only show filters that are relivent to strings.  Like I shouldn’t see things like ‘Greater Than’, ‘Less Than’ cause you cant filter by greater than on strings?

1 answer

Vera Didenko Vera Didenko Flexmonster January 30, 2020

Hello, Cedric,
Thank you for your questions.
1. Regarding And/Or filters:
Please kindly note that currently the dates, labels and values filters can be used for only one condition at a time (for example, find fields that contain “valueA”). 

2. About the available filter properties for different field types:
Yes, depending on the field’s data type, Flexmonster provides different filter options. For example, the begin and contain filter properties are available only for string fields.
We would like to explain that the less than and greater than filters are used for string fields as well, except in this case the filter logic is different from the numeric ones.
Here are several links for reference:
2.1) Filter properties for strings: https://www.flexmonster.com/api/string-query-object/
2.2) Filter properties for numbers: https://www.flexmonster.com/api/number-query-object/
2.3) Filter properties for dates: https://www.flexmonster.com/api/date-query-object/
We hope this helps.
Please let us know if you have any additional questions.
Kind regards, 

Please login or Register to Submit Answer