I am developing my first application on HANA Cloud Plattform.
I uploaded a table with 13 million rows, but I want that my application just returns a few of them.
Is it possible to pass an parameter via URL to my application?
So that the user can interact with the application and gets only results returned for his input?
Lets say: SELECT * FROM "1084"."Adresses" WHERE street = ''(and this is the dynamic part, depending on user input).
Could you give me an example of how to best practice the realisation of my concern?
Thanks in advance,
is the question here how you can solve it for a specific service (e.g. with XSJS or OData) or is it a more general question what service type you should use.
It will work with XSJS and OData. From a development point of view OData should be preferred here, because all the server-side logic regarding the (standard) filtering options comes out of the box. On the client side, e.g. in a UI5 app you just have to set a corresponding filter for the property. With an XSJS service you have to implement the logic by yourself.