Hello guys,
I´m trying to filter calendar events by categories and there are several values to match. I mean there are for instance 3 categories as:
1. Blue
2. Green
3. Red
So I´m trying to create a filter to get only the events that match those categories values, this is the fun part when I´ve tried to filter just one value it works perfectly fine using the following filter :
categories/any(c: c eq 'Blue')
But when I tried to use more values to compare it doesn´t work , I tried this filter
categories/any(c: c eq 'Blue' or c eq 'Red')
And an error message appears :
"The query filter contains one or more invalid nodes."
I tried other syntax :
1. (Categories eq 'Blue') or (Categories eq 'Red')
2. Categories in ('Red', 'Blue','Green')
3. (Categories in ['Red', 'Green','Blue'])
I don´t know what I´m missing to create the OData Filter, in the Filter Query Field I´D LIKE TO UNDERSTAND WHY IS NOT WORKING AND IF IT´S POSSIBLE TO CREATE A FILTER THERE .
Thanks.
