IHasBuildRecords should support advanced browsing

[Celso Providelo]

This feature will allow developers to perform time-aware analysis and build results in the provided contexts (distribution, distrorelease & distroarchrelease)

The main idea is to allow users to restrict build results from time A to time B in addition to the STATE and SOURCENAME.

The timestamp in question will the IBuild.datebuilt for all stable states, unfortunately the provided timestamps won't affect unstable builds (PENDING & BUILDING).

We should also allow the user to type a PACKAGENAME (binary) string which could match resulted binary packages and/or build build dependencies, maybe adding SOURCEVERSION and PACKAGEVERSION to the equation as well.

Finally - the search for source packages should not match substrings, but complete package names only.

[Celso Providelo (cprov)]

For this time I've queried the database manually for Matthias.
The queries were way more complicated than simply adding IBuild.datebuild, they required join over SSPPH and grouping by SPR.
Maybe querying through Binaries (the opposite end) could simplify them a bit.
Everything suggests it's more like an 'Advanced Source/Binary search' than an "Advanced Build Search" itself.

[Kees Cook (kees)]

I would like to answer the question "what am I waiting for?" when looking at a "Needs building" build record. Being able to click a link to see the list of "building" and "pending" jobs for all releases for a given buildd architecture would be nice. For example, instead of just https://edge.launchpad.net/ubuntu/intrepid/hppa/+builds?build_text=&build_state=pending having something like:

 https://edge.launchpad.net/ubuntu/all/hppa/+builds?build_text=&build_state=building,pending

Would rock. :)