show blocked status in ticket report

[phpxcache]

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

[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.

[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.

[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 p.name = 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