topic Re: OData Filter by Multi value 'in()' for Javascript not working in Application Development and Automation Discussions

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

klaudry — Sun, 14 May 2023 13:46:58 GMT

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 — Sun, 14 May 2023 14:27:30 GMT

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 — Sun, 14 May 2023 23:01:14 GMT

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

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