Hi everyone
I'm having an issue with PB 2017 R3 (1858) where a datawindow with an expression in the sort order can't correctly restore that sort order later.
I've attached an example DW Sort Order is as following:
Running the following code on the Datawindow leads to the following output. (the setsort returns 1)
string ls_sort
long ll_ret
ls_sort = dw_1.Describe('Datawindow.Table.sort')
MessageBox("Before", ls_sort )
ll_ret = dw_1.setsort( ls_sort )
ls_sort = dw_1.Describe('Datawindow.Table.sort')
MessageBox("After", ls_sort )
After first describe:
if( isnull( col1 ), 1, 0 ),col1 A,col2 A
After second describe:
if( isnull( col1 ), 1, 0 ),c A,ol1 A,col2 A
If I add a computed field with that expression to the DW and sort by that, everything works as expected. However, we never experienced this problem in 12.5 and 2017 R2.
Can anybody confirm this problem?
https://www.appeon.com/standardsupport/track/view?id=1658