Fog Creek Software
Discussion Board




date ranges

Are the dates/times of edits/changes stored in the database.  I see the history is maintained in the text of the case, but is this queryable  (SQL, access, excel)?

e.g. select cases opened or closed or reopened within a date range.

Trevor Hughes
Friday, October 24, 2003

Yep.  It's in the BugEvent table.. Column dt for the date...

Michael H. Pryor
Friday, October 24, 2003

And for more info on building reports off your database:

Access:
http://www.fogcreek.com/FogBUGZ/KB/howto/CreatingReportsforFogBUGZ.html

Excel:
http://www.fogcreek.com/FogBUGZ/KB/howto/UsingPivotTablesinExcel.html

Dmitri Kalmar
Wednesday, October 29, 2003

*  Recent Topics

*  Fog Creek Home