OData 2.0 expanded Object filter

former_member746681 — Wed, 02 Jun 2021 15:44:26 GMT

So the original issue is that I have fields that I need to filter in the expand object of an OData 2.0 Service. This Expand Object is a 1:N (multiple item lines for a single purchase order). So does not allow me to filter directly.

Second option is the run the call in the line object first to get a list of the Order that qualified and use that to go back to header to filter. The problem now is, 2.0 does not support contain or in. And I can't use substringof because the order ID is a numeric so looks like string function does not apply. (I have tested the substringof for string and works great). Further more, I will have thousands of order list to filter against and using (PurchaseOrder eq 1 or PurchaseOrder eq 2) is not practical.

Any idea on how to do this type of expand object filter for OData 2.0?

Re: OData 2.0 expanded Object filter

former_member746681 — Thu, 03 Jun 2021 00:42:34 GMT

Anyway to upgrade existing OData V2 in S4Hana to V4 service?

topic Re: OData 2.0 expanded Object filter in Application Development and Automation Discussions

OData 2.0 expanded Object filter

Re: OData 2.0 expanded Object filter