I configured a Filter widget so that you can select multiple predefined values from the dropdown menu. I used the 'contains' condition since the field contains a list of concatenated values, for example: '2020-2021', 2019-2020', 2018-2019', and so forth.
![expression1.png expression1.png](https://community.esri.com/t5/image/serverpage/image-id/58321iF0955F9BDA0E3F58/image-size/medium?v=v2&px=400)
I want to be able to set an 'AND' condition for filtering the checked values, but the default behavior seems to be set to 'OR'. I know I have the option to select a condition if I add a filter for each year range, but I don't want to do that. The years range from 2008 to 2021 and that's too many filters.
What's weird is that in the main app config there appears to be a "logicalOperator" property in the 'sqlExprObj' for each filter. I tried changing the property value to "AND" but it made no difference, like the property is being ignored. Was wandering if I am missing something, or is something that isn't currently possible.
![expression2.png expression2.png](https://community.esri.com/t5/image/serverpage/image-id/58322i63AA5878357FFE40/image-size/large?v=v2&px=999)