Question

Possible Duplicate:
Feature Request: Better flagging for cases invisible to the assignee

Hello!

We run FB Version 6.1.44 (DB 632, Build 369)

Issue: frequently, we (by accident) assign a case to a user who cannot see the case. This happens because of the way FB security works.

The solution is for the creating/editing user to change the project the case is in, so the target user (the assignee) can see it.

How can we query FB to see all these "lost" cases?

Thank you!

Answer 1

Here's a starter query:

SELECT b.ixBug, a.iPermission FROM Bug b
LEFT JOIN Project p ON b.ixProject = p.ixProject
LEFT JOIN ACL a ON p.ixGroup = a.ixSection AND b.ixPersonAssignedTo = a.ixPerson

I'm really not sure what the WHERE clause will look like. We may want:

WHERE a.iPermission IS NULL

Or we may have to do some more joining.

Answer 2

Moved to a feature request (sorry Rich, your answer is nice, but is of no use to us in day to day use of FB)

http://fogbugz.stackexchange.com/questions/9770/feature-request-better-flagging-for-cases-invisible-to-the-assignee