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
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