Skip to main content
In some cases you want to sort a column on the database value instead of the value of the element translation. This will be faster (index) and is sometimes the order you want (e.g. months).

I know there was a ini. -parameter once, but I don't want this for all columns.

Is it possible to do this for one column? For example based on a domain setting?
Perhaps you can add a hidden column containing the same data (as a display expression) and sort on it?
Hi Robert Jan,

I use an expression column for this, but now I have to do this for each table.

And still when I sort on the 'display' column, it will sort in alphabetical order.

I also could add a number to the translation and force the order, but that doesn't look nice.

It would be great if we could specify this once (for a domain?).
I agree, that would be a good idea!
Hi Robert Jan,

I use an expression column for this, but now I have to do this for each table.

And still when I sort on the 'display' column, it will sort in alphabetical order.

I also could add a number to the translation and force the order, but that doesn't look nice.

It would be great if we could specify this once (for a domain?).




@Andre te Raa Have you put this in as an idea yet?
@Moller Toma not yet, but I will.

Reply