We have an active link on our biggest forms that checks the Advanced
Search Criteria field (ID 1005) along with some combinations of our
other fields. Something like this:
'Search Criteria' = $NULL$
AND
(
('Description' != $NULL$ OR 'Work Log' != $NULL$ OR 'Solution' !=
$NULL$)
AND
('Assignee' = $NULL$ AND 'User ID' = $NULL$ AND 'Create Date' =
$NULL$)
)
We have about 20 fields indexed on one big form and we actually check to
make sure that one of them has a value. If all of them are null, and
they specify something in a large text field, and the advanced search is
null, then we throw an error. I realize the advanced search still gives
them free reign to do whatever they want, but most of the people who
don't know how to form a good search also don't know how to use the
advanced search bar. It's the ones who know enough to try using the
advanced search but do so very poorly that still hurt us from time to
time. But this workflow cuts out a lot of bad QBE searches.
Chad Hall
(501) 342-2650
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Shawn Stonequist
Sent: Wednesday, January 03, 2007 8:57 AM
To: [email protected]
Subject: Re: Performance Issues caused by User Queries - Remedy
6.3/Oracle 10.0.2
Thanks you Axton, Patrick, & Lars!!!
We really appreciate the input so far and I've taken these suggestions
to
the "powers that be" for discussion!!
I look forward to any other ideas that may be out there!
Thank you all again!!
Shawn Stonequist
EMNS, Inc.
________________________________________________________________________
_______
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"
*************************************************************************
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be
legally privileged.
If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.
If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.
Thank you.
*************************************************************************
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
