[rt-users] Problem seeing all unowned tickets.

[Nick Kartsioukas]

On Thu, 3 Dec 2009 16:59:25 -0500, "Lander, Scott"
<slander at hearstsc.com> said:
>    In RT 3.8.5.    I have a dozen or so queues, and people can't see
>    tickets outside their own workgroup queue.   This works fine.     Each
>    user has the X newest unowned tickets search on their RT at a Glance
>    page (the default).   Until recently, this worked fine, but, recently
>    people started reporting tickets missing from that search.

If you set $UseSQLForACLChecks, that should fix the problem.
>From RT_Config.pl:
"In RT for ages ACL are checked after search what in some situtations
result in empty search pages and wrong count of tickets.  Set
$UseSQLForACLChecks to 1 to use SQL and get rid of these problems. 
However, this option is beta. In some cases it result in performance
improvements, but some setups can not handle it."

Depending on how many users/groups you have and how your database is
configured you may see a performance hit, maybe give it a try on a test
instance and see how much of an impact there is.