<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;"><DIV>Hi Torsten,</DIV>
<DIV>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</DIV>
<DIV> </DIV>
<DIV>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).</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>I (and the users) really do appreciate your help with this...</DIV>
<DIV> </DIV>
<DIV><BR>--- On <B>Sat, 1/24/09, Ham MI-ID, Torsten Brumm <I><torsten.brumm@Kuehne-Nagel.com></I></B> wrote:<BR></DIV>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: rgb(16,16,255) 2px solid">From: Ham MI-ID, Torsten Brumm <torsten.brumm@Kuehne-Nagel.com><BR>Subject: AW: [rt-users] Strange,long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI<BR>To: kemcho12345@yahoo.com, "Emmanuel Lacour" <elacour@easter-eggs.com><BR>Cc: rt-users@lists.bestpractical.com<BR>Date: Saturday, January 24, 2009, 2:43 AM<BR><BR>
<DIV id=yiv2128152204>
<DIV dir=ltr align=left><SPAN class=504073908-24012009><FONT face=Arial color=#0000ff size=2>Hi Kem,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=504073908-24012009><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=504073908-24012009><FONT face=Arial color=#0000ff size=2>same problem here, the querybuilder page was also slow until i got a hint from jesse:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=504073908-24012009><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=504073908-24012009><FONT face=Arial color=#0000ff size=2>Make first a local copy of /rthome/share/html/Search/Elements/PickBasics to /rthome/local/html/Search/Elements/PickBasics </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=504073908-24012009><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=504073908-24012009><FONT face=Arial color=#0000ff size=2>Replace here:</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><& /Elements/SelectOwner, Name => "ValueOfActor", ValueAttribute => 'Name' &></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=504073908-24012009><FONT face=Arial color=#0000ff size=2>With:</FONT></SPAN></DIV>
<DIV><SPAN class=504073908-24012009><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=504073908-24012009><FONT face=Arial color=#0000ff size=2><input name="ValueOfActor"></FONT></SPAN></DIV>
<DIV><SPAN class=504073908-24012009><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=504073908-24012009><FONT face=Arial color=#0000ff size=2>From now QueryBuilder Page is much, much faster!</FONT></SPAN></DIV>
<DIV><SPAN class=504073908-24012009><FONT face=Arial color=#0000ff size=2><BR>Torsten</FONT></SPAN></DIV>
<DIV><BR></DIV><BR>
<P class=MsoBodyText><SPAN style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Kühne + Nagel (AG & Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann (Vors.), Uwe <SPAN class=SpellE>Bielang</SPAN> (Stellv.), Dirk Blesius (Stellv.), Bruno Mang, Alfred <SPAN class=SpellE>Manke</SPAN>, Christian Marnetté (Stellv.), Mark Reinhardt (Stellv.), Jens <SPAN class=SpellE>Wollesen</SPAN>, Rainer <SPAN class=SpellE>Wunn</SPAN>, Sitz: Bremen, Registergericht: Bremen, HRA 21928, <SPAN class=SpellE>USt-IdNr</SPAN>.: DE 812773878, Persönlich haftende Gesellschaft: Kühne & Nagel A.G., Sitz: <SPAN class=SpellE>Contern/Luxemburg</SPAN>, Geschäftsführender Verwaltungsrat: Klaus-Michael Kühne </SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=de dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>Von:</B> rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] <B>Im Auftrag von </B>kem cho<BR><B>Gesendet:</B> Freitag, 23. Januar 2009 22:19<BR><B>An:</B> Emmanuel Lacour<BR><B>Cc:</B> rt-users@lists.bestpractical.com<BR><B>Betreff:</B> Re: [rt-users] Strange,long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI<BR></FONT><BR></DIV>
<DIV></DIV>
<TABLE cellSpacing=0 cellPadding=0 border=0>
<TBODY>
<TR>
<TD vAlign=top>
<DIV>Emmanuel,</DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>Thanks for your help.</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><BR><BR>--- On <B>Fri, 1/23/09, Emmanuel Lacour <I><elacour@easter-eggs.com></I></B> wrote:<BR></DIV>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: rgb(16,16,255) 2px solid">From: Emmanuel Lacour <elacour@easter-eggs.com><BR>Subject: Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI<BR>To: rt-users@lists.bestpractical.com<BR>Date: Friday, January 23, 2009, 11:51 AM<BR><BR><PRE>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: sales@bestpractical.com
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
</PRE></BLOCKQUOTE></TD></TR></TBODY></TABLE><BR></DIV></BLOCKQUOTE></td></tr></table><br>