Additional available reports

[Mark Potter]

Suggestion, for users of this site, as opposed to authors of hacks, add two new reports.

Tickets I Reported

That is tickets that have reporter equal to the current user.

Tickets of Personal Interest

That is tickets that have reporter equal to the current user or CC which contains the current user.

The first report is easy for a user to set up as a Custom Query, but the second has to be done as an SQL query. Not sure if these should include closed tickets or not. I think yes, but sorted below open tickets.

[Ryan J Ollos]

I'd also like to request:

• Active Tickets by Component

[Mark Potter]

Replying to potter:

Tickets of Personal Interest

That is tickets that have reporter equal to the current user or CC which contains the current user.

Related: ​trac:#8559. From there, with modification (removed the or commented on clause:

-- Tickets that the current user reported, or marked for CC. 
-- (including closed).

SELECT 
  DISTINCT 
   p.value AS __color__,
   (CASE status 
      WHEN 'closed' THEN 'color: #777; background: #ddd; border-color: #ccc;'
    END) AS __style__,
   id AS ticket, summary, component, milestone, status, resolution, 
   t.time AS created, changetime AS modified,
   priority AS _priority, reporter AS _reporter, cc AS _cc
  FROM ticket t
  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
  LEFT JOIN ticket_change tc ON id = tc.ticket
  WHERE reporter = '$USER' 
   OR cc LIKE '%$USER%'
  ORDER BY
    (status = 'closed'), 
    (CASE status
       WHEN 'closed' THEN changetime
       ELSE (-1) * CAST(p.value AS int)
    END) DESC

[Ryan J Ollos]

Replying to Ryan J Ollos:

I'd also like to request:

• Active Tickets by Component

That's report {9}. See #13482.

[Ryan J Ollos]

I think more isn't needed for now since users can bookmark custom queries. Hopefully we get private reports in Trac, and/or install BookmarkPlugin eventually.