Question

Sorting columns in datagrid with data from association

0

I have a table in a datagrid with normal attributes and values of an association. Sorting (asending/descending) does not seem to work for the columns of the table from the association. I also have empty cells in the columns. Does anyone know what the problem could be? How can I arrange that the columns can be sorted (with the arrows in the top row of the columns)?

asked 2016-04-25

Maartje Wammes

2 answers

1

Maartje,

I created a little test for this and saw that the sorting does work, however the empty values will always be sorted a the first item. I created 2 entities, one for the normal attributes and one for the association. Created associated records with attribute values a and b. When adding the records for the entity containing the association, I created 3 record. One with association to record a, one with b and one without an association. When sorting in the datagrid I saw a and b switching order (first a then b, then b before a), but the record with the null value for the association will remain the first record. This seems to be intended behavior as the null values need to be sorted differently, see for example a java question on sorting nulls here

answered 2016-04-25

Erwin 't Hoen

Dexx · Accepted Answer · 2016-04-26

Is the association in question perchance a self-reference? One that runs from the top-level entity to the same entity? Because sorting over references has always been a questionable proposition in Mendix. If sorting is absolutely necessary you should probably try to avoid self-references altogether.