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

[carrt7@…]

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

[Christian Boos]

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.

[peterd@…]

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.

[Christian Boos]

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.

[Christian Boos]

Milestone 2.0 deleted

[Remy Blank]

Replying to cboos:

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

Interesting.

[Remy Blank]

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

[Remy Blank]

Refocusing.