Getting a historical results report for a product is difficult

Bug #1126449 reported by Nicholas Skaggs
22
This bug affects 4 people
Affects Status Importance Assigned to Milestone
Ubuntu QA Website
Fix Released
Undecided
Daniel Kessel

Bug Description

I would like the ability to give a product and date range and be returned a list of historical results for the product over that date range. This option should exist for 'normal' logged in users at least.

At present there is no way to get a listing of results by flavor / ISO by date range. The current filters are 'Product' and 'Status'. As the list of dailies goes ever longer during a cycle, this takes ages to build and results in an extremely long list when you select 'See removed and superseded builds to'.

Even when you select, just a single product the report lists every iso for every product and takes quite a while to build, causing high cpu usage and potential freezing of the browser/pc. The resulting list is still hard to use because it lacks a date filter.

Related branches

Revision history for this message
Elfy (elfy) wrote :

Currently I'm finding that a date filter exists once I've waited for the list to generate, but trying to use the filter on a list results in

Error
The website encountered an unexpected error. Please try again later.

Pasi Lallinaho (knome)
Changed in ubuntu-qa-website:
status: New → Triaged
Revision history for this message
Daniel Kessel (dkessel) wrote :

The linked branch fixes two issues:

1. It fixes the SQL query created when entering anything into the date range text fields. It previously referred to a non-existing database field.
2. It sets the default date range in all date filters in the website to be "from today minus 31 days until today"

Revision history for this message
Daniel Kessel (dkessel) wrote :

Reference: One long loading report is: iso.qa.ubuntu.com/qatracker/milestones/315/history

Revision history for this message
Daniel Kessel (dkessel) wrote :

Problem with the current solution (reported by elfy): the default search results do not include today.

Changed in ubuntu-qa-website:
assignee: nobody → Daniel Kessel (dkessel)
status: Triaged → In Progress
Daniel Kessel (dkessel)
Changed in ubuntu-qa-website:
status: In Progress → Fix Committed
Changed in ubuntu-qa-website:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.