Question

Data source with database and with association

0

Hi! I have a templategrid where data source from database entity "Gestiones". But I want to add attributes of an association "Gestiones_Areas". Entities are persistent and have data. However if I edit the running templategrid and select an "Area" it does. Why is this happening? Should I make a microflow to fill in the association?

asked 2020-07-16

Francisco Jiménez

7 answers

Johan Flikweert · Answer 1 · 2020-07-16

Hi Francisco,

I do not fully understand your question. As I interpret your problem is that the Areas information shown for a Gestiones is empty. That suggests indeed that you did not associate the Gestiones with an Areas.

You have created Areas and Gestiones objects? (side note: the naming convention for Mendix is generally the singular form, not plural). How did you set the association? Did you use a reference selector? Are the Areas also managed on a page?

Regards, Johan

Francisco Jiménez · Answer 2 · 2020-07-16

Entities have objects. In fact, if I go into Edit, the reference selector is shown with "Areas" and if I select one, "Areas.Id_Ar" is associated with "Gestiones.Area". But not before doing this. Does not appear when loading templateGrid the first time.

Before Edit:

After selecting Area on the Edit page:

Jeroen van Asten · Answer 3 · 2020-07-16

I also don’t fully understand what your situation is.

You say the entities have data. How did the association get set in the first place? Before looking at it in the template grid?

Maybe this is an entity access issue. Is the user looking at the template grid restricted in any way in if they can read the Gestiones_Areas association?

Rene van Hofwegen · Answer 4 · 2020-07-16

Hi Fransisco, let me try to help you.

At first: Mendix uses ID's to set associations between objects. These ID's are created by mendix and when using the reference selector the (under the hood) ID's of Mendix are used to define the association (join) in the database.

So if you copy on create the "Areas.Id_Ar" into the "Gestiones.Area" that will not define the association. And thus the Area will not be displayed, since the association is still empty.

When you edit the Gestiones and you select an Area, THEN the association is populated using the MENDIX ID's .

Thats the reason why the area is only shown after the edit

Francisco Jiménez · Answer 5 · 2020-07-16

I charge entities as I describe here https://forum.mendix.com/link/questions/101429

I know the entities are not empty. And I would like to introduce "Areas.Area" corresponding to "Gestiones.Area" when presenting the templateGrid. Should I create a microflow to fill Gestiones_Areas? How should I do it?

Rene van Hofwegen · Answer 6 · 2020-07-17

Take a look at this lecture: https://learn.mendix.com/link/module/92/lecture/1615/5.3.3-Configure-the-microflow

Although it describes how to do this in Studio, the same applies in Studio pro

Francisco Jiménez · Answer 7 · 2020-07-17

There must be some way to associate two entities so that when opening the page with templateGrid the associated attributes will appear.

Does anyone know?