wiki:TicketBoxPlugin

Ticket list in a box on the wiki page and more

Description

This is the TicketBoxPlugin version of TicketBoxMacro (from Shun-ichi Goto), with the following additional features:

  • ticket_report
  • table_report

Bugs/Feature Requests

Existing bugs and feature requests for TicketBoxPlugin are here.

If you have any issues, create a new ticket.

task

0 / 1

Download

Download the zipped source from here.

Source

You can check out TicketBoxPlugin from here using Subversion, or browse the source with Trac.

Installation

General instructions on installing Trac plugins can be found on the TracPlugins page.

Example

table_report

  • Macro in a wiki page:
    [[TicketBox('report [table_report] all milestones', {9}, table_report, inline)]]
    
  • Content of report report:
    SELECT id AS ticket, milestone, summary, t.type AS type, 
       (CASE status WHEN 'assigned' THEN owner||' *' ELSE owner END) AS owner,
       description,
       reporter AS reporter
    FROM ticket t
       LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
    WHERE status IN ('new', 'assigned', 'reopened')
    ORDER BY p.value, milestone, t.type, time 
    

With the following result:

To use table_report your report must have at least the following column:

  • ticket (ticket id)

ticket_report with MILESTONE parameter

  • Macro in a wiki page:
    [[TicketBox('MyTicketBoxMilestone tickets details', [report:10?MILESTONE=MyTicketBoxMilestone], ticket_report, inline)]]
    
  • Content of report:
    SELECT id AS ticket, summary, t.type AS type, 
       (CASE status WHEN 'assigned' THEN owner||' *' ELSE owner END) AS owner,
       description,
       reporter AS reporter
    FROM ticket t
       LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
    WHERE status IN ('new', 'assigned', 'reopened') AND t.milestone = $MILESTONE
    ORDER BY p.value, milestone, t.type, time    
    
  • we have a milestone MyTicketBoxMilestone with 3 tickets

With the following result:

To use ticket_report your report must have at least the following columns named:

  • ticket (ticket id)
  • summary (ticket summary)
  • description (ticket description)

Recent Changes

3718 by jacqueswitte on 2008-05-26 14:31:27
first TicketBoxPlugin beta release
3717 by jacqueswitte on 2008-05-26 14:24:27
New hack TicketBoxPlugin, created by jacqueswitte
(more)

Author/Contributors

Author: jacqueswitte
Maintainer: jacques witte
Contributors:

Last modified 10 months ago Last modified on Oct 30, 2015, 2:47:58 PM

Attachments (2)

Download all attachments as: .zip