I have a view object with a query using an order by with 3 items.
I use a rangeChangeListener with rangeSize 10 to display 10 rows in a table.
Requery condition is set to 'After commit'.
I can select a row in the table and edit the row in form layout. After making some changes and committing the changes I use the breadcrumb to return to the table layout.
Now I have an issue with the order by of the query. The data in the table is not correctly sorted.
Using the same table with rangeSize -1 (= disabling the table range) I do not have this issue.
Have you noticed if, when you go back to the table view, the row you had selected for editing is always in the first row? i.e. if the initial order of the rows is A, B, C and you edit row B, when you come back to the table are they ordered as B, A, C? Or is it random?