Entity from existing View


yesterday i had my first day with the cuba platform and i try to find out if it is the right platform for us. So my question is:

We have a complex SQL Statement which represent a view but the statement is build during the runtime. This means there is no physical view on the oracle server. How to create a entity with an existing sql statement with dynamic parameters an function and procedure calls?


1 Like


You can create a non-persistent entity and a middleware service which will load data by your conditions and map them to the entity instances. On the UI layer, use a custom datasource to load entities from your service.