Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Issue - Date Closed

web-app

Hello,

My company runs some custom reports against Gemini directly accessing the SQL server back end. I was wondering if there was a field to say when a particular issue was closed. The best I can see at the moment was the IssueHistory table, but it's still not the greatest.

Are there any other ways that I've missed?

Murray Grant
ibs
· 1 		ibs
Monday, June 19, 2006, 6:53:39 AM
Replies (4)
helpful
0
not helpful

The revised date is the last action that was taken on the issue. Therfore it is the closed date.
Mark Wing
· 9108 		Mark Wing
Monday, June 19, 2006, 10:21:33 AM
helpful
0
not helpful

I thought that at first as well. But wouldn't the revised date change if I, for example, reopened an issue? Or if I modified another field after closing the issue?

That's the problem that I couldn't quite resolve in my mind.
ibs
· 1 		ibs
Thursday, June 22, 2006, 12:38:59 AM
helpful
0
not helpful

Yes, but then the issue is not closed any more.
Mark Wing
· 9108 		Mark Wing
Thursday, June 22, 2006, 10:08:46 AM
helpful
0
not helpful

So the only way to run a report that calls on the original close date is using history?
galeforcewind
· 1 		galeforcewind
Wednesday, June 28, 2006, 8:59:24 PM