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!
Best answer by Naveen Boga
So, when filtering by multiple values, using multiple OR conditions in the $filter clause is the supported approach. If this becomes too large or frequent, a custom REST endpoint would be a better long-term solution for your requirement.
+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
Hi
I would add a condition in GI instead of adding a multiple SOs through OData request. Alternative, you can add a parameter to GI which you can use in your OData request to retrieve your data. Let me know if this helps.
Refer to below link for more help
Generic Inquiry Access Through OData: To Filter the Results of a Generic Inquiry
Retrieve a List of Sales Orders with Details and Related Shipments
Hi
I would add a condition in GI instead of adding a multiple SOs through OData request. Alternative, you can add a parameter to GI which you can use in your OData request to retrieve your data. Let me know if this helps.
Refer to below link for more help
Generic Inquiry Access Through OData: To Filter the Results of a Generic Inquiry
Retrieve a List of Sales Orders with Details and Related Shipments
Neither article provides any information on how to add a filter with multiple values.
+20
I reviewed that article, but I did not find any information on how to filter based on multiple values (ie. “Order Number IN [001, 002, 005, 007]” )
+20
That said, this is a great suggestion. I would recommend submitting this idea to the Acumatica Product Ideas forum, where the product team reviews enhancement requests. If approved, it may be considered for inclusion in a future release.
Thanks,
If there truly is no other way to read data from a GI other than OData3 and multiple OR filters, then so be it.
+20
So, when filtering by multiple values, using multiple OR conditions in the $filter clause is the supported approach. If this becomes too large or frequent, a custom REST endpoint would be a better long-term solution for your requirement.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
