When executing a query, I receive the first 100 results because Enable Autopaging in Results is check in the options. If I have a result set that contains more than 100 results and re-order the results based on the Primary key so that the result set is in descending order I have to navigate to the second page of the result set to see the records with greater Primary key IDs.
That seems counter-intuitive since I want to see the results on the first page that have the greatest primary key ID (of all records in the table) when re-ordering rather it seems like the re-ordering is one only based on the 100 records on that particular page.
Maybe a condensed example would illustrate the issue. Say the results are limited to 5 rows by the Autopaging setting and there are 10 records in the table with primary keys 1 through 10. If executing “select * from
” the first 5 results are returned with Primary key IDs 1 to 5 displayed (6 to 10 would be found on the second page). If I then re-order the results on the first page with IDs 1 to 5 displayed by clicking the Primary key column so that the results are descending I would expect the records with Primary key IDs 10 to 6 to be displayed, rather records with IDs 1 to 5 are reordered from 5 to 1.
It seems like that re-ordering the results by clicking on a column name only changes the order of the results displayed on that particular page rather than executing the query again with the order changed according to the selected column.
Is there a way to get the results displayed the way I am expecting?
