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

[Danie Brink]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130530/524043f2/attachment.htm>