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 05/26/08 14:31:27

first TicketBoxPlugin beta release

[3717] by jacqueswitte on 05/26/08 14:24:27

New hack TicketBoxPlugin, created by jacqueswitte

Author/Contributors

Author: jacqueswitte
Contributors: