Tags:
bugs1Add my vote for this tag database1Add my vote for this tag integration1Add my vote for this tag create new tag
, view all tags

BugzillaQueryPlugin

Display links or data results from Bugzilla

Introduction

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 TWiki:Plugins.BugzillaLinkPlugin but it doesn't fulfill all needs of our company.

Syntax Rules

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

Supported 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@bugzillaPLEASENOSPAM.com
234 RESOLVED another_user@bugzillaPLEASENOSPAM.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{data="on" bugstatus="NEW, ASSIGNED, REOPENED" product="xxx" milestone="yyy"}%

BugzillaQueryPlugin Settings

  • Set URL = https://marvin.in.idoox.com/bugzilla/
  • Set FORMAT = | $bug_id | $bug_severity | $priority | $bug_status | $resolution | $reporter | $product | $short_desc |
  • Set SHORTDESCRIPTION = Display links or data results from Bugzilla
  • Set SHOWBUGSCRIPT = show_bug.cgi
  • Set BUGLISTSCRIPT = buglist.cgi
  • Set BUGZILLA_DB_HOST =
  • Set BUGZILLA_DB_PORT =
  • Set BUGZILLA_DB_NAME = bugs
  • Set BUGZILLA_USER = guest
  • Set BUGZILLA_PASSWD =
  • 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: TWiki:Main.RichardBaar
Copyright: © 2004 TWiki:Main.RichardBaar,
© 2004-2010 TWiki:TWiki.TWikiContributor
License: GPL (GNU General Public License)
Plugin Version: 19297 (2010-08-01)
Change History:  
2010-08-01: TWikibug:Item6530 - doc fixes; changing TWIKIWEB to SYSTEMWEB
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

Topic attachments
I Attachment History Action Size Date Who Comment
Unknown file formatmd5 BugzillaQueryPlugin.md5 r4 r3 r2 r1 manage 0.2 K 2010-08-02 - 04:37 PeterThoeny  
Unknown file formatgz BugzillaQueryPlugin.tar.gz r1 manage 6.7 K 2008-08-27 - 12:21 SaschaVetter BugzillaQueryPlugin version 1.04
Compressed Zip archivetgz BugzillaQueryPlugin.tgz r4 r3 r2 r1 manage 5.9 K 2010-08-02 - 04:37 PeterThoeny  
Compressed Zip archivezip BugzillaQueryPlugin.zip r7 r6 r5 r4 r3 manage 7.4 K 2010-08-02 - 04:37 PeterThoeny  
Unknown file formatEXT BugzillaQueryPlugin_installer r2 r1 manage 3.4 K 2010-08-02 - 04:37 PeterThoeny  
Edit | Attach | Watch | Print version | History: r13 < r12 < r11 < r10 < r9 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r13 - 2013-10-16 - PeterThoeny
 
  • Learn about TWiki  
  • Download TWiki
This site is powered by the TWiki collaboration platform Powered by Perl Hosted by OICcam.com Ideas, requests, problems regarding TWiki? Send feedback. Ask community in the support forum.
Copyright © 1999-2016 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.