Advanced Query Patch

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?

— 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 &>

- - -<&|/l&>Owner -<&|/l&>Creator -<&|/l&>LastUpdatedBy - - -<& /Elements/SelectBoolean, Name => "ActorOp", - TrueVal=> '=', - FalseVal => '!=' -&> - -<& /Elements/SelectOwner, Name => "ValueOfActor" &> - - <& SelectPersonType, Name => 'WatcherField', Default => 'Requestor' &>

Dermot Williams

Network Operations Engineer
Irish Broadband Internet Services Ltd.

Dermot Williams said:

Hi,

>
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?

See RTx-Shredder at http://search.cpan.org/~ruz/RTx-Shredder/

Dermot Williams said:

Hi,

>
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?

See RTx-Shredder at http://search.cpan.org/~ruz/RTx-Shredder/
(Sorry sam did not maen to mail you directly first time …did not do reply
all)
Does RTx-Shredder remove/delete users? I do not think earlier versions did.
If it does not can some one suggest a tool or a way to remove undesired
users .

Many thanks.

Roy