Within this request I will describe how Filter and Sorting option should work in Tables. Readers and Users 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.