No subject


Tue Sep 16 17:51:04 EDT 2008 

Torsten


Kuehne + Nagel (AG & Co.) KG, Geschaeftsleitung: Hans-Georg Brinkmann =
(Vors.), Uwe Bielang (Stellv.), Bruno Mang, Dirk Blesius (Stellv.), =
Alfred Manke, Christian Marnett=E9 (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: rt-users-bounces at lists.bestpractical.com =
[mailto:rt-users-bounces at lists.bestpractical.com] Im Auftrag von kem cho
Gesendet: Freitag, 23. Januar 2009 22:19
An: Emmanuel Lacour
Cc: rt-users at lists.bestpractical.com
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.
=20
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.
=20
Thanks for your help.
=20
=20
=20


--- On Fri, 1/23/09, Emmanuel Lacour <elacour at easter-eggs.com> wrote:


	From: Emmanuel Lacour <elacour at easter-eggs.com>
	Subject: Re: [rt-users] Strange, long running MySQL Query under RT =
3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI
	To: rt-users at lists.bestpractical.com
	Date: Friday, January 23, 2009, 11:51 AM
=09
=09
	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..."
	> =20
	> I am having exactly the same problem, but cannot find which file / =
code
	is controlling this.=20
	> =20
=09
	share/html/Search/Bulk.html, replace the line with =
/Elements/SelectOwner
	with a text input field using the same name.
=09
	_______________________________________________
	http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
=09
	Community help: http://wiki.bestpractical.com
	Commercial support: sales at bestpractical.com
=09
=09
	Discover RT's hidden secrets with RT Essentials from O'Reilly Media.=20
	Buy a copy at http://rtbook.bestpractical.com




------_=_NextPart_001_01C97DFF.B96D1F3A
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.6000.16788" name=3DGENERATOR></HEAD>
<BODY>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D504073908-24012009><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>Hi Kem,</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D504073908-24012009><FONT =
face=3DArial=20
color=3D#0000ff size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D504073908-24012009><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>same problem here, the querybuilder page was =
also slow=20
until i got a hint from jesse:</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D504073908-24012009><FONT =
face=3DArial=20
color=3D#0000ff size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D504073908-24012009><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>Make first a local copy of=20
/rthome/share/html/Search/Elements/PickBasics to=20
/rthome/local/html/Search/Elements/PickBasics </FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D504073908-24012009><FONT =
face=3DArial=20
color=3D#0000ff size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D504073908-24012009><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>Replace here:</FONT></SPAN></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2>&lt;&amp; =
/Elements/SelectOwner, Name=20
=3D&gt; "ValueOfActor", ValueAttribute =3D&gt; 'Name' =
&amp;&gt;</FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2></FONT>&nbsp;</DIV>
<DIV><SPAN class=3D504073908-24012009><FONT face=3DArial color=3D#0000ff =

size=3D2>With:</FONT></SPAN></DIV>
<DIV><SPAN class=3D504073908-24012009><FONT face=3DArial color=3D#0000ff =

size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D504073908-24012009><FONT face=3DArial color=3D#0000ff =

size=3D2>&lt;input name=3D"ValueOfActor"&gt;</FONT></SPAN></DIV>
<DIV><SPAN class=3D504073908-24012009><FONT face=3DArial color=3D#0000ff =

size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D504073908-24012009><FONT face=3DArial color=3D#0000ff =
size=3D2>From=20
now QueryBuilder Page is much, much faster!</FONT></SPAN></DIV>
<DIV><SPAN class=3D504073908-24012009><FONT face=3DArial color=3D#0000ff =

size=3D2><BR>Torsten</FONT></SPAN></DIV>
<DIV><BR></DIV>
<br>
<p class=3DMsoBodyText><span =
style=3D'font-size:8.0pt;font-family:Arial'>K&uuml;hne +
Nagel (AG &amp; Co.) KG, Gesch&auml;ftsleitung: Hans-Georg Brinkmann =
(Vors.), Uwe <span
class=3DSpellE>Bielang</span> (Stellv.), Dirk Blesius (Stellv.), Bruno =
Mang, Alfred <span
class=3DSpellE>Manke</span>, Christian Marnett=E9 (Stellv.), Mark =
Reinhardt (Stellv.), Jens <span
class=3DSpellE>Wollesen</span>, Rainer <span class=3DSpellE>Wunn</span>,
Sitz: Bremen, Registergericht: Bremen, HRA 21928, <span =
class=3DSpellE>USt-IdNr</span>.:
DE 812773878, Pers&ouml;nlich haftende Gesellschaft: K&uuml;hne &amp; =
Nagel A.G., Sitz: <span
class=3DSpellE>Contern/Luxemburg</span>, Gesch&auml;ftsf&uuml;hrender =
Verwaltungsrat:
Klaus-Michael K&uuml;hne <o:p></o:p></span></p>

<br><DIV class=3DOutlookMessageHeader lang=3Dde dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
<FONT face=3DTahoma size=3D2><B>Von:</B> =
rt-users-bounces at lists.bestpractical.com=20
[mailto:rt-users-bounces at lists.bestpractical.com] <B>Im Auftrag von =
</B>kem=20
cho<BR><B>Gesendet:</B> Freitag, 23. Januar 2009 22:19<BR><B>An:</B> =
Emmanuel=20
Lacour<BR><B>Cc:</B> rt-users at lists.bestpractical.com<BR><B>Betreff:</B> =
Re:=20
[rt-users] Strange,long running MySQL Query under RT 3.6.5 / MySQL =
5.0.67=20
/Apache2.2.3/FastCGI<BR></FONT><BR></DIV>
<DIV></DIV>
<TABLE cellSpacing=3D0 cellPadding=3D0 border=3D0>
  <TBODY>
  <TR>
    <TD vAlign=3Dtop>
      <DIV>Emmanuel,</DIV>
      <DIV>I&nbsp;also wanted to know if there is a way to edit =
the&nbsp;query=20
      that runs when QueryBuilder page loads? (Search/Build.html) I am =
unable to=20
      find this, as I am not quite a perl expert.</DIV>
      <DIV>&nbsp;</DIV>
      <DIV>This is because we&nbsp;have&nbsp;an issue in&nbsp;RT where =
it=20
      displays many many users&nbsp;as "Owner" in QueryBuilder page, but =
when I=20
      run a query from mysql prompt, it only shows me handful of users =
with=20
      "OwnTicket" right. Based on this, to me it feels like my data is =
correct,=20
      but I could be wrong, as I have been working with RT software for =
only a=20
      month now.</DIV>
      <DIV>&nbsp;</DIV>
      <DIV>Thanks for your help.</DIV>
      <DIV>&nbsp;</DIV>
      <DIV>&nbsp;</DIV>
      <DIV>&nbsp;</DIV>
      <DIV><BR><BR>--- On <B>Fri, 1/23/09, Emmanuel Lacour=20
      <I>&lt;elacour at easter-eggs.com&gt;</I></B> wrote:<BR></DIV>
      <BLOCKQUOTE=20
      style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: =
rgb(16,16,255) 2px solid">From:=20
        Emmanuel Lacour &lt;elacour at easter-eggs.com&gt;<BR>Subject: Re:=20
        [rt-users] Strange, long running MySQL Query under RT 3.6.5 / =
MySQL=20
        5.0.67 /Apache2.2.3 /FastCGI<BR>To:=20
        rt-users at lists.bestpractical.com<BR>Date: Friday, January 23, =
2009,=20
        11:51 AM<BR><BR><PRE>On Fri, Jan 23, 2009 at 09:40:34AM -0800, =
kem cho wrote:
&gt; Do you know which file controls this drop down box? "...replacing =
the
dropdown with a normal textbox..."
&gt; &nbsp;
&gt; I&nbsp;am having&nbsp;exactly the same problem, but&nbsp;cannot =
find which file / code
is controlling this.=20
&gt; &nbsp;

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 at bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.=20
Buy a copy at http://rtbook.bestpractical.com
</PRE></BLOCKQUOTE></TD></TR></TBODY></TABLE><BR></BODY></HTML>


------_=_NextPart_001_01C97DFF.B96D1F3A--

More information about the RT-Users mailing list