❄️✨Ho-ho-holiday offer for new projects! Check out our pricing page.

How to filter by multiple values

Answered
Cedric Gaines asked on January 30, 2020

Hello,
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"?
also,
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?
Thanks

3 answers

Public
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/conditional-query-object/?target=string
2.2) Filter properties for numbers: https://www.flexmonster.com/api/conditional-query-object/?target=number
2.3) Filter properties for dates: https://www.flexmonster.com/api/conditional-query-object/?target=date
 
We hope this helps.
 
Please let us know if you have any additional questions.
 
Kind regards, 
Vera

Public
Ronnapat booranakhet September 17, 2025

 Do we currently support something like an AND/OR filter or the ability to create multiple condition filters? Has this been updated or added in the 2025 version?

Public
Maksym Diachenko Maksym Diachenko Flexmonster September 18, 2025

Hello,

Thank you for reaching out to us.

Currently, Flexmonster does not support AND/OR query filters out of the box. However, the filter by selection can be considered a type of OR filter from the perspective of a user applying filters at runtime. In this case, the filter search function can be compared to using a query. Selecting different members in the selection filter tells the component to show data where the member value is equal to "A" OR equal to "B". While this is still not a true OR filter and only mimics the behavior to some extent, it can be considered an alternative.

Please let us know if any other questions arise.

Best regards,
Maksym

Please sign in or register to submit your answer