Modify

Opened 8 years ago

Last modified 12 months ago

#1327 assigned enhancement

show blocked status in ticket report

Reported by: phpxcache@… Owned by: rjollos
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 (4)

comment:1 Changed 8 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 7 years ago by coderanger

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 7 years ago by gt4329b

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 12 months ago by rjollos

  • Owner changed from coderanger to rjollos
  • Status changed from new to assigned

Add Comment

Modify Ticket

Action
as assigned The owner will remain rjollos.
Author


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

 
Note: See TracTickets for help on using tickets.