When using the up and down, next and previous, arrows in the header of a record, sometimes the order in which the records are displayed is different from the order in which they are returned. For example, you may see the same record twice in a row, or jump around in the result set, or even occasionally miss records when you have gotten to the end of the list.
Steps to Reproduce
- Navigate to any table with lots of repeating data. Incident and category is a decent place to see this.
- Set rows per page to 20.
- Make sure there are 21 or more incidents in the same category.
- Filter for is.
- Open the first record in a new tab, with the list open to see the order.
- Click the next arrow to walk through the list
The results may or may not be in the right order, may or may not jump around, may or may not skip records.
This fix requires the new glide.secondary.query.sysid system property, default: false set to True in order to get the solution. This adds a secondary sort by sys_id, which ensures these list iterations matches the form values. This property can be added and works in any of the fixed versions listed below.
Related Problem: PRB631935