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.




Report results do not seem to be accurate!!!

reporting

I am viewing a list of all items in a specific project which are open (not including items which we set the status to postponed) and it is returning 11 items.

When I run the below query it is returning 33 items. I checked a few of the items that are returned from the query and I can't figure out why they are not returned by the report.

SELECT projectname as project, prioritydesc as priority, statusdesc,created, issueid FROM Gemini.dbo.geminiissuesview where statusdesc not in (select statusdesc from Gemini.dbo.geminiissuestatusfinal) and statusdesc <> 'Postponed' and projectname = 'Account Administration' order by statusdesc,created desc

rlevine
· 75
rlevine
Replies (7)
helpful
0
not helpful

Gemini is security aware, it might be that the visibility group of the item doesn't allow you to view it.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Hi Saar, Thank you for the quick response on all my posts. I don't believe that security is the issue here, as I am a Gemini Admin and have rights to all issues. Additionally, I chose a few of the items that were missing and I was able to look them up manually. They are just not coming back in the report.


rlevine
· 75
rlevine
helpful
0
not helpful

Yes, but they won't be in the list becasue you are not a member of the group. Check the item visibility please.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

A few things. 1) I recently changed the type so that visibility cannot be viewed. How can I check this, (without changing it back)?

2) I thought that Gemini Administrators can view and manager all. That is at least how it is configured in the admin section.

3) I created the ticket, so I should be able to view it (as is configured).

4) If I wasn't a part of the member group, would I be able to look up the missing issues and view and change them, which I can do?


rlevine
· 75
rlevine
helpful
0
not helpful
  1. Change the screen that the type is using (Administration -> Type under items).
  2. Yes, but visibility of items and "only view own" still applies.
  3. True, but if the default visibility is not for your group you won't see it in the list.
  4. You will not see them in the list but can still view them when accessing directly (item id).

Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

1) Ok, I checked and the visibility is set to Everyone.

2) I don't understand. Are you saying that if "Only view own" is set, then I can only view my own created issues and that will override the Gemini Administrator setting? Even so, some of the ones that I can't view are ones that I created.

3) The default visibility is set to Everyone.

4) Sounds a little wrong. Is there a reason it was implemented this way? This sounds a little buggy.


rlevine
· 75
rlevine
helpful
0
not helpful

Please send an email to support at countersoft dot com and we'll do a remote session.


Saar Cohen
· 5000
Saar Cohen