Where in list

[solokhind]

As of OData 4.01, the in statement is supported.

Here is the example from their documentation:

Example 56: all products whose name value is ‘Milk’ or ‘Cheese’:

https://host/service/Products?$filter=Name in ('Milk', 'Cheese')

https://docs.oasis-open.org/odata/odata/v4.01/csprd02/part2-url-conventions/odata-v4.01-csprd02-part2-url-conventions.html#_Toc486261685

Is there a functionality for this in this library? Thank you

[anderly]

Have you tried $client->where("Field", "contains", "foo")?

[solokhind]

This is a little different, I'm not trying to see if "field" contains "foo". I'm trying to see if "field" value exists in list. In the OData example, you're checking to see if Name equals "Milk" or "Cheese".

I know I can use the orWhere method for this, but it is inefficient.

[anderly]

@ds620107,

I see. I'm going to see if we can get this implemented using a whereIn() method similar to Laravel query builder whereIn method.

Signature would be like $client->whereIn('Name', ['Milk','Cheese'])

Let me know if that would achieve what you're looking for.

[solokhind]

Yes, that would work. Thanks!

[joey-carlisle4]

any update?

[shaedrich]

I'd need that, too. So, I'm looking forward to it being implemented

[n8rowley]

I'd like to add my voice to those hoping this is still coming

[anderly]

Closed by #117

[anderly]

See tests here for example usage.