Bug#695772: bugs.cgi: allow filtering based on unblock/approve hints

[Ivo De Decker <ivo.dedecker@ugent.be>]

Hi,

On Wed, Dec 12, 2012 at 05:01:28PM +0100, Niels Thykier wrote:
> > Please allow the possibility to filter bugs based on unblock or approve hints
> > by the release team. The attached patch frovides these filters.

> Good idea. :)

> I'd probably merge them into one entry as "approve" is (for most
> practical purposes) "unblock for tpu" uploads[1].

New patch attached.

And thanks to Adam for the history wrt unblock vs approve.

Cheers,

Ivo

diff --git a/web/bugs.cgi b/web/bugs.cgi
index 211f78d..ba0fa76 100755
--- a/web/bugs.cgi
+++ b/web/bugs.cgi
@@ -47,6 +47,7 @@ FILTERS = [
  ['rtwheezy-will-remove', 'RT tag for wheezy: will-remove', "id in (select id from bugs_usertags where email='release.debian.org@packages.debian.org' and tag='wheezy-will-remove')"],
  ['rtwheezy-can-defer', 'RT tag for wheezy: can-defer', "id in (select id from bugs_usertags where email='release.debian.org@packages.debian.org' and tag='wheezy-can-defer')"],
  ['rtwheezy-is-blocker', 'RT tag for wheezy: is-blocker', "id in (select id from bugs_usertags where email='release.debian.org@packages.debian.org' and tag='wheezy-is-blocker')"],
+ ['unblock-hint', 'RT unblock hint', "source in (select source from hints where type in ('approve','unblock'))"],
 ]
 
 TYPES = [