Modify

Opened 5 years ago

Last modified 5 years ago

#5526 new enhancement

Additional available reports

Reported by: potter Owned by: otaku42
Priority: low Component: TracHacks
Severity: normal Keywords:
Cc: Trac Release: 0.11

Description

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.

Attachments (0)

Change History (3)

comment:1 Changed 5 years ago by rjollos

  • Summary changed from New Reports to Additional available reports

I'd also like to request:

  • Active Tickets by Component

comment:2 Changed 5 years ago by rjollos

  • Priority changed from normal to low

comment:3 in reply to: ↑ description Changed 5 years ago by 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

Add Comment

Modify Ticket

Action
as new .
Author


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

 
Note: See TracTickets for help on using tickets.