can i make table without entity?

0
NAMEKEY|NAME | AGE                                        --------------------------------------------                                                                       N1|MEN|30                                                 N2|DIX|20   NAMEKEY|SPECIALIZATION | RESULT   -------------------------------------------------------- N1|ANIMAL|DOG N1|FOOD|PIZZA N2|ANIMAL|CAT N2|FOOD|HOTDOG     I want to combine the two tables above into on table like this:   NAME |AGE|ANIMAL|FOOD ---------------------------------------------- MEN|30|DOG|PIZZA DIX|20|CAT|HOTDOG     At this time, the problem is that SPECIALIZATION can be added by users, so the table is fluid and it is not possible to create entities in advance. Can I configure a data source in another way without configuring an entity in the domain?
asked
2 answers
1

Use view entities for that

answered
0

You need to download a grid widget from Marketplace that supports dynamic columns. The old Tree Table widget still works in Mendix 10.12.11. It can retrieve the column structure from a helper microflow. In fact, we never had time to try the similar modern widgets on Marketplace, but I'm sure there are some. See these:

Dynamic Data Grid

Pivot Table Web widget

 

Here's the screenshot from our app page designer

image.png

 

answered