Search - who closed a bug?

classic Classic list List threaded Threaded
9 messages Options
Reply | Threaded
Open this post in threaded view
|

Search - who closed a bug?

Aud-2
Hello Bugzilla Gods,

I would like to be able to perform a search where I could list bugs
that were closed within a specified period, and also list who closed
them.
Is this possible in Bugzilla?
I am using v 2.18.
 
Cheers,
Audrey

_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

RE: Search - who closed a bug?

Jay Glanville
I think you need to do an advanced search using booleans.  Basically,
"status" "changed by" "username" will give you who changed status.  In
the Bug Changes box, enter the time range, for "where one or more of the
following changed", select "Status", and for "new value" is "resolved".
This will find for you all bugs that were changed to resolved within the
desired time period.

JDG

> -----Original Message-----
> From: [hidden email]
> [mailto:[hidden email]] On Behalf Of Aud
> Sent: Thursday, June 23, 2005 9:40 AM
> To: [hidden email]
> Subject: Search - who closed a bug?
>
> Hello Bugzilla Gods,
>
> I would like to be able to perform a search where I could list bugs
> that were closed within a specified period, and also list who closed
> them.
> Is this possible in Bugzilla?
> I am using v 2.18.
>  
> Cheers,
> Audrey
>
> _______________________________________________
> mozilla-webtools mailing list
> [hidden email]
> http://mail.mozilla.org/listinfo/mozilla-webtools
>

_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Search - who closed a bug?

netspam
In reply to this post by Aud-2
Jay Glanville wrote:
> I think you need to do an advanced search using booleans.  Basically,
> "status" "changed by" "username" will give you who changed status.  In
> the Bug Changes box, enter the time range, for "where one or more of the
> following changed", select "Status", and for "new value" is "resolved".
> This will find for you all bugs that were changed to resolved within the
> desired time period.

That strategy lists the correct issues, however doesn't show the user
who closed the issues.  Sure I could select each bug in turn then
follow the "View Bug Activity" link to see the last entry in that
table... but that is very cumbersome - especially if there are hundreds
of bugs.

Ideally the last user to modify an issue would be a "Column" in the
"Bugs List" page (which could be configured through the "Change
Columns" link... but no such field seems to be listed.  Is there a way
to configure bugzilla to show this?  Is there a simple patch that could
be applied?  Is this functionality supported in a newer release (for
example the up-coming 2.20?)

_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Search - who closed a bug?

Peter Kay
[hidden email] wrote:

> Jay Glanville wrote:
>
>>I think you need to do an advanced search using booleans.  Basically,
>>"status" "changed by" "username" will give you who changed status.  In
>>the Bug Changes box, enter the time range, for "where one or more of the
>>following changed", select "Status", and for "new value" is "resolved".
>>This will find for you all bugs that were changed to resolved within the
>>desired time period.
>
>
> That strategy lists the correct issues, however doesn't show the user
> who closed the issues.
[snip]

Yeah, it doesn't come out of the box that way.  You're either looking at
modifying the perl + templates, or doing pure SQL statements.

For starting with the perl (if you're feeling up to it), take a look in
the templates
data/template/template/en/default/list/change-columns.html.tmpl and
/template/en/default/list/change-columns.html.tmpl, and start following
"Assignee Realname".  If you follow that back through the code &
parallel it, you should be able to get it working.

--Peter
_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Search - who closed a bug?

Jeff-9
In reply to this post by netspam
In my saved searches, I let the search load, then I add a columnlist
GET param to the end of the query string and refresh.   For example:

bugzilla/buglist.cgi?....[other params]....&columnlist=[columns]

where [columns] is a comma separated list of among these values (listed
taken from Bugzilla::Bug.pm):

bug_id
alias
product_id
product
version
rep_platform
op_sys
bug_status
resolution
priority
bug_severity
component_id
component
assigned_to
reporter
bug_file_loc
short_desc
target_milestone
qa_contact
status_whiteboard
creation_ts
delta_ts
votes
reporter_accessible
cclist_accessible
estimated_time
remaining_time

You're right though, ideally there should be a way to specify columns
for a specific search only.

_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Search - who closed a bug?

Jeff-9
Sigh... I just re-read the original post.   Nevermind;  my response
doesn't apply at all.  Poster was asking about how to get the status
changed by column.

This is what I get for replying without some coffee first.

_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Search - who closed a bug?

netspam
In reply to this post by Peter Kay
Peter Kay wrote:
> Yeah, it doesn't come out of the box that way.  You're either looking at
> modifying the perl + templates, or doing pure SQL statements.
>
> For starting with the perl (if you're feeling up to it), take a look in
> the templates
> data/template/template/en/default/list/change-columns.html.tmpl and
> /template/en/default/list/change-columns.html.tmpl, and start following
> "Assignee Realname".  If you follow that back through the code &
> parallel it, you should be able to get it working.

Thanks for the pointers! I've now got a column "Status last changed by"
which works exactly as I'd hoped it would.  It required an ugly
double-nested query in order to get the most recent status change in
bugs_activity but that's OK - I wouldn't imagine this column to be
enabled for most interactions.

The only thing I'm not entirely happy about is the placement of the
column... maybe I'm overlooking something simple - but I can't see how
to change the left-right ordering of columns in the buglist page...  I
don't suppose someone knows this offhand?

_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Search - who closed a bug?

Peter Kay
> The only thing I'm not entirely happy about is the placement of the
> column... maybe I'm overlooking something simple - but I can't see how
> to change the left-right ordering of columns in the buglist page...  I
> don't suppose someone knows this offhand?

In the template directory, list/table.html.tmpl ?  Does changing the
order of those change the order it appears in?

If not there, I'm not sure...but that's the template that displays the
list, so you should be able to track it down from there ;-)

--Peter
_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Search - who closed a bug?

netspam


Peter Kay wrote:

> > The only thing I'm not entirely happy about is the placement of the
> > column... maybe I'm overlooking something simple - but I can't see how
> > to change the left-right ordering of columns in the buglist page...  I
> > don't suppose someone knows this offhand?
>
> In the template directory, list/table.html.tmpl ?  Does changing the
> order of those change the order it appears in?
>
> If not there, I'm not sure...but that's the template that displays the
> list, so you should be able to track it down from there ;-)
>
> --Peter

That didn't help - though I've now spotted what I was missing.

The top->bottom order of the list of columns in the change columns list
is the same as left->right order in the bug-list.  I needed to change
@masterlist in colchange.cgi.  It even had a helpful comment :-)

--
# The master list not only says what fields are possible, but what
order
# they get displayed in.
my @masterlist = ( ...
--

_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools