BugzillaQueryPlugin

This plugin allows you to make links to Bugzilla or directly query Bugzilla for data and results could be formated. I take a vision from BugzillaLinkPlugin? but it doesn't fulfil all needs of our company.

---

THIS VERSION OF PLUGIN WORKS FINE WITH BUGZILLA 2.16.x OR LATER!!

---

Syntax Rules

• %BGQ{"12"}%
• %BGQ{"12, 25, 200"}%
• %BGQ{data="on" bug_status="NEW, ASSIGNED, REOPENED" product="xxx" target_milestone="yyy"}%

Allowed attributes

Attributes are named by columns in 'bugs' table in DB. It means you can use attributes "bug_id", "bug_status", "reporter", "target_milestone" etc. If you need to search by keywords then use attribute "keyword".

There are these 'special' attributes:

• data - if set to "on" you get directly data from database
• format - you can specify the output

Syntax and variables in 'format' attribute

You can use the same naming conventions as for attributes and put before it the character '$'.

Examples:

• format="| $bug_id | $bug_status | $assigned_to |"

123	NEW	an_user@bugzilla.com
234	RESOLVED	another_user@bugzilla.com

• format="Bug $bug_id is in status $bug_status and was assigned to $assigned_to" Bug 123 is in status NEW and was assigned to an_user@bugzilla.com
  Bug 234 is in status RESOLVED and was assigned to another_user@bugzilla.com

Examples

• %BGQ{"12"}%
• %BGQ[bug_id="12"]%
• %BGQ{"12, 25, 200"}%

%BGQ{bugstatus="NEW, ASSIGNED, REOPENED" product="xxx" milestone="yyy"}%

BugzillaQueryPlugin Settings

• • Set URL = http://reportes.gsiempre.com
  • Set FORMAT = | $bug_id | $assigned_to | $creation_ts | $deadline | $priority | $short_desc |
  • Set SHORTDESCRIPTION = Plugin para mostrar datos de la pagina del Bugzilla.
  • Set SHOWBUGSCRIPT = show_bug.cgi
  • Set BUGLISTSCRIPT = buglist.cgi
  • Set BUGZILLA_DB_HOST = localhost
  • Set BUGZILLA_DB_PORT =
  • Set BUGZILLA_DB_NAME = bugs_srv_sistemas
  • Set BUGZILLA_USER = bugs
  • Set BUGZILLA_PASSWD = bugs
  • Set DEBUG = 0

Plugin Installation Instructions

Extract BugzillaQueryPlugin.zip, edit the BugzillaQueryPlugin to your needs and have fun.

Files

• lib/TWiki/Plugins/BugzillaQueryPlugin.pm
• data/TWiki/BugzillaQueryPlugin.txt

Plugin Info

Plugin Author:	RichardBaar?
Plugin Version:	1.03
Change History:	23 Feb 2004: Added keywords and remote machine support
CPAN Dependencies:	DBI
Other Dependencies:	none
Perl Version:	5.0
Plugin Home:	http://TWiki.org/cgi-bin/view/Plugins/BugzillaQueryPlugin
Feedback:	http://TWiki.org/cgi-bin/view/Plugins/BugzillaQueryPluginDev

Related Topics: TWikiPreferences, TWikiPlugins

-- RichardBaar? - 23 Feb 2004