Re: UDD hint wanted: Who has closed a certain bug

[Andreas Tille <andreas@an3as.eu>]

Hi Stuart,

On Tue, Dec 06, 2011 at 12:20:29PM +0000, Stuart Prescott wrote:
> 
> The 'done', 'done_name' and 'done_email' columns of the bugs and 
> archived_bugs tables are populated from the automatically generated email 
> that closed the bugs -- that email claims to come from the person who is in 
> the Changed-By field of the changes file.
> 
> So how about:
> 
>     SELECT done, count(id) AS num_closed 
>     FROM archived_bugs 
>     WHERE last_modified > '2011-01-01'
>     GROUP BY done 
>     ORDER BY num_closed DESC;

OK, that's helpful.  However what is the sense of done_date in this table?

   SELECT count(*) FROM archived_bugs WHERE done_date != '1970-01-01 00:00:00';
 
Kind regards

        Andreas. 

-- 
http://fam-tille.de