Filter whiteboard tickets with custom query instead of 'On Ticketsboard' field

[c.rabemananjara@…]

Current situation

At the moment, the use of the virtual whiteboard asks for an update on each tickets so that it appears/disappears on the board.

When a milestone is closed, and a new one is started, you may need to update a great number of tickets according to that.

Feature proposal

• Remove 'On Ticketsboard' custom field and replace it by a custom query. It may be based on a report that is settled by a variable in trac.ini. For example:

  [ticketsboard]
  inputreport = 4
  

• Create a custom macro that would allow to build a whiteboard based on the tickets available in the request

  [[TicketsBoard([<query>],[<fields>],[<col>],[<colvalues>])]]
  

  • <query>: custom query to select tickets that are displayed on the board
  • <fields>: fields that are displayed on each ticket
  • <col>: column of the board (default value would be status)
  • <colvalue>: values that should appear in column of the board (e.g. new, accepted, closed)

A complete example for this macro would be:

[[TicketsBoard(milestone=1.0,owner,estimated_time,status,new|accepted|closed)]]