There appear to be many implementations of searching and sorting within tables in the Document360 portal. Within this request I will describe how I feel it should work. It certainly doesn't work this way in Drive. Readers under Users & Security doesn't have sort at all.
Anywhere there is a table within the portal should have this functionality, and it should work consistently.
First, let's discuss filtering ...
Filters should allow the number of rows in the table to be reduced to only include those items that successfully match all of the filter criteria. If 2 filter criteria have been set and a row matches only one of them then the row should not be displayed. The results of this may be 0 rows, or there may be hundreds (or even thousands) of rows.
Only when filters are explicitly cleared should they be removed.
Now let's discuss sorting ...
When rows are displayed in a table, there are naturally column headings. Clicking on a heading should sort ALL ROWS FROM ALL PAGES of results that are available after filtering in ascending order and clicking on it again should reverse the order. Optionally, a third click could clear the sort on that column.
For bonus points, we should be able to sort by multiple columns. A first click of the column heading while holding the Ctrl key should add another column to the sort order. Doing this a second time should invert the sort order for that column. Optionally, a third click while holding the Ctrl key could remove the column heading from the sort order.
It would be great if people could add other areas where a standard sort mechanism should be used so that no areas are forgotten.