Opened 5 years ago

Closed 5 years ago

#9025 closed enhancement (wontfix)

Documentation enhancements examples

Reported by: jkey@… Owned by: walnut
Priority: normal Component: ChildTicketsPlugin
Severity: minor Keywords: Documentation examples
Cc: Trac Release: 0.11


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 ( = c.ticket AND = 'parent')
  WHERE owner='$USER' and status != 'closed' and (c.value is null or c.value='') 

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


Attachments (0)

Change History (2)

comment:1 Changed 5 years ago by anonymous

  • Component changed from SELECT A HACK to ChildTicketsPlugin
  • Owner changed from anonymous to walnut

comment:2 Changed 5 years ago by walnut

  • Resolution set to wontfix
  • Status changed from new to closed

Thanks for the suggestions ...

Add Comment

Modify Ticket

as closed The owner will remain walnut.
The resolution will be deleted. Next status will be 'reopened'.

E-mail address and user name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.