sort order options for results.php

[AndyK]

I would like to have the possibility to sort the output of the results.php by the column headers.

Would be great if we could specify more than one criteria. For example:

• First click on a column header makes it 1st order criterion ascending
• Second click on that column header makes it 1st oder criterion descending
• First click on another column header makes it 2nd order criterion ascending
• Second click on that second column header makes it 2nd order criterion descending
• and so on...

And one link/button to eliminate the sorting

[Rytis]

I think this is pretty much impossible with the current database structure, because most columns are not indexed and sorting on them would cause heavy database load, especially with multicolumn sorting.

[AndyK]

Would it be at least be possible to sort by those columns which are already indexed? Multicolumn sorting is not a must.

Actually the out put is sorted only by the 'result ID', but the order of result ID is not always the order in which the results are sent/received.

[AndyK]

sry forget to reopen... (see previous comment)

[Nicolas]

Keyword update

[Nicolas]

The database load caused with sorting couldn't be worse than SETI's "Last one to post here wins" thread (over 200 thousand posts, now deleted) :P

[ohiomike]

If it was sorted by the date sent descending, it would save the users a lot of time clicking through multiple pages to try and find current and recently completed WU's.

[halimedia]

I'm of the opinion that this feature would greatly off-load web- and db-servers. In 95% of all cases, I use results.php to look at the most recently returned results of my hosts. If I could see those with one or two clicks, I'd save the servers a lot of work. Another interesting - albeit less frequently used - feature would be to sort by outcome. My wish here would be to be able to see all WUs that returned errors first with one click. I think this is one of these features that only few people actively request, but a lot of folks would end up using if it were made available. Please make it happen! :)