Opened 16 years ago

Last modified 3 years ago

#1327 new enhancement

show blocked status in ticket report

Reported by: phpxcache Owned by: Ryan J Ollos
Priority: high Component: MasterTicketsPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.10


it looks hard to implement, but still nice to see if tickets is in "blocked" status in report module

Attachments (0)

Change History (5)

comment:1 Changed 16 years ago by phpxcache

i mean u may show me how to do it in plain sql, or add make "blocked-by" field containing a reverse id mapping to those ticket(s) blocking this ticket.

comment:2 Changed 16 years ago by Noah Kantrowitz

With the new version this should now be possible, though it would be an impressive bit of SQL. Take a look at the mastertickets table, and do a lot of joins against it.

comment:3 Changed 16 years ago by Morris

This was "good enough" for my purposes:

SELECT component AS __group__,
   id AS ticket, summary, milestone, t.type AS type, 
   owner, status, (SELECT value AS ticket FROM ticket_custom WHERE name='blockedby' AND ticket=id AND value <> '') AS blocked_by,
   time AS created,
   changetime AS _changetime, description AS _description,
   reporter AS _reporter
  FROM ticket t
  LEFT JOIN enum p ON = t.priority AND p.type = 'priority'
  WHERE status <> 'closed' 
    AND (SELECT count(*) FROM mastertickets WHERE dest=id) > 0
  ORDER BY (component IS NULL),component, p.value, t.type, time

comment:4 Changed 9 years ago by Ryan J Ollos

Owner: changed from Noah Kantrowitz to Ryan J Ollos
Status: newassigned

comment:5 Changed 3 years ago by Ryan J Ollos

Status: assignednew

Modify Ticket

Change Properties
Set your email in Preferences
as new The owner will remain Ryan J Ollos.

Add Comment

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

Note: See TracTickets for help on using tickets.