Question

Sorting on an enumeration in a data grid

0

I want to sort an enumeration in a data grid. It seems the results are ordered alphabetically on the key of the enumeration, but this is not the way I wish to sort. I realise I can add a prefix to the key to influence the sorting, but this is not an ideal solution: the keys cannot be changed, so this would require creating new keys and a conversion of the current database. How can I get the sorting to work without creating new keys?

asked 2012-07-16

Rom van Arendonk

3 answers

Erwin 't Hoen · Answer 1 · 2012-07-16

Maybe add a second enumeration for the sorting and make sure the values are set with a batch job (can be a microflow, depending on the amount of records we're talking about else do it with java (as you are on 3.3.1). Make sure for new records the second enumeration is set and sort on the second enumeration. This is still sort of a conversion only you're not touching the existing data.

Rom van Arendonk · Answer 2 · 2012-07-17

I've thought about the option to create a second enumeration as well, but it is still a work around.

I'll file a feature request to be able to define the sort order for enumerations without naming the keys.

Rom van Arendonk · Answer 3 · 2012-08-01

Update: I've submitted a feature request to be able to influence the sorting of an enumeration independent from the keys. This feature request has been turned into a bug report by Mendix, and is now nominated for release.