Edgewall Software
Modify

Opened 10 years ago

Last modified 8 years ago

#8371 new enhancement

need to view ticket-list of only tickets with unanswered updates

Reported by: carrt7@… Owned by:
Priority: normal Milestone: next-major-releases
Component: report system Version: 0.11.1
Severity: normal Keywords: filter query
Cc: Branch:
Release Notes:
API Changes:

Description

Trac is so good that one's database grows rapidly. I need to be able to view a filtered ticket-list, showing only those tickets which:

  • were created by me
  • the last update was by someone else, not me

ie tickets which have queries I need to answer.

We can't see how to do this. Tony

Attachments (0)

Change History (7)

comment:1 by Christian Boos, 10 years ago

Resolution: invalid
Status: newclosed

This is a Trac usage question, you should really ask such things on the Trac MailingList, in the future.

For that specific question, you can look at TracTicketsCustomFields#ReportsInvolvingCustomFields for hints.

comment:2 by peterd@…, 10 years ago

Resolution: invalid
Status: closedreopened

Yes, it can clearly be done in the Reports module with some SQL like:

SELECT <list of fields you want, including id> FROM ticket
WHERE reporter="me" AND
      (SELECT author FROM ticket_change
       WHERE ticket=id AND
             time=(SELECT MAX(time) FROM ticket_change
                   WHERE ticket=id)
      )!="me";

However, the Reports module is deprecated in favour of the Query module, and I don't believe you can do this in the Query module yet. So the enhancement is to allow this sort of thing in the Query module, as per TracReports:

This will make the query module the default handler for the “View Tickets” navigation item. We encourage you to try this configuration and report back what kind of features of reports you are missing, if any.

in reply to:  2 ; comment:3 by Christian Boos, 10 years ago

Component: ticket systemreport system
Keywords: query added
Milestone: 2.0

Replying to peterd@…:

However, the Reports module is deprecated in favour of the Query module, and I don't believe you can do this in the Query module yet.

… and I don't believe the Report module is going away anytime soon ;-)

That being said, we could consider the addition of a filter on the last updater.

comment:4 by Christian Boos, 10 years ago

Milestone: 2.0unscheduled

Milestone 2.0 deleted

in reply to:  3 comment:5 by Remy Blank, 9 years ago

Milestone: triagingnext-major-0.1X
Owner: set to Remy Blank
Status: reopenednew

Replying to cboos:

That being said, we could consider the addition of a filter on the last updater.

Interesting.

comment:6 by Remy Blank, 9 years ago

Related to #8728, which asks for a "close date" filter.

comment:7 by Remy Blank, 8 years ago

Owner: Remy Blank removed

Refocusing.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as new The ticket will remain with no owner.
The ticket will be disowned. Next status will be 'new'.
as The resolution will be set. Next status will be 'closed'.
The owner will be changed from (none) to anonymous. Next status will be 'assigned'.

Add Comment


E-mail address and name can be saved in the Preferences .
 
Note: See TracTickets for help on using tickets.