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
--
To UNSUBSCRIBE, email to debian-qa-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Archive: http://lists.debian.org/20111218000529.ga8...@an3as.eu
