Hello, On 22.03.2012 17:23, Marissa G wrote:
Is it possible to create a ticket report or query that will give me tickets that were *ever* in a certain status. We would like to track tickets that go back and forth from our QA team and so I need to see tickets that in history, were in the reopened state.
I don't think it's possible with ticket queries, but a ticket report could look at the ticket_change table (it stores the ticket history, one field-change per row):
SELECT DISTINCT t.id AS id FROM ticket t LEFT JOIN ticket_change tc ON t.id = tc.ticket WHERE tc.field='status' AND tc.newvalue = 'reopened' This should list all tickets that were ever changed to status reopened. -- Peter -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
