Quoting cmcneal:
> Hi,
>
> I am trying to write either an SQL query, or put to gether a query
> using the search interface to find bugs that have had activity on
> them after they were closed.
>
> Does any one have a solution?

Here is something to start with:

Select closed.bug_when,other.*
From bugs_activity as closed
Left outer join bugs_activity as other
On closed.bug_id = other.bug_id
And closed.bug_when < other.bug_when
And closed.added = 'CLOSED'

Thanks for the start.



Still haven't been able to get everything out yet, but this helps.



I'm trying to narrow it down still further to specific milestones. Driying
to find something like all of the bugs that were closed, but have had
comments or changes to them since being closed for a specific target
milestone. We only watch the bugs till they are closed, and we are finding
that some have comments or changes made to them after they are closed.



Thanks.

"Tosh, Michael J" wrote in message
news:mailman.219.1224785434.2403.support-bugzilla@lists.mozilla.org...
> Quoting cmcneal:
>> Hi,
>>
>> I am trying to write either an SQL query, or put to gether a query
>> using the search interface to find bugs that have had activity on
>> them after they were closed.
>>
>> Does any one have a solution?
>
> Here is something to start with:
>
> Select closed.bug_when,other.*
> From bugs_activity as closed
> Left outer join bugs_activity as other
> On closed.bug_id = other.bug_id
> And closed.bug_when < other.bug_when
> And closed.added = 'CLOSED'