Capturing Timestamps of Status Changes

[Bottiger, John (PMF)]

Team,

When I perform a query on the Bugzilla database, I notice that the two timestamp fields are Opened and Last Updated. What I want to do is capture those bugs whose status has changed to "RESOLVED" and capture the dates when this status change took place. I also want to do the same for bugs whose status changed to "CLOSED". The Last Updated field doesn't necessarily provide the timestamp information related to status changes, only the last update period.

Please advise as to how to approach this so I don't have to examine every single bug and "fat-finger" the date/time of the status change for each. Thanks.

V/R,

John J. Bottiger
Software Engineer
Aerotek/WinTec Arrowmaker, Inc.
5410 W. Tyson Ave., Suite E
Tampa, FL 33611
Office: 813-805-2714
Mobile: 863-521-6924
Bott...@arrowmaker.com<mailto:Bott...@arrowmaker.com>

"Impossible" does not mean "not possible"; it means "I'm possible".

[Thorsten Schöning]

Guten Tag Bottiger, John (PMF),
am Dienstag, 20. August 2013 um 15:46 schrieben Sie:

> When I perform a query on the Bugzilla database,

Does this mean SQL or the web interface?

> Please advise as to how to approach this so I don't have to examine
> every single bug and "fat-finger" the date/time of the status change for each. Thanks.

I'm not sure I understand where you are doing what, therefore I
recommend using advanced search and "Search By Change History" and
mention the table bugs_activity in the database. Both should provide
the data you need.

Mit freundlichen Grüßen,

Thorsten Schöning

--
Thorsten Schöning E-Mail:Thorsten....@AM-SoFT.de
AM-SoFT IT-Systeme http://www.AM-SoFT.de/

Telefon...........05151- 9468- 55
Fax...............05151- 9468- 88
Mobil..............0178-8 9468- 04

AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln
AG Hannover HRB 207 694 - Geschäftsführer: Andreas Muchow

[Bommaiahchowdary Polarpu]

Hi John,

Iam not sure which table we need to verify to capturing Timestamps of Status Changes for product - product-2013-08-20
Can you please suggest which table we need to check in MySQL.

Error which I received while opening in product is below error . how can we fix below error . and
For your information and I was able to open other products without any issues.

Error :

Content-Type: text/html; charset=UTF-8 content-disposition: inline; filename="product-2013-08-20.html" Set-Cookie: LASTORDER=bug_status%2Cpriority%2Cassigned_to%2Cbug_id; path=/; expires=Fri, 01-Jan-2038 00:00:00 GMT Set-Cookie: BUGLIST=X; path=/; expires=Tue, 15-Sep-1998 21:49:00 GMT


Can you please tell where can I find products information in mysql database .

Like product - product-2013-08-20



Thanks and Regards
Bommaiahchowdary
Senior System Administrator
Amber Road Software Pvt Ltd.
Office: +91 80 67334000
Mobile: 9945388119
Extn: 338
Email : bommaiahcho...@amberroad.com
www.AmberRoad.com



Learn About GTM Technologies in a Flash: Introduction to Automating Export Compliance
The information contained in this e-mail message, including any attachments, constitutes proprietary and confidential information of AmberRoad Software Pvt Ltd, and is intended only for the personal and confidential use of the recipient or recipients named above. If the reader of this message is not the intended recipient, you are hereby notified that you have received this message in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify the sender immediately by e-mail and delete the original message.

-----Original Message-----
From: support-bugzilla [mailto:support-bugzilla-bounces+bommaiahchowdarypolarpu=amberr...@lists.mozilla.org] On Behalf Of Bottiger, John (PMF)
Sent: 20 August 2013 19:16
To: support-...@lists.mozilla.org
Subject: Capturing Timestamps of Status Changes

Team,

When I perform a query on the Bugzilla database, I notice that the two timestamp fields are Opened and Last Updated. What I want to do is capture those bugs whose status has changed to "RESOLVED" and capture the dates when this status change took place. I also want to do the same for bugs whose status changed to "CLOSED". The Last Updated field doesn't necessarily provide the timestamp information related to status changes, only the last update period.

Please advise as to how to approach this so I don't have to examine every single bug and "fat-finger" the date/time of the status change for each. Thanks.

V/R,

John J. Bottiger
Software Engineer
Aerotek/WinTec Arrowmaker, Inc.
5410 W. Tyson Ave., Suite E
Tampa, FL 33611
Office: 813-805-2714
Mobile: 863-521-6924
Bott...@arrowmaker.com<mailto:Bott...@arrowmaker.com>

"Impossible" does not mean "not possible"; it means "I'm possible".

_______________________________________________
support-bugzilla mailing list
support-...@lists.mozilla.org
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put support-...@lists.mozilla.org in the To: field when you reply.

[Thorsten Schöning]

Guten Tag Bommaiahchowdary Polarpu,
am Dienstag, 20. August 2013 um 16:16 schrieben Sie:

> Hi John,

Please do not capture other's threads which don't belong to your
problem, start new threads for your own problem.