Datagrid with sqlserver view

Is possible show data into Datagrid without using Entity but from a query or view of SqlServer ?

Hi,

yes it is possible. The easiest way to do is to create an entity which has the correct attributes and set the Table name to the corresponding view name of your DB.

Studio has support for creating an entity from a existing view. Check out: CUBA Platform and Studio Release Notes

Using a dataGrid without a view (or at least a domain model with a proper JPQL) is a little harder. I did that once in this application component: GitHub - mariodavid/cuba-component-runtime-diagnose: CUBA component for interactive runtime application diagnose and debugging. You can take a look at the implementation of the SQL console if you are interested.

The implementation worked, but it is a little bit more effort.

Bye
Mario