I have a datawindow where I sort the data by clicking on the column header. In one of the columns I have a drop-down datawindow attached. Whenever I click this column, the data gets sorted according to the data value. But what I need is to sort the data according to the display value of that column. Is it possible to achieve this?
Unfortunately, PowerBuilder does not support this feature natively. The only way to achieve this would be to add a special section to your code.
In the function that processes the clicked event, check the type of the column being clicked. If it is a drop-down datawindow, you could call a function that performs a sort on the contents of the datawindow child.
To do this, use GetChild to get a handle to the datawindow child and look up the display value for each data value. Then write your own simple bubble sort routine.