Building search queries in Bugzilla

This is mostly a self-note but heck, maybe someone will reach this post via Delver (or Google :)), so I’m all about sharing.

Anyway, we’re using (for now) Bugzilla and I tried to get all the “open” bugs for my team with status equal to X,Y,Z.

Sounds easy right? well, you are … sadly mistaken.
After investing 15 minutes banging my head into the nearest wall with “Bugzilla Advanced Serach” (well, I’ll be polite and say it’s “advanced” alright), I gave in on that one.
Instead, I hacked the url a bit to understand the dark voodoo of Bugzilla and voila, 2 minutes later:

http://qabugz/cgi-bin/bugzilla/buglist.cgi
?bug_status=NEW
&bug_status=ASSIGNED
&bug_status=REOPENED
&assigned_to=Joe
&assigned_to=Joe2
&assigned_to=Joe3
&query_format=specific
&field0-0-0=bug_status
&field0-0-1=assigned_to
&type0-0-0=anyexact
&type0-0-1=anyexact
&order=bugs.bug_severity

Just remove the “break line” of course (this is easier to edit) and replace “Joe” with your favorite developer name.

If you want to make it a bit more complex, here is a nice site with the supported field names:
http://pkp.sfu.ca/bugzilla/page.cgi?id=quicksearchhack.html

 

Anyway, I hope it will help someone.

* geeky btw – notice the funny “binary index” of the fields! made me laugh quite a bit, being the geek that I am.

 

Oren Ellenbogen