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

2011-12-22 Thread Andreas Tille
On Tue, Dec 20, 2011 at 05:27:07PM +0100, Lucas Nussbaum wrote: > On 18/12/11 at 17:34 +, Stuart Prescott wrote: > > > 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';

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

2011-12-20 Thread Lucas Nussbaum
On 18/12/11 at 17:34 +, Stuart Prescott wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hi Andreas, > > > 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'; >

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

2011-12-18 Thread Stuart Prescott
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Andreas, > 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'; No idea -- I pointed out previously that this was uniformly set to 197

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

2011-12-17 Thread Andreas Tille
Hi Stuart, On Tue, Dec 06, 2011 at 12:20:29PM +, 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

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

2011-12-06 Thread Andreas Tille
Hi, On Tue, Dec 06, 2011 at 12:20:29PM +, Stuart Prescott wrote: > > Does UDD provide some information about who closed a bug? > > 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

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

2011-12-06 Thread Stuart Prescott
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Andreas, > Does UDD provide some information about who closed a bug? 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

UDD hint wanted: Who has closed a certain bug

2011-12-05 Thread Andreas Tille
Hi, for the team metrics analysis I would like to fetch some information about who closed a certai bug. Finally I want to count how many bugs a team member has closed per year. Does UDD provide some information about who closed a bug? I can only find in table bugs_fixed_in the version of the pa