Sort relation valuelist

Hi
I have a valuelist through a relation
The first option is for select the Id and the second is for show the name
In a table viewe(locked) form, I need sort by the name when I click on the head of the filed but It´s sort by the Id and not by the name
Any idea.

Thanks

Servoy 5.2.9
PostgreSql

Hi JuanMartin

Maybe is obvious, but … have you tried to set the initialSort property int the table form where the data is displayed?

Best regards. Roberto Blasco.

Forget it Juan Martin …

I thought you were talking about the data showed in the table …

Did you try to recover the data through a global method instead a relation?

JuanMartin,

This is a new feature in Servoy 6.1
When a field is shown via a value list (table or related), table view sort will work on the display value in stead of the underlying dataprovider.

For Servoy <=6.0 you can use the onSortCommand on the form.

Rob