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' },
-
},
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);
–BuckFrom: Stephen Turner [mailto:sturner@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.
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’ &>
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