Hi Kem, same problem here, the querybuilder page was also slow until i got a hint from jesse: Make first a local copy of /rthome/share/html/Search/Elements/PickBasics to /rthome/local/html/Search/Elements/PickBasics Replace here: <& /Elements/SelectOwner, Name => "ValueOfActor", ValueAttribute => 'Name' &> With: <input name="ValueOfActor"> >From now QueryBuilder Page is much, much faster!
Torsten Kuehne + Nagel (AG & Co.) KG, Geschaeftsleitung: Hans-Georg Brinkmann (Vors.), Uwe Bielang (Stellv.), Bruno Mang, Dirk Blesius (Stellv.), Alfred Manke, Christian Marnetté (Stellv.), Mark Reinhardt (Stellv.), Jens Wollesen, Rainer Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Persoenlich haftende Gesellschaft: Kuehne & Nagel A.G., Sitz: Contern/Luxemburg Geschaeftsfuehrender Verwaltungsrat: Klaus-Michael Kuehne ________________________________ Von: [email protected] [mailto:[email protected]] Im Auftrag von kem cho Gesendet: Freitag, 23. Januar 2009 22:19 An: Emmanuel Lacour Cc: [email protected] Betreff: Re: [rt-users] Strange,long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI Emmanuel, I also wanted to know if there is a way to edit the query that runs when QueryBuilder page loads? (Search/Build.html) I am unable to find this, as I am not quite a perl expert. This is because we have an issue in RT where it displays many many users as "Owner" in QueryBuilder page, but when I run a query from mysql prompt, it only shows me handful of users with "OwnTicket" right. Based on this, to me it feels like my data is correct, but I could be wrong, as I have been working with RT software for only a month now. Thanks for your help. --- On Fri, 1/23/09, Emmanuel Lacour <[email protected]> wrote: From: Emmanuel Lacour <[email protected]> Subject: Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI To: [email protected] Date: Friday, January 23, 2009, 11:51 AM On Fri, Jan 23, 2009 at 09:40:34AM -0800, kem cho wrote: > Do you know which file controls this drop down box? "...replacing the dropdown with a normal textbox..." > > I am having exactly the same problem, but cannot find which file / code is controlling this. > share/html/Search/Bulk.html, replace the line with /Elements/SelectOwner with a text input field using the same name. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
