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)+ additional feature such:

  • 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.

Download

Download the zipped source from here.

Source

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

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 
    
  • Here is the result:


In order to use table_report your report must have at least 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
  • Here is the result:


In order to use ticket_report your report must have at least the three 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

Author/Contributors

Author: jacqueswitte
Contributors:

Last modified 7 years ago Last modified on May 26, 2008, 6:56:46 PM

Attachments (2)

Download all attachments as: .zip