PB Data Window drop-down Data window column sorting (translation)

DataWindow is a powerful and extensible tool, a great feature that allows users to click on the column header to sort the columns in the DataWindow.

The sort feature also allows you to specify columns to sort the data window, which is available for most columns, but he cannot sort the columns with the drop-down data window. The reason is

This sort of function is sorted by the value of the column rather than by the display value.

The solution to this problem is to use the Lookupdisplay function, which returns the displayed value of the column, sorted by the Lookupdisplay (column name) function.

The data window will be able to sort the display values.

Dw_1.setsort (' Lookupdisplay (dept_id) ') Dw_1.sort ()

PB Data Window drop-down Data window column sorting (translation)