Solved

Is it possible to sort a column on it's database value instead of the element translation?

  • 5 April 2019
  • 5 replies
  • 162 views

Userlevel 3
Badge +6
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?
icon

Best answer by Andre te Raa 15 April 2019, 16:17

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?).
View original

5 replies

Userlevel 4
Badge +1
Perhaps you can add a hidden column containing the same data (as a display expression) and sort on it?
Userlevel 3
Badge +6
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?).
Userlevel 4
Badge +1
I agree, that would be a good idea!
Userlevel 5
Badge +9
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?
Userlevel 3
Badge +6
@Moller Toma not yet, but I will.

Reply