[rt-users] "Tickets" interface stalls RT for 30 seconds.

[Golemon, Buck]

Thanks. I got it working. Here's the patch I needed for 3.8.1.

--- orig.bak    2008-09-12 14:14:23.000000000 -0700
+++ share/html/Search/Elements/PickBasics       2008-09-12
14:14:33.000000000 -0700
@@ -121,11 +121,7 @@
             Path => '/Elements/SelectBoolean',
             Arguments => { TrueVal=> '=', FalseVal => '!=' },
         },
-        Value => {
-            Type => 'component',
-            Path => '/Elements/SelectOwner',
-            Arguments => { ValueAttribute => 'Name' },
-        },
+        Value => { Type => 'text', Size => 50 }
     },
     {
         Name => 'Watcher',




This probably doesn't help, but this query gives the full list of user
names that might give results. It runs in a reasonable time and returns
only 7% of the results done the current way.

select distinct name from Users, Tickets where Users.id in
(Tickets.owner, Tickets.Creator, Tickets.LastUpdatedBy);

--Buck


-----Original Message-----
From: Stephen Turner [mailto:sturner at MIT.EDU] 
Sent: Friday, September 12, 2008 1:47 PM
To: Golemon, Buck; Jesse Vincent
Cc: RT Users
Subject: Re: [rt-users] "Tickets" interface stalls RT for 30 seconds.


On Fri, 12 Sep 2008 16:35:02 -0400, Golemon, Buck <Buck.Golemon at amd.com>

wrote:

>
> Steve: how did you convert to a text box. Is it a straightforward
patch?
>

It's a simple change to html/Search/Elements/PickBasics (we're using RT

3.4.2):

< <& /Elements/SelectOwner, Name => "ValueOfActor", ValueAttribute =>  
'Name' &>
---
> <input name="ValueOfActor" size=20 maxlength="200">

Looking at the QB screen again, I remembered another reason we made the

change is that this criteria line can also be used to search on Creator

and LastUpdatedBy. If the drop-down is only populated by potential
ticket  
owners, then you can't search for a creator or lastupdated unless they  
happen to be in the owner list.

Steve