Report results do not seem to be accurate!!!
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 |
|
Sunday, September 11, 2011, 7:58:52 AM |
0
|
Gemini is security aware, it might be that the visibility group of the item doesn't allow you to view it. |
||||
|
0
|
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. |
||||
|
0
|
Yes, but they won't be in the list becasue you are not a member of the group. Check the item visibility please. |
||||
|
0
|
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? |
||||
|
0
|
|
||||
|
0
|
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. |
||||
|
0
|
Please send an email to support at countersoft dot com and we'll do a remote session. |
||||
|