Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
Showing results for 
Search instead for 
Did you mean: 
Developer Advocate
Developer Advocate
People always want full OData filtering (and other OData manipulations) in SAP Build Apps, and want to have complete control to send any $filter parameter they want. But the filtering is limited for some people (see this recent question).

To "solve" this, I used the REST data resource with destinations, instead of the OData integration. I admit you lose a lot of the advantages of the OData data resource – interpretation of the metadata, selecting all the entities, filtering/paging/ordering, and even converting the response. All that has to be done manually.

Still, I was able to filter without too much work – like send the parameter below – and I thought perhaps it might help someone to know how I did it.
/Customers?$filter=contains(CustomerID, 'AL')

The full explanation of what I did is published in the SAP Builders group – please also subscribe to the group!

Read the full blog