Link to home
Start Free TrialLog in
Avatar of srinib
srinib

asked on

Sorting on display value

I have a sort functionality on clicking DW headers. There is one column which has code value and display values. When sorting it is sorting on code values, but i need to sort on display values.

Any suggestions??

Thanks in advance
Srinib
ASKER CERTIFIED SOLUTION
Avatar of Lordain
Lordain
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Greg Mills
Greg Mills
Hello Lordain,

Do you know if it is possible to use the LookUpDisplay function within a datawindow SetSort function? For instance, dw_v.SetSort("LookUpDisplay(column9) A")?

The sort seems to always use the DataColumn value rather than the DisplayColumn when actually executing the sort. When I add code to the window to view the actual data in the dropdowndatawindow using Describe, it is correct, and I can also use the LookUpDisplay fuction to pull the values from the child dddw and see them in a log file generated when running the window, but the sort seems to ignore the LookUpDisplay function.

Thanks for any advice.