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

[Danie Brink]

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
<elacour at easter-eggs.com>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:elacour at easter-eggs.com  -   http://www.easter-eggs.com
>
>
> --
> RT Training in Seattle, June 19-20: http://bestpractical.com/training
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130530/e7c290c6/attachment.htm>