We have a table with more than 6 million 'trade item' records (and a top(1000) set via 'Subjects'). A user is allowed to change the sort order of the screen. Some sort orders will result in a freeze of the screen. The user can't reset the sort order to the default (from the TSF) because the screen won't open anymore. Even when closing and opening it again.
We could disable sorting completely but we don't want that.
The only way to resolve this is deleting the user preference from IAM. But this has to be done by the support department.
It would be a nice addition if we can configure the sort order (made by a user) to reset when opening/closing a screen.