How to limit XSODATA query results on server side?
Hello HANA Developer Community,
I've extended the data model of my project: Raspberry Pi on SAP HANA Cloud Platform - without Java - Part 1: XSODATA Backend to include a column userId in the sensors table. Now I'm searching for the best approach how I can restrict the search query results returned by the HANA OData service on the server side. The service should return only the sensors and measurements which belong to the user. Unfortunately I haven't found any possibility to do XSJS coding for i.e. a create with the "using" keyword in the XSODATA service definition. Do I have to use analytic privileges to limit the user authorizations?
Looking forward for your suggestions.