Modify ↓
Opened 18 years ago
Last modified 4 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 |
Description
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 18 years ago by
comment:2 Changed 17 years ago by
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 17 years ago by
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
comment:4 Changed 11 years ago by
Owner: | changed from Noah Kantrowitz to Ryan J Ollos |
---|---|
Status: | new → assigned |
comment:5 Changed 4 years ago by
Status: | assigned → new |
---|
Note: See
TracTickets for help on using
tickets.
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.