Entity from existing View

Support
#1

Hello,

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?

Greets

1 Like
#2

Hi,

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.