Getting a historical results report for a product is difficult

[Nicholas Skaggs]

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.

[Elfy (elfy)]

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.

[Daniel Kessel (dkessel)]

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"

[Daniel Kessel (dkessel)]

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

[Daniel Kessel (dkessel)]

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