Documentation enhancements examples

[jkey@…]

Hi. Just two examples for consideration - maybe could be part of the documentation...

Report showing tickets in a certain states: displayed are only tickets created prior to the installation of the ChildTickets plugin and Tickets created afterwards, but without parent (toplevel tickets)

Bericht über alle Tickets mit einem bestimmten Status, Untertickets sind ausgeblendet

SELECT id AS ticket, status, severity, priority, 
       time as created, summary 
FROM ticket
LEFT OUTER JOIN ticket_custom c ON (ticket.id = c.ticket AND c.name = 'parent')
  WHERE owner='$USER' and status != 'closed' and (c.value is null or c.value='') 
  ORDER BY time DESC

TicketQuery showing only Tickets in a certain state with no parent (toplevel tickets)

[[TicketQuery(priority=blocker&status=new|accepted|assigned|reopened&parent=)]]

[Mark Ryan]

Thanks for the suggestions ...