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: https://help.sap.com/viewer/368c481cd6954bdfa5d0435479fd4eaf/Cloud/en-US/c5c2e38e0c87472e996dfda04920bfc4.html
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.