Hi,
How can I make an OData call to a Generic Inquiry with multiple values for a filter? For example, OrderID is 1001, 1003, or 1004.
I know OData v3 does not support the “IN” filter clause. But can I user parameters or OData v4 to retrieve multiple records based on an array of filter values?
Thanks!
+1Hi
Use multiple or conditions in $filter (most common)
GET /odata/MyGenericInquiry?$filter=OrderID eq ‘1001’ or OrderID eq ‘1003’
I was afraid that was going to be the only answer. I’m generating the request in code, so it’s certainly doable. But there can be dozens of order numbers. So it could be a request with 50+ “OR” conditions.
Will that be an issue? And is this the most efficient method in terms of the SQL server query it creates?
Hi
Use multiple or conditions in $filter (most common)
GET /odata/MyGenericInquiry?$filter=OrderID eq ‘1001’ or OrderID eq ‘1003’
Hi
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
