When running a query directly from the edit view it works fine, but in "View Mode" it doesn't work.

What can one do to see results sorted by multiple criteria?