Sorting with i18n

Classic Servoy
1

I have a list view form that includes one column, a calculation that resolves i18n keys. The i18n keys are stored in a metadata table. Some keys have embedded 18n keys. I need to sort the results of the calculation by default. Is this possible?

e.g.
lbl.First=‘A’
lbl.Second=‘B’
lbl.Third=‘C’
lbl.Fourth=‘D’

When shown, displays:
A
D ← sorts here because the i18n keys are sorting, not the result
B
C

What I need to display:
A
B
C
D

2

In Servoy 3.5 you can override the onSortCmd and add your own sorting. You will need a relation to the messages table and sort over that.

3

Thanks, Patrick. Worked like a charm.

4

After closer examination, the list view is still not sorting correctly. Do you mind clarifying your solution?