[rt-users] Search results being filtered after they are generated?

[Jon Baker]

Ok, this at first appeared to work - but after a few minutes I got a  
call that the quick search wasn't working as expected.

I have users defined in groups for AdminCC's of some queues.  Before,  
the quick search list correctly showed, let's say, 15 open tickets in  
the IT queue.  Of those 15 tickets, 5 were created by jimb, so he is  
the requester of those tickets.  Jimb is the owner of two of them.   
After turning on UseSQLForACLChecks, he now only sees 7 tickets in the  
quick search, and when he clicks on the queue he sees only the 7  
tickets that he is explicitly assigned as a watcher instead of the  
entire queue that he is in a group that is defined as AdminCC.

I'm running rt version 3.8.2-5.fc10 on MySQL 5.0.67-2.fc10

On Mar 13, 2009, at 10:32 AM, Ruslan Zakirov wrote:

> UseSQLForACLChecks
>
> On Fri, Mar 13, 2009 at 5:45 PM, Jon Baker <JBAKER at wgm.us> wrote:
>> This may be already addressed but I can't find it in the archives and
>> it's driving the heck out of me, especially as we expand RT into more
>> departments and fine tune access restrictions.
>>
>> The most obvious place it seems to happen is on the "X newest unowned
>> tickets" - this list appears to be generated by building a list of  
>> the
>> X newest unowned tickets in the entire system, and then if any of
>> those tickets are in queues where you have access to, they will show
>> up in the list, even though the total count is less than X and you do
>> indeed have more than X unowned tickets you should see.  I.e, if
>> another department adds 20 tickets because of some project they are
>> doing (we do a lot of parent/child tickets for steps involved to
>> accomplish the main ticket) then it appears that there are no unowned
>> tickets, which usually results in tickets getting buried and  
>> forgotten
>> about.
>>
>> A less obvious but equally frustrating scenario is when you perform a
>> search of some sort and end up with multiple blank pages because you
>> only have access to view a small number of tickets in the search
>> results.
>>
>> Is there a way to make this work as expected?  I'm hoping there might
>> be something in my configuration that is causing this.
>> --
>> Jon Baker
>> Information Technology
>> Willie George Ministries
>> 1003 N 129th E Ave
>> Tulsa OK 74116
>> (918) 234-5656
>>
>>
>> _______________________________________________
>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>> Community help: http://wiki.bestpractical.com
>> Commercial support: sales at bestpractical.com
>>
>>
>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>> Buy a copy at http://rtbook.bestpractical.com
>>
>
>
>
> -- 
> Best regards, Ruslan.

-- 
Jon Baker
Information Technology
Willie George Ministries
1003 N 129th E Ave
Tulsa OK 74116
(918) 234-5656