Hi Torsten, I followed what you mention about Bulk update page and querybuilder page. It works great on old release of RT. I also have a test machine (running Fedora 9, perl 5.10, mysql 5.0), where I installed RT3.8.1 In RT 3.8.1, it looks like PickBasics program was modified, and it does not have the line you mention to modify. So, as a work around, I copied PickBasics file from older release of RT, and it seems to be working. Now, I do not have a drop down with the list of all RT users, it displays a text input box, which is fine (atleast the page loads in fraction of a second). This week, I will work on installing RT 3.8.2 back on my test machine and see if my work around works with it. I (and the users) really do appreciate your help with this...
--- On Sat, 1/24/09, Ham MI-ID, Torsten Brumm <[email protected]> wrote: From: Ham MI-ID, Torsten Brumm <[email protected]> Subject: AW: [rt-users] Strange,long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI To: [email protected], "Emmanuel Lacour" <[email protected]> Cc: [email protected] Date: Saturday, January 24, 2009, 2:43 AM 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 Kühne + Nagel (AG & Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann (Vors.), Uwe Bielang (Stellv.), Dirk Blesius (Stellv.), Bruno Mang, Alfred Manke, Christian Marnetté (Stellv.), Mark Reinhardt (Stellv.), Jens Wollesen, Rainer Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Persönlich haftende Gesellschaft: Kühne & Nagel A.G., Sitz: Contern/Luxemburg, Geschäftsführender Verwaltungsrat: Klaus-Michael Kühne 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
