Search code examples
databaseodatasapui5hana

Are OData query options executed on server or client?

I am trying to obtain a sub-list of items in a SAP Hana database. If I use query option $filter e.g. /subscripor?$filter=age%20eq%2025 will the database return all the entries in the table and then oData will filter on client? or is this filter will be executed on the server? Can anybody point me to the documentation where this is clarify?

I've seen the OData documentation but doesn't specify where these query options are executed.

Solution

  • You have a degree of control over this and there are certain conditions attached to being able to perform the options locally. Please refer to the documentation here for the detailed info.

    To give you a sample use scenario within the context of a Table control see below:

    <Table noDataText="no data" id="table0" visibleRowCount="10" threshold="15"
    rows="{ path: 'yourModel>/yourDataSet', parameters: {operationMode: 'Server'} }">