Sorting columns in table view

Servoy 2.0 beta 6

In a form I have a tabpanel that contains a form in table view. clicking on a column header the rows are sorted according with the column selected, but if some values of the column are empty (null or blank) the corresponding rows dissapears :?:

Thank you in advance

Was there a solution to this problem ?

Have just found exactly same behaviour.

Have Products table with tabpanel showing Product_Transactions. Tabpanel table uses relationship to Product_ID and Transaction_Type.

Works perfectly and sorting is not a problem unless some items in column are blank then all data disappears when trying to sort. Changing to different Transaction_Type then back again sometimes shows data but usually have to select a different Product first then go back.

Servoy Developer
Version R2 2.1.2-build 315
Java version 1.4.2_06-b03 (Windows XP)

Thanks

GrahamG

This is expected (though maybe unwanted) behaviour. The behaviour is due to to the kind of join that is used. See for example this thread Clicksort, table, related fields - Classic Servoy - Servoy Community

Thank you Patrick - my searches of the Forum had missed this one.

Happy New Year

GrahamG