Extension:Bugzilla Reports

BugzillaReports generates great looking reports from Bugzilla which you can include in your MediaWiki pages. Great to provide access to Bugzilla info, either from an access control point of view or providing reports easier for non-techies to read. Supports interactions with voting & flagging and helps you to see what needs to be done next. It's like your controlled window onto Bugzilla ...

=Installation=


 * 1) Download the extension bundle from BugzillaReports
 * 2) Unpack bundle into your extensions directory.  This should give you
 * BugzillaReports/BugzillaReports.i18n.php
 * BugzillaReports/BugzillaReports.php
 * BugzillaReports/skins/bz_main.css
 * etc

Add the following to your LocalSettings.php file:

or if you want to use interwiki links (which is recommended and worth the extra effort of setting up)

where parameters are defined as follows:


 * 1) host &rArr; defaults to localhost, but if Bugzilla not on same machine as your mediawiki install then set the hostname here
 * 2) Use one of
 * 3) bzserver &rArr; point to bugzilla server e.g. http://host".  Note that the path "/show_bug.cgi?id=" is automatically added for you by the extension
 * 4) interwiki &rArr; interwiki prefix linking to bugzilla instance
 * For example set up interwiki prefix of bugzilla to point to URL http://host/show_bug.cgi?id=$1
 * 1) maxrows &rArr; set maximum number of rows to display (defaults to 200)

Note: MySQL support only at the moment, but PostgreSQL support will follow shortly.

=Example Output=



Note that the bubble appears as you roll over a bug that has a last comment set.

=Usage=

By Example
Generate a report from Bugzilla based on search criteria, e.g.



List all open bugs - note that status defaults to NEW,ASSIGNED,UNCONFIRMED,REOPENED and maximum of 200 rows (by default) are returned. Results are sorted by priority.

Report on P3 and higher bugs

Report on a particular product

Report on specific bug ids

Report on all enhancements with the text wiki in the summary with last comment bubbles

Setting the lastcomment parameter will generate a report which renders the last comment in bundles in bubbles as you hover each row (see image left) This has been tested on Firefox 3 and Safari 3, but this option may have issues with other and older browser. I'd be happy to hear feedback on this feature.

Report on all bugs that are not new

Everything except P1 and P2 bugs

Set the message when no results are returned

Tasks with votes against them





All tasks created by me but not assigned to me

All tasks I'm cc'd on but not created by me and not assigned to me

Task Radar
where task radar is defined as:

Parameter Usage
All query fields can take the following constructs


 * value - single value to match
 * value1,value2, value3 - comma separate list of value to match
 * !value - match on everything except value
 * !(value1, value2, value3) - match on everything except the listed values
 * * - match on everything (useful to override inbuilt default of status)

With Semantic MediaWiki
This extension works well with the Semantic MediaWiki by


 * 1) tagging your page with a property, e.g. task::52
 * 2) and then passing the results of semantic search into the bugzilla reports function, e.g.

=Release Notes=

v0.7 - 4th July 2008

 * Regression Warning : There were some inconsistencies and bugs relating to the naming fields in query field parameters, sort parameters and column parameters. This naming has been simplified and made consistent, however it does mean that the use of functions should be adjusted inline with this release.  Naming is now as follows:
 * status (instead of bug_status), severity (instead of bug_severity), id (instead of bug_id), summary (instead of short_desc)
 * Warnings now output to page to make troubleshooting easier
 * Implicitly add column to provide url associated with task. Column doesn't have a header so if no rows have urls then nothing shows up.
 * Provide support for last modified with the parameter, modified=+ or sort=modified|order=desc
 * Added group feature, e.g. group=product to group the report into different products, including groupformat=radar to render headers for dates as today, tomorrow, this week etc ...
 * Added experimental bar chart feature - e.g. bar=priority groups all rows into a bar chart of different priorities. I say experimental, since doesn't look great yet, but it's functional.

v0.6 - 1st July 2008

 * Fix setting of implicit sorting when some query fields set
 * Fix bug relating to array_fill_keys mandating two parameters

v0.5 - 1st July 2008

 * Optimise SQL to only do joins when needed
 * Support search on component name, component=mycomponent
 * Support for vote reporting, columns=+votes to include votes column and votes=+ to display only tickets with votes against them
 * Significant refactoring to make extension easier to maintain and to allow further DB integrations to be developed (including abstractions from mediawiki) - I expect to do be doing a vTiger MediaWiki extension in the coming months, and I've had feedback that people would like to run this functionality outside of mediawiki.
 * Implicit sort and ordering based on query parameters if no explit sort and ordering set, for example if you say you want to list all rows with deadline set, then sorting will be on deadline (unless explicitly set otherwise)
 * Support for "from","to" and "cc" meaning respectively who raised the ticket, who's it assigned to and who's cc'd
 * Renamed column and query field login_name to "to" (requires changes to any function calls which make reference to login_name)
 * Support for reporter query field and column, e.g. from=me@bemoko.com and columns=+from
 * Support for query field on cc, but note that comma separated and not operators are not supported for this field.
 * Implicity remove columns if query set for a single value, i.e. all values in the column would be the same
 * Implicity add columns if query set for not null, e.g. votes=+ or deadline=+ would implicitly add the deadline and votes column
 * Support query for flagged tasks, e.g. flag=+me@bemoko.com
 * Make sort on deadline put earliest date first and nulls at end

v0.4 - 30th June 2008

 * Fix query for free text match - using search parameter
 * Changed default status to !CLOSED
 * Default maxrows changed to 100
 * Support maxrows as parameter into function call (as well as server config max) - note function call value can't be higher than server config value
 * Support spaces in comma separated query list
 * Default columns changed to "bug_id,priority,bug_status,bug_severity,version,name,short_desc" with login_name removed
 * Support adding and removing columns from the default by using "column=+deadline" or "column=-name", or "column=+deadline,-name"
 * Support sort, e.g "sort=deadline" and ordering "order=desc"
 * Support search for deadline set "deadline=+" and deadline not set "deadline=-"
 * Change "name" column to "product" to make it more obvious and consistent

v0.3 - 26th June 2008

 * Improve UI rendering of lastcomment bubbles
 * Fix the css to get tables rendered better
 * Improved error handling of mysql_query

v0.2 - 26th June 2008

 * Render last comment for a bug in jQuery bubble - use the lastcomment parameter
 * Support for negation of query fields
 * Installation download bundle provided

v0.1 - 25th June 2008

 * Baseline reporting functionality