Summary

A developer asks:

I use a list view rule that is configured to limit records returned to five entries (although at least 100 are in the database).  The view is sorted by Operator ID. 

When the report displays, I click the OperatorID column (to reverse the order of the sort).  How can I force this reordering to reorder based on ALL of the database contents - not just the five that are displayed?

Suggested Approach

Clicking the report heading to re-sort the list executes a JavaScript sort of what is displayed.  It does not affect the sort order of the entire set of results from the database query. 

To affect the latter, you would need to reconfigure your list view (or another), adjusting the criteria and sort specifications to return and display the records in the preferred order.