Sorting on lookup field in grid

Scriptcase 9 General
#1

In a grid app, is it possible to perform a column sort based on the display values for a lookup field? By default, sorting a column sorts by the underlying integer ID value, not the display text. Thanks.

#2

No, you have to perform the lookup in your SQL statement for the grid.

Select field1, field2, (Select fieldx from table2 …) as field3 from table1 …

Create your grid application based on a statement like this and you will able to sort accordingly.

Cheers
jsb

#3

[QUOTE=jsbinca;14267]No, you have to perform the lookup in your SQL statement for the grid.

Select field1, field2, (Select fieldx from table2 …) as field3 from table1 …

Create your grid application based on a statement like this and you will able to sort accordingly.

Cheers
jsb[/QUOTE]

Thank you!