We have a column in paging grid which in DB table stores foreign key of lookup table and on paging grid while displaying we change the values to label values (user readable data ). We need to sort this field in paging grid. is this possible ? (This column is used as drop down in editable grid)
Currently it sorts as per Foreign Key not Alphabetically.
Discussion posts and replies are publicly visible
You may use one of the following two methods:
- Sort the lookup table values alphabetically. So that if you sort the paging grid by that column (say lookup column) it would automatically sort those.
OR
- Create a view by joining those tables and use the view within the paging grid
Hope it helps!
I agree, creating a View is generally the recommended approach, and is probably easiest for this.
Yes i ended up creating view. I was looking for a solution without using view if there is some other way. But view was the only alternative which could be made with least efforts. Thanks for help