Sort on a numerical field values which comes from a select field . Sort don't work

Code Examples Grid
#1

Hi all,
I’ve implemented a items list grid where the price field of products come from a select on price_list table specific for each customer.
I was expecting that making that price as sorting column it worked .
If I try to use that column clicking on sorting header field arrow icon nothing happens. The same if I put price field on Sort area as first field to sort.
Does it make sense ???
I’m really surprised !
Bye

#2

You cant’t sort by a custom field you have to include it in the sql statement of the grid.

jsb

#3

Thanks Jsb … as always thanks so much.
That’s a pity but probably it makes sense… ;-(