Value List Sorting Issue

Classic Servoy
1

Hello,

I have a type ahead value list the displays a calculated value from a related table. I used the calculated field ‘tray_desc’ :
(return tray_class + ’ | ‘+ tray_name +’ | '+tray_int_calc; ) as the display value,

and the’ tray_id’ field as the dataprovider value.

The problem I am having is trying to sort the value list by the display field, I have tried sorting the relation, sorting the value list by the display field, sorting the value list by the individual fields….nothing works.

I can manually sort by that field and it works fine. So it seems to be something with the valuelist.

Is there another way to approach this?

Windows Vista
Servoy
Version: 4.1.3 - build 672

2

Sorting on calculated fields is not supported in Servoy.
This is probably the problem you’ve ran into.

If you would be able to store the calculation (just add a column with the same name as the calculation to the database) sorting is supported and things should work.

Hope this helps!

3

Thanks for the reply… This is a stored calculation. Any other Ideas?