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

[Emmanuel Lacour]

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 at easter-eggs.com  -   http://www.easter-eggs.com