981854 - Make the reports tab info sortable across multiple pages of report listings

Status: RESOLVED FIXED

(Socorro Graveyard :: Middleware, enhancement)

Description

[Liz Henry (:lizzard)]

For some crash signatures, there are many pages of information in the Reports and Table tabs. For example, this signature has 700+ pages of data:

https://crash-stats.mozilla.com/report/list?product=Firefox&signature=sse2_composite_src_x888_8888#tab-reports

These pages within these tabs have sortable headers on the columns. We frequently sort the tables by build ID or product or some other header. But, the columns only sort based on the data visible on that page.  

It would be useful to some of us in QA who look at crash reports, if the sorting worked across all the crash reports on all the pages.

Comment 1

[Peter Bengtsson [:peterbe]]

I too have long wondered about that. What's the point of sorting a subset?!

I think if we were to make these tables work nicely we should be able to go to the next page (pagination) or click the column headers (change sort order) these should all go AJAX without having to refresh the whole page with all the other tabs.

Comment 2

[Robert Helmer [:rhelmer]]

(In reply to Peter Bengtsson [:peterbe] from comment #1)
> I too have long wondered about that. What's the point of sorting a subset?!
> 
> I think if we were to make these tables work nicely we should be able to go
> to the next page (pagination) or click the column headers (change sort
> order) these should all go AJAX without having to refresh the whole page
> with all the other tabs.

Yeah this is something we noticed and thought about when the site was rewritten from PHP->Django, but the goal then was about matching parity with the old site vs. expanding features so we left it (also nobody had asked until now AFAIK). We'll need to make a round-trip to the DB and the cache hit will probably be abysmal, but I think it's worth it.

Comment 3

[Peter Bengtsson [:peterbe]]

PR https://github.com/mozilla/socorro/pull/1980

Comment 4

[[github robot]]

Commit pushed to master at https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/f5056bc7e091c13cbe8374ac99dd3a27ceed0b6d
fixes bug 981854 - make reports tab paginate and sort with AJAX, r=AdrianGaudebert