Order/filter by Aggregate Time Tracking fields in the Issue Navigator

The issue navigator can not be order/filter by the new aggregate fields (time spent, original estimate, remaining estimate & progress) added in 3.11.
It would be nice to be able to order by these fields.

Due to permissions, you can not calculate these aggregates during issue indexing as you may not be able to see some of the sub-tasks and they will be different for users with different permissions. Therefore, if we wanted to filter or order by these fields we would have to calculate it at run time for all issues in the database.
As these fields are calculated by running another Lucene search, a system with 30K issues in would run 30001 Lucene queries for every search done.

Another way to solve this problem is to build a report which would take in a saved filter and the aggregate fields to sort by and do the expensive operation. Not the perfect solution, but it may satisfy the needs of some.

For the time being, you will need to export your results to Excel and then do a sort/filter in there.

If you are voting for this issue, please let us know if you would be happy with the report.