Phenomenon:


If you add an "Ascending" option to the SORT script, this option gets lost.

 


Scenario:


Do a SORT() to a DataWindow like follows:

 

STRING ls_sort

 

ls_sort = "COLUMN_NAME A"

dw_dwcontrol.SetSort(ls_sort)

dw_dwcontrol.Sort()

ls_sort = dw_dwcontrol.Describe("DataWindow.Table.Sort")

 

This will return ls_sort = "COLUMN_NAME" without the "A" for Ascending at the end.

 


Workaround:


Use only lower case letters on the SORT condition. Like follows:

 

STRING ls_sort

 

ls_sort = "column_name a"

dw_dwcontrol.SetSort(ls_sort)

dw_dwcontrol.Sort()

 

ls_sort = dw_dwcontrol.Describe("DataWindow.Table.Sort")

 

This should return ls_sort = "column_name a" without loosing the "A" for Ascending.

1
1