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?
Solved
Is it possible to sort a column on it's database value instead of the element translation?
- Captain
- 110 replies
Best answer by Andre te Raa
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 originalI 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?).
This topic has been closed for comments
+5Perhaps you can add a hidden column containing the same data (as a display expression) and sort on it?
- Captain
- 110 replies
- Answer
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 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?).
+5I agree, that would be a good idea!
+11- Captain
- 41 replies
Andre te Raa wrote:
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 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?).
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.