<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16788" name=GENERATOR></HEAD>
<BODY>
<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:8.0pt;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 <o:p></o:p></span></p>
<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></BODY></HTML>