[rt-users] Bug when returning count of tickets found with query builder

[Jesse Vincent]

On Thu, Jan 26, 2006 at 12:19:35PM -0800, Schultz, Eric wrote:
> Say there are two queues, A and B.  Say I have SeeQueue/ShowTicket/etc.
> rights on queue A, but no rights at all on queue B.  Say there are 2
> tickets in each queue that have the subject "testing".
> 
> If I do a query for the subject "testing", then click "Search", I will
> get two result rows for queue A, and none for queue B, as would be
> expected.  But at the top of the page, it tells me "Found 4 tickets".
> If I was running as the superuser, I would see that there are indeed 4
> tickets, and get all four result rows.
> 
> This appears to be a problem both in the 3.4.x and the 3.5.x code.

So. It's a deliberate decision, for performance reasons. In order to
correctly show a count of only the ACLed tickets, RT would need to load
up all the tickets and walk through them one by one performing an ACL
check. Which is just too slow when you're getting back a count result of
possibly hundreds or thousands of tickets.

Jesse

> 
> Eric Schultz
> United Online, Inc.
> 818.287.3465
> 
> Call on God, but row away from the rocks.
>   - Indian proverb
>  
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
> 
> Download a free sample chapter of RT Essentials from O'Reilly Media at http://rtbook.bestpractical.com
> 
> WE'RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
> San Francisco - Find out more at http://bestpractical.com/services/training.html
> 

--