= 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 
[report:9?COMPONENT=TicketBoxPlugin here].

If you have any issues, create a 
[http://trac-hacks.org/newticket?component=TicketBoxPlugin&owner=jacqueswitte new ticket].

== Download ==

Download the zipped source from [download:ticketboxplugin here].

== Source ==

You can check out TicketBoxPlugin from [http://trac-hacks.org/svn/ticketboxplugin here] using Subversion, or [source:ticketboxplugin 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:
------
[[Image(table_report.gif)]]
------
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:
------
[[Image(ticket_report.gif)]]
------

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 ==

[[ChangeLog(ticketboxplugin, 3)]]

== Author/Contributors ==

'''Author:''' [wiki:jacqueswitte] [[BR]]
'''Contributors:'''