Thank you so much for your pointer. That was exactly what we were looking for !
Danie On Thu, May 30, 2013 at 10:04 AM, Emmanuel Lacour <[email protected]>wrote: > 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:[email protected] - http://www.easter-eggs.com > > > -- > RT Training in Seattle, June 19-20: http://bestpractical.com/training >
-- RT Training in Seattle, June 19-20: http://bestpractical.com/training
