CODEWITHSUNDEEP
bugzilla
Roman Starkov
Roman Starkov

Reputation: 61502

How to view date bug was closed in Bugzilla?

We're using bugzilla and I would like to add a column to a list view to see the last timestamp when the bug's state was set to resolved or closed. Is this possible and if so, how? If not, what's the closest I can have to this?

Using Bugzilla v3.2.3.

Upvotes: 2

Views: 2596

Answers (2)

Scott W
Scott W

Reputation: 9872

It's not super pretty and easy, but this query will give you the bug ID and the timestamp for the most recent time when the bug was changed to RESOLVED. You could adapt this for CLOSED as well, I am sure. If you wanted access to this information from within the Bugzilla user interface, then you would need to modify the code for your Bugzilla installation to expose this information.

select bugs.bug_id, bugs_activity.bug_when as 'Resolved'
from bugs
left join bugs_activity on     bugs.bug_id = bugs_activity.bug_id
                           and bugs_activity.fieldid=9
                           and bugs_activity.added='RESOLVED'
                           and bugs_activity.bug_when = (select max(a.bug_when)
                                                         from bugs_activity a
                                                         where a.bug_id = bugs.bug_id
                                                           and a.fieldid=9
                                                           and a.added='RESOLVED')

Upvotes: 4

Nader Shirazie
Nader Shirazie

Reputation: 10776

Looks like the closest you can get is the "Changed" column. Unfortunately, that updates even when comments are added.

Upvotes: 2

Related Questions