[rt-users] Change "RT @ A Glance" selection criteria

[Thomas Sibley]

On 05/30/2013 12:55 AM, Danie Brink wrote:
> Is it possible for us to change the SQL query that is run for the "RT at
> a glance" front page that shows the last 10 unowned new tickets? With
> our RT Ticket count hovering around 4million the current query performs
> a complete table scan to sort the show the last 10 (filtered) so we
> would like to customize it more for our needs.
> 
> Any pointers where to look for and modify this query? (We're on RT3.8.7).

I suspect you want the $UseSQLForACLChecks option:
http://bestpractical.com/rt/docs/latest/RT_Config#UseSQLForACLChecks