Change "RT @ A Glance" selection criteria

RT Users
1

Hi there RT Users List.

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).

Regards

Danie Brink
Engineer : Open Source Systems

2

Hi there RT Users List.

Hi,

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).

log in as a super user to your RT, click on the “Modify” button on top
right of “10 unowned tickets”, then click on “Savedsearch” in front of
“You can also edit the predefined search itself”. Modify your search
criteria, then click on the right in SavedSearch" on “Update”.

Easter-eggs Sp�cialiste GNU/Linux
44-46 rue de l’Ouest - 75014 Paris - France - M�tro Gait�
Phone: +33 (0) 1 43 35 00 37 - Fax: +33 (0) 1 43 35 00 76
mailto:elacour@easter-eggs.com - http://www.easter-eggs.com

3

Thank you so much for your pointer. That was exactly what we were looking
for !

DanieOn Thu, May 30, 2013 at 10:04 AM, Emmanuel Lacour elacour@easter-eggs.comwrote:

On Thu, May 30, 2013 at 09:55:11AM +0200, Danie Brink wrote:

Hi there RT Users List.

Hi,

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).

log in as a super user to your RT, click on the “Modify” button on top
right of “10 unowned tickets”, then click on “Savedsearch” in front of
“You can also edit the predefined search itself”. Modify your search
criteria, then click on the right in SavedSearch" on “Update”.

–
Easter-eggs Spécialiste GNU/Linux
44-46 rue de l’Ouest - 75014 Paris - France - Métro Gaité
Phone: +33 (0) 1 43 35 00 37 - Fax: +33 (0) 1 43 35 00 76
mailto:elacour@easter-eggs.com - http://www.easter-eggs.com

–
RT Training in Seattle, June 19-20: http://bestpractical.com/training

4

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