Skip to Content
Mar 09, 2021 at 04:40 PM

IN operator in odata get query

1480 Views Last edit Mar 10, 2021 at 04:33 PM 3 rev


I am trying to create an OData query with IN operator as it is mentioned in the sap help center that ODATA v2 adapter now supports IN operator in filter. Link to the sap help center:

I want to get the same result of the below query which uses eq with or operator, but I want to use IN operator

$select=OrderID,CustomerID,OrderDate&$filter=OrderID eq 10248 or OrderID eq 10249

The query which I created is with IN operator is below but its not working.

$select=OrderID,CustomerID,OrderDate&$filter=OrderID in 10248,10249

I am getting error in CPI is (Fault:Sequential processing failed for number 0)

Please let me know if I am missing something in the query.