{{extension |name=BugzillaReports |author=[[User:Ian Homer|Ian Homer]] |type=parser function |version=1.1 |update=July 7th, 2009 |status=stable |mediawiki=1.13 |license=GPLv2 |description=Generate bugzilla reports |download=[http://blog.bemoko.com/bugzillareports/ BugzillaReports] }} '''BugzillaReports''' generates great looking reports from [[Bugzilla]] which you can include in your [[MediaWiki]] pages (or in fact any PHP application). Great to provide access to Bugzilla info, for example:
Displays dependency reports, last comments on bug on hover over, supports interactions with voting & flagging and helps you to see what needs to be done next. Read below for more bells and whistles. Makes reporting on your bugs much easier than through the standard Bugzilla search UI. It's your controlled window onto Bugzilla ...
[[Category:Bugzilla]]
See [http://blog.bemoko.com/2008/06/28/bugzilla-reports-for-mediawiki here] for an active discussion thread on this extension.
''I expect to release [[#Roadmap|v0.9.8]] within the next week. If you have requests for what will be included in the release after this one then email me at bugzillareports -at- bemoko.com if you want to add anything to this list (or ... find any bugs). I'm also preparing the v1.0 (stable) release. For this v1.0 release I'd welcome any corrections updates to this page to get these docs up to date - lots of features have gone in the past few months that documented in the release notes at the bottom of this page, but not in the "learn by examples" below. Anyone who does some updates to the docs will get in the credits.'' --[[User:Ian.homer|Ian Homer]] 22:20, 29 November 2008 (UTC)
=Pre-requisites=
=Installation=
Add the following to your LocalSettings.php file:
require_once("$IP/extensions/BugzillaReports/BugzillaReports.php"); $wgBugzillaReports = array( 'host' => "localhost", 'database' => "bugzilla", 'user' => "user", 'password' => "(your password)", 'bzserver' => "http://host" );
or if you want to use [[interwiki]] links (which is recommended and worth the extra effort of setting up)
... 'interwiki' => "bugzilla" ...
where parameters are defined as follows:
==PostgreSQL==
$wgBugzillaReports = array( 'host' => "localhost" 'dbdriver' => "pg", 'database' => "bugzilla", 'user' => "bugs", 'password' => "password", ... );
=Example Output=
[[Image:bugzilla-reports-screenshot3.png|Bugzilla Report]]
Note that the bubble appears as you roll over a bug that has a last comment set.
=Usage=
: ''Note that several features are described in the release notes below and have not yet been documented in this section. I anticipate reflecting these changes in the documentation prior to the v1 release. Apologies for this gap in information, it should only be temporary'' --[[User:Ian.homer|Ian Homer]] 22:10, 21 October 2008 (UTC)
==By Example== Generate a report from Bugzilla based on search criteria, e.g.
[[Image:bugzilla-reports-screenshot1.png|Bugzilla Report|right]]
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.
{{#bugzilla:}}
Report on P3 and higher bugs
{{#bugzilla: |priority=P1,P2,P3 }}
Report on a particular product version
{{#bugzilla: |product=myproduct |version=1.3 |lastcomment=1 }}
Report on specific bug ids
{{#bugzilla:id=30,56,78,93}}
[[Image:bugzilla-reports-screenshot2.png|Last Comment Bubbles|right]] Report on all enhancements with the text wiki in the summary with last comment bubbles
{{#bugzilla: |search=wiki |severity=enhancement |header=hide |lastcomment=1 }}
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
{{#bugzilla:status=!NEW}}
Everything except P1 and P2 bugs
{{#bugzilla: |priority=!(P1,P2) |status=* }}
Set the message when no results are returned
{{#bugzilla: |product=doesntexist |noresultsmessage=all tasks complete }}
Tasks with votes against them
{{#bugzilla:columns=+votes|votes=+}}
[[Image:bugzilla-reports-screenshot4.png]]
{{#bugzilla: |group=deadline |groupformat=radar }}
[[Image:bugzilla-reports-screenshot5.png]]
{{#bugzilla: |group=version |bar=status }}
All tasks created by me but not assigned to me
{{#bugzilla:columns=+to|from=me@bemoko.com|to=!me@bemoko.com}}
All tasks I'm cc'd on but not created by me and not assigned to me
{{#bugzilla:columns=+to,+from |to=!me@bemoko.com |from=!me@bemoko.com |cc=me@bemoko.com}}
Display list in a format that's handy for cutting and pasting into emails
{{#bugzilla:format=list}}
for example:
: [IHO] (2008-07-22) Do something (#19) : [IHO] (2008-07-25) Do something else (#45) : [JBL] Don't forget this (#54)
===Task Radar===
{{task radar|me@bemoko.com}}
where task radar is defined as:
=Flagged= {{#bugzilla:flag={{{1}}}|lastcomment=1|noresultsmessage=No tasks flagged}} =Up & Coming= {{#bugzilla:to={{{1}}}|columns=-version,+deadline|deadline=+|group=deadline|groupformat=radar|lastcomment=1|noresultsmessage=Nothing up & coming}} =My Product Priority Radar= {{#bugzilla:to={{{1}}}|lastcomment=1|product=myproduct|noresultsmessage=Nothing to do on myproduct}} =Voted Tasks= {{#bugzilla:to={{{1}}}|columns=+deadline|group=product|votes=+|noresultsmessage=None of your tasks have received votes}} =Raised= {{#bugzilla:from={{{1}}}|to=!{{{1}}}|noresultsmessage=You have not raised anything}} =CC= {{#bugzilla:to=!{{{1}}}|from=!{{{1}}}|cc={{{1}}}|noresultsmessage=No ccs}} =Other Priority Radar= {{#bugzilla:to={{{1}}}|product=!myproduct|group=product|noresultsmessage=Nothing else to do}}
==Parameter Usage==
{| style="-moz-border-radius:8px;border: 1px solid #f0f0f0;border-spacing:0px;width: 80%;margin:auto" |- style="vertical-align:top; background-color: #c0c0c0;" ! parameter ! style="width:30%" |values ! description |- style="vertical-align:top;" | '''alias''' | alias value(s) | alias query field |- style="vertical-align:top; background-color: #f0f0f0;" | '''bar''' | column name | field to summarise in a bar chart - note that this also works in conjunction with the group parameter to provide a set of bar charts. |- style="vertical-align:top;" | '''blocks''' | id of blocking task (or "" to include blocking tasks inline) | blocks query field |- style="vertical-align:top; background-color: #f0f0f0;" | '''cc''' | single username | Query for any task cc'd to the specified username, only supports single value |- style="vertical-align:top;" | '''columns''' | id, cc, deadline, modified, priority, product, severity, status, summary, to, version, estimated, remaining | comma separated list of columns to display in the specified order |- style="vertical-align:top; background-color: #f0f0f0;" | '''component''' | component name | component query field |- style="vertical-align:top;" | '''deadline''' | "" ⇒ (any), "+" ⇒ (set) | deadline query field |- style="vertical-align:top;background-color: #f0f0f0;" | '''debug''' | true | Set to enable debugging - outputs SQL at end of table |- style="vertical-align:top;" | '''depends''' | id of dependent task (or "*" to include dependent tasks inline) | dependent query field |- style="vertical-align:top;" | '''dependsstatus''' | status query field | Specify criteria for display depends (and blocks rows), e.g. dependsstatus=!(CLOSED,VERIFIED) will not display CLOSED and VERIFIED tickets in dependency or blocks report. It defaults to !(CLOSED,VERIFIED,RESOLVED) |- style="vertical-align:top; background-color: #f0f0f0;" | '''detailsrow''' | ''same as values for columns'' | comma separated list of columns to display in the specified order on a second row |- style="vertical-align:top;" | '''flag''' | username, e.g. me@bemoko.com | search for all tasks flag for the specified user |- style="vertical-align:top;" | '''group''' | any column name as described in the columns field | field to group report on |- style="vertical-align:top;background-color: #f0f0f0;" | '''groupformat''' | radar (headings set to relative date names, e.g. today, tomorrow, next week) | format to be applied to group headings |- style="vertical-align:top;" | '''grouporder''' | (same as order parameter) | order for group sorting |- style="vertical-align:top;background-color: #f0f0f0;" | '''heading''' | any text | Heading to display above table (if there are tasks displayed in the report) |- style="vertical-align:top;" | '''headers''' | hide | Set to '''"hide"''' to hide the header row |- style="vertical-align:top;background-color: #f0f0f0;" | '''hide''' | true | Hide all detail rows, useful in conjunction with totals (and perhaps group) to just display sub-totals |- style="vertical-align:top;background-color: #f0f0f0;" | '''id''' | ''bugzilla id'' | ID query field |- style="vertical-align:top;" | '''lastcomment''' | 1 | display the last comment for each bug |- style="vertical-align:top;background-color: #f0f0f0;" | '''maxrows''' | any integer less than that configure in the LocalSettings.php configuration | Maximum number of rows to return |- style="vertical-align:top;" | '''maxrowsbar''' | any integer less than that configure in the LocalSettings.php configuration | Maximum number of rows to return in calculation of bar reports |- style="vertical-align:top;background-color: #f0f0f0;" | '''milestone''' | milestone value(s) | milestone query field |- style="vertical-align:top;" | '''noresultsmessage''' | any text messag | Set the message when there are no results matching the query |- style="vertical-align:top;background-color: #f0f0f0;" | '''nameformat''' | "real" (default), "login" or "tla" | format of names, either real name, e.g. Ian Homer, login name, e.g. blah@blah.com, or three letter acronym, e.g. IHO |- style="vertical-align:top;" | '''order''' | desc (or asc) | sort order, defaults to asc |- style="vertical-align:top;background-color: #f0f0f0;" | '''priority''' | P1,P2,P3,P4,P5 | priority query field |- style="vertical-align:top;" | '''product''' | ''bugzilla product names'' | product name query field |- style="vertical-align:top;background-color: #f0f0f0;" | '''quickflag''' | 1 | If flag is set against task then identify with a small "?" next to the ID which displays more info on hover over |- style="vertical-align:top;" | '''search''' | ''anything'' | free text search - only searches short_desc at the moment |- style="vertical-align:top;background-color: #f0f0f0;" | '''severity''' | blocker, critical, major, normal, minor, trivial, enhancement | severity query field |- style="vertical-align:top;" | '''sort''' | any column name (or comma separated list of column names) as described in the columns field | field to sort on |- style="vertical-align:top;background-color: #f0f0f0;" | '''status''' | NEW,ASSIGNED,UNCONFIRMED,REOPENED,RESOLVED,VERIFIED,CLOSED | status query field, note that this defaults to !CLOSED |- style="vertical-align:top;" | '''to''' | a valid username, e.g. me@bemoko.com | assigned to query field |- style="vertical-align:top;background-color: #f0f0f0;" | '''total''' | any column name (or comma separate list of column names) | columns to display a total at the bottom. For non numberic columns it just displays a count of the rows |- style="vertical-align:top;background-color: #f0f0f0;" | '''version''' | ''bugzilla version name/number'' | version query field |- style="vertical-align:top;" | '''votes''' | "+" ⇒ display any task with votes against it | votes query field |}
All query fields can take the following constructs
==With Semantic MediaWiki==
This extension works well with the [http://semantic-mediawiki.org/wiki/Semantic_MediaWiki Semantic MediaWiki] by
=Troubleshooting=
If you are having any issues with the use of this extension please
=Roadmap=
: v0.9.8, with the features described below, is currently undergoing regression testing on our company environment, expect a release in the coming week --[[User:Ian.homer|Ian Homer]] 22:17, 29 November 2008 (UTC)