Welcome to the FogBugz Knowledge Exchange

Question

16

2

I know I can search for status open or closed, and search for dates that cases were opened or closed (including date ranges), but how can I find out which cases have ever been reopened?

Case FC1247103

edited May 1 2012 at 13:20

adambox♦♦
23.9k●1●22●63

asked Mar 29 2010 at 15:23

FogBugz FAQ♦♦
8,848●3●28●85

	If you have access to the database, you can retrieve them via SELECT * from BUG where dtOpened > dtClosed (i.e. Get all cases where the date opened is later than the date closed.) – James McLeod♦ Mar 29 2010 at 18:21
	note on this SQL method: fogbugz.stackexchange.com/questions/2568/… – adambox♦ Jun 2 2010 at 18:32

adambox · Accepted Answer · 2012-05-01 13:21:09Z UTC

6

This isn't currently possible because the opened: search axis looks only for the first time the case was opened.

We have a case open to consider adding an axis for reopened. If you think that would be useful for you, please up-vote this question.

You can also try Justine's suggestion below or try your hand at implementing a new search axis via a plugin.

edited May 1 2012 at 13:21

answered Mar 29 2010 at 15:24

adambox♦♦
23.9k●1●22●63

	The linked case is the original one – FogBugz FAQ♦ Mar 30 2010 at 19:40
	Please add this search axis as soon as possible. It's really weird that all the other automatic comments are search axes, and this one isn't (e.g. Opened By, Assigned To: etc etc). It would be incredibly useful to us to have this as a searchable axis. We currently kludge a way around this with the following: project:"The Tech Guys" type:case (opened:yesterday or color:blue) ... then sort by date. When what we really need is to know how many cases were presented to us yesterday, that previously did not exist, or were reopened. Please add the axis. – Justine Jun 2 2010 at 16:07
	+1 big time. It would make all the difference in the world to just be able to see what is opened or reopened in the last X days. As it is, can't really do this very basic view of the most recent cases. – Dave Aug 22 2010 at 23:42
	Also please consider a way to figure out the first person to resolve/close a case as well. We are having some problems with metrics because cases are reopened and then reclosed. – Caio James Mar 23 2011 at 21:32
	If this is an urgent need for anyone, please contact us at customer-service@fogcreek.com and let us know. Plugins can implement new search axes, and almost anything you can `SELECT` in a SQL query you can do in a plugin. – adambox♦ Mar 24 2011 at 14:45

Stuart Harris-UHG · Answer 2 · 2010-03-29 22:14:47Z UTC

2

The comment about

SELECT * from BUG where dtOpened > dtClosed will only work if the case is still open. It does not help find or report on cases that have been reopened then were subsequently resolved/closed.

answered Mar 29 2010 at 22:14

Stuart Harris-UHG
21●2

+1 - good point! – James McLeod♦ Mar 30 2010 at 13:06

Justine · Answer 3 · 2010-06-03 09:20:12Z UTC

Hmm, I chewed on this a bit more and came up with following workaround. YMMV.

How to find cases which were opened or reopened in a given timeframe.

NOTE: This will work best if incoming mails have a virtual user for the "Open As" assignee.

project:"YOUR PROJECT" opened:"today" openedby:"DEFAULT ASSIGNEE" orderby:"LastEdited" (status:"open" OR status:"closed") -status:"Closed (SPAM)"

If your Project receives cases from more than one mailbox, then you can expand this using:

project:"YOUR PROJECT" opened:"today" (openedby:"DEFAULT ASSIGNEE1" OR openedby:"DEFAULT ASSIGNEE2" OR openedby:"DEFAULT ASSIGNEE3" etc etc) orderby:"LastEdited" (status:"open" OR status:"closed") -status:"Closed (SPAM)"

.. it's a bit of a kludge, and I'm still voting for Reopened: to become a search axis.

Cheeres, Justine

How can I find all cases which have been closed and then reopened?

3 Answers