Announcement

Collapse
No announcement yet.

Sorting on lookup field in grid

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Sorting on lookup field in grid

    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

    Comment


    • #3
      Originally posted by jsbinca View Post
      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
      Thank you!

      Comment

      Working...
      X