OData Filter by Multi value 'in()' for Javascript not working

[klaudry]

Hi, I'm using OData client v2 for my VUEJS app and trying to filter like this

$format=json&$top=50&$filter=substringof('COFFE', searchKey) and (origin eq 'BRA' or origin eq 'COL')

according to this light OData documentation we can use in() like this

$filter=substringof('COFFE', searchKey) and origin in ('BRA', 'COL')

the first one with 'OR()' works, but the second with 'IN()' unfortunately is not working, any idea?

[klaudry]

Hi, I'm using OData client v2 for my VUEJS app and trying to filter like this

$format=json&$top=50&$filter=substringof('COFFE', searchKey) and (origin eq 'BRA' or origin eq 'COL')

according to this light OData documentation we can use in() like this

$filter=substringof('COFFE', searchKey) and origin in ('BRA', 'COL')

the first one with 'OR()' works, but the second with 'IN()' unfortunately is not working, any idea?

[Yogananda]

klaudry

According to this Stack Overflow post, the correct syntax for using the in() operator in OData is as follows:

$filter=substringof('COFFE', searchKey) and (origin eq 'BRA' or origin eq 'COL')

Copy

The syntax you mentioned is incorrect:

$filter=substringof('COFFE', searchKey) and origin in ('BRA', 'COL')

Copy

I hope this helps. Let me know if you have any other questions.

[evanireland]

Since your URL has "substringof" rather than "contains", I assume that the server is implementing OData V2.

The "in" operator is defined only since OData V4, e.g. http://docs.oasis-open.org/odata/odata/v4.01/odata-v4.01-part2-url-conventions.html#_Toc31360968

(Even then, a V4 server might or might not support it).

So for a V2 service using the "or" operator might be the only available choice.