[rt-users] Advanced Query Patch

[Dermot Williams]

Hi,

We've come across a 'problem' with the advanced query tool recently.
Basically, because we've now got over 8000 requestor emails in the
backend db, it was taking between 25 and 40 seconds for the Query
Builder page to open (I'm convinced that most of the delay is caused by
the client's browser, rather than the actual speed at which the MySQL
server can run the query). Our Customer Service manager was getting very
frustrated as result ( a sizable portion of his day is spent searching
for prior history for clients). Since the part of the builder that uses
the requestor email addresses is pretty redundant (the very next field
does pretty much the same job and then some), I decided to remove it.
The patch for my change is below. Some of you guys might find this
useful.

On a related note, does anyone have a nice tool that will remove all
tickets that are marked as deleted and then remove all users that no
longer have a ticket associated with them?

<code>

--- PickBasics.bak      2005-04-28 14:51:29.000000000 +0100
+++ PickBasics  2005-04-28 15:05:05.000000000 +0100
@@ -96,21 +96,6 @@
 <& /Elements/SelectStatus, Name => "ValueOfStatus", SkipDeleted => 1 &>
 </td>
 </tr>
-<tr><td class="label">
-<SELECT NAME="ActorField">
-<OPTION VALUE="Owner"><&|/l&>Owner</&></OPTION>
-<OPTION VALUE="Creator"><&|/l&>Creator</&></OPTION>
-<OPTION VALUE="LastUpdatedBy"><&|/l&>LastUpdatedBy</&></OPTION>
-</SELECT>
-</td><td>
-<& /Elements/SelectBoolean, Name => "ActorOp",
-                                         TrueVal=> '=',
-                                         FalseVal => '!='
-&>
-</td><td>
-<& /Elements/SelectOwner, Name => "ValueOfActor" &>
-</td>
-</tr>
 <tr>
 <td class="label">
 <& SelectPersonType, Name => 'WatcherField', Default => 'Requestor' &>

</code>

Dermot Williams
 
Network Operations Engineer
Irish Broadband Internet Services Ltd.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20050428/92573a8b/attachment.htm>