Opened 7 years ago

Closed 6 years ago

#9025 closed enhancement (wontfix)

Documentation enhancements examples

Reported by: jkey@… Owned by: Mark Ryan
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 7 years ago by anonymous

Component: SELECT A HACKChildTicketsPlugin
Owner: changed from anonymous to Mark Ryan

comment:2 Changed 6 years ago by Mark Ryan

Resolution: wontfix
Status: newclosed

Thanks for the suggestions ...

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain Mark Ryan.
The resolution will be deleted.

Add Comment

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

Note: See TracTickets for help on using tickets.