Home Home
  login

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.




Closeddate not always populated

database
search
reporting

I am running some reports against the gemini db, and I had assumed that the closeddate would be filled in every time an issue was updated to a status which is marked as final. There seem to be a number of tickets whoose status we have marked as closed (and the final flag is set to true) but yet the closeddate is null. Is this expected? Is there another way to get the closeddate? Should I be using the reviseddate?
rlevine
· 75 		rlevine
Tuesday, September 27, 2011, 3:37:25 PM
Replies (9)
helpful
0
not helpful

Closed date should be populated, can you check from the history when the status changed? Generally, looking at revised date should be good enough, but people might still change something after it was closed.
Mark Wing
· 9108 		Mark Wing
Tuesday, September 27, 2011, 3:46:07 PM
helpful
0
not helpful

I totally agree with that. I am querying items that were closed in the past week. I have a number of such examples.
rlevine
· 75 		rlevine
Tuesday, September 27, 2011, 4:11:10 PM
helpful
0
not helpful

Can you ask the users how did they close these items? We would like to get to the bottom of it but cannot replicate it.
Mark Wing
· 9108 		Mark Wing
Tuesday, September 27, 2011, 4:15:49 PM
helpful
0
not helpful

I am one of those users in this case. I can think of these 3 ways of how I may close an issue.

1) in the issue set the status to closed. 2) in a comment set the status to closed. 3) in a report of all items set the status to closed (in line)

I have no idea which way I did each.
rlevine
· 75 		rlevine
Tuesday, September 27, 2011, 5:39:03 PM
helpful
0
not helpful

We have tested all options and it seems to work for us, does it still happen now when you close items?
Mark Wing
· 9108 		Mark Wing
Wednesday, September 28, 2011, 10:37:56 AM
helpful
0
not helpful

Yes it does. I'm not sure how to replicate it, but I run a weekly report which includes all issues closed last week and not all issues that were closed (and currently marked as closed) are being returned.
rlevine
· 75 		rlevine
Wednesday, September 28, 2011, 1:52:41 PM
helpful
0
not helpful

I was just able to replicate it by setting the status to closed in the comment form (i.e. when adding a comment)
rlevine
· 75 		rlevine
Wednesday, September 28, 2011, 3:09:02 PM
helpful
0
not helpful

I understand Saar is having a remote session with you on Monday, can we conver this issue as well? (we can't seem to replicate it).
Mark Wing
· 9108 		Mark Wing
Wednesday, September 28, 2011, 3:18:37 PM
helpful
0
not helpful

Sure, that works.

Thanks
rlevine
· 75 		rlevine
Wednesday, September 28, 2011, 4:13:01 PM