3

I would like to know what is the difference of the two: "Resolved" and "Closed"

I have seen this in the template of ms access db 2007 Customer Database Support. And there is the status that says, "active", "resolve" or "closed".

Does anybody know the difference? Thanks

Nifle
  • 34,998
tintincutes
  • 1,267

2 Answers2

3

This database was probably inspired by bug tracking systems.

With any kind of issue tracking or bug tracking, a common occurrence is that the person who reported a bug is unsatisfied with the way it was resolved. For example, a tester may report a bug, and a programmer may claim that it was fixed, but when the tester checks, it's not really fixed. The programmer might have misinterpreted the bug report and fixed something different, for example... this is surprisingly common. Or, the programmer may think that the bug is not important enough to fix, and the tester may disagree.

In bug tracking systems, a programmer RESOLVES a bug, which means that they believe that they have fixed the bug, or they have decided not to fix it... either way, they dealt with it.

In most bug tracking systems, when a bug is resolved, it gets reassigned to the person who opened it. This serves two purposes:

  1. It notifies the opener that the bug has been dealt with
  2. It allows the opener to decide if they are happy with the resolution. If they are, they can close it. If they aren't, they can reactivate it and send it back.

In other words, the bug has to stay open, even after it's resolved, until the original opener decides that they are happy with the resolution.

Joel Spolsky
  • 1,854
2

As a former helpdesk/support manager, I can tell you that in a general support framework:

Resolved is an issue that has been worked on and fixed. There will be a resolution for this one as well.

Closed is an issue that was not resolved but was no needed to be kept open. I.e. a duplicate ticket was opened, the customer resolved on their own, issue went away, that issue/product is not covered in the scope of support, etc.

JNK
  • 8,426