Fog Creek Software
Discussion Board




Reporting Capabilities/Filtering? (help!)

I am the IS project manager and we have a new COO who has asked me to provide a report of all the projects worked on my one of our developers. (Of course he wants this by Monday morning.)

I have tried all sorts of filtering, but am of course completely stymied because anything closed is assigned to "Closed", and there is no way to say "Show me all the cases that were updated by or assigned to PersonX".

Does anyone have any suggestions for me, or do I just have to go through 400 cases by hand, looking for her name in the documentation?

Thanks.

Shannon

Shannon Ahern
Friday, February 13, 2004

Use Access:
http://www.fogcreek.com/FogBUGZ/KB/howto/AccessReports.html
or Excel:
http://www.fogcreek.com/FogBUGZ/KB/howto/ExcelReports.html

to select all rows from the BugEvent table where sVerb = "Resolved by Joel Spolsky" (replace your fellow employee's name there, exactly as it's spelled in FogBUGZ)

Make sense?

Dmitri
Fog Creek Software
Friday, February 13, 2004

Or, of course, just search for everything where the sVerb field contains that person's name to see everything they've ever done.... in their whole life....

Dmitri
Fog Creek Software
Friday, February 13, 2004

Thank you SO MUCH!

I suppose it's worth saying that this would be a very useful feature-- to be able to filter on this kind of data in order to produce reports for COO-types when they want to perform reviews.  ;-)

Shannon Ahern
Monday, February 16, 2004

http://www.joelonsoftware.com/articles/fog0000000070.html

Michael H. Pryor
Fog Creek Software
Monday, February 16, 2004

I, unfortunately, have need to produce a similar report, although I agree with many of the points made in Joel's  article.  However, my SQL Server's BugEvent table's sVerb field does not contain any "Resolved By AnyName" entries at all.  The field contains entries that say "Resolved (Responded)" or other status reports.  What can we do differently?

Rich Black
Thursday, February 26, 2004

Sorry - dug a little deeper and used the ixPerson field to find what I needed. 

Rich Black
Thursday, February 26, 2004

*  Recent Topics

*  Fog Creek Home