Show table from data that is not from an entity

Support
#1

We are dynamically creating some tables as configured by users.
Like there is a user_added_columns table where user add col1, its type and other params, col2, its type and params. We analyse the data and create tables programatically from code. Later during some batch operations data is inserted into tables
Now i need to show those data in the jmix as paginated
So consider there is a table in database user_ravi_created_table with columns id, name, age, department etc. And there is about 1000 rows in that table

How can i show the data in UI. Surely i cant create a entity for that because there will be 1000s of table like that.

So basically my question is how to display data from a mysql table that is not an entity in code using table or datagrid

#2

Are dynamically created key-value containers are suitable for your case?

https://docs.jmix.io/1.x/jmix/1.5/ui/data/key-value-containers.html

Regards,
Dmitriy

#3

Here also we need to specify a class name right. This one uiex1_Order. And this one should be there in code right as an entity
“select o.customer, sum(o.amount) from uiex1_Order o group by o.customer”

Basically some how i can manage to get the data like List<String[]> from database.
How can i show it in UI is my dought

#4

In any case, it still looks like a key value container is suitable for displaying your data.

There are examples that can help you:
https://demo.jmix.io/sampler/#main/sample?id=table-key-value
https://demo.jmix.io/sampler/#main/sample?id=datagrid-var-columns

In the case of a key value container, you are not tied to a specific entity.