Bugzilla Reporting

Question

Is there a really good free tool for BugZilla reporting? I am finding the default search options on the web interface far too limiting. My biggest issue is with the lack of Order By options (only 1 field at a time, and a very limited set of fields to choose from). I have done some Google searches, but I can't find any good free BugZilla reporting tools.

If there isn't one, can someone please point me to an example on how to access the BugZilla web services? If I can get the BugZilla data, then I can easily build my own reports that will better meet our needs.

Answer 1

Take a look at this: http://www.faqs.org/docs/bugzilla/dbdoc.html

Use this database schema for reference: faqs.org/docs/bugzilla/dbschema.html

If you need a web-interface, use your favorite dynamic website scripting language that can access MySQL databases (say PHP)...

Simple-ish Tutorial: freewebmasterhelp.com/tutorials/phpmysql/4

PHP MySQL API Reference: php.net/manual/en/ref.mysql.php

Then use SQL queries such as: "SELECT * FROM bugs WHERE WHERE bug_status != 'RESOLVED' ORDER BY creation_ts ASC, votes DESC LIMIT 50" which lists first 50 entries of unresolved bugs ordered first ascending creation time then descending by number of votes.

Answer 2

I have used this in the past and have liked it a lot: http://www.mediawiki.org/wiki/Extension:Bugzilla_Reports