Show TOC

Conversion Support for Complex FiltersLocate this document in the navigation structure

In the past SAP Gateway only offered the conversion of $filter expressions into range tables. For certain applications this was not sufficient. Developers had to perform the conversion of complex filter expressions themselves.

Now SAP Gateway supports conversion for complex filter expressions. With this, application developers can now get OpenSQL statements from filter select options.

Sample code:

/sap/opu/odata/IWBEP/TEA_TEST_APPLICATION/Conversions?$filter=price_1 gt 1600 and currency_1 eq 'JPY' ( ( PRICE_1 > '1600' ) AND ( CURRENCY_1 = 'JPY' ) ) 

More examples of complex filter expressions that are supported:

Figure 1: Examples