Sort by field display values in the Data window

Sort | data | show
A data window has a field: The person code, now displays it as the person's name in the Ddw method. The question is how to sort by name rather than by encoding.

PB's help in the syntax for sort order shows that Setsort has two sorts of syntax: columnname ordering eg.  "Emp_lname A" "Emp_lname A, dept_id D" # columnnumber order eg. "#3 A"

However, the test found that you can sort by computed columns:

So, add a new computed column compute_1, the expression is Lookupdisplay (emp_id), and then hide it

String Newsort

Newsort = "Compute_1 D"

Dw_1.setsort (Newsort)

Dw_1.sort ()

I hold to try the attitude directly with the expression of the sort, incredibly found also can! I did not think PB also left such a hand:

String Newsort

Newsort = "Lookupdisplay (emp_id) D"

Dw_1.setsort (Newsort)

Dw_1.sort ()

In addition, some netizens say there is a service in Pfc. After the data window opens the Sort service, add Inv_sort.of_setusedisplay (TRUE). This I have not used, for everyone's reference.

Note: This article is originally contained in the Pdriver.com blog.