I think you want to use "AND", not "OR". If they are all null, then throw the error. You can take care of the Advanced Search Bar by adding: ... AND '1005' = $NULL$
to your qualification. 1005 is the field id for the Advanced Search bar. I just tested it on a basic form (6.3 server) and it seems to work. Thad Esser Remedy Developer "Argue for your limitations, and sure enough, they're yours."-- Richard Bach Kaiser Norm E CIV USAF 96 CS/SCCE <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 07/22/2008 01:18 PM Please respond to [email protected] To [email protected] cc Subject Re: Unqualified Searches in Very Large Enterprises -- Thoughts, Please Oh...clicked SEND too soon...your idea is good but people who use the Advanced Search Bar would fall victim to the error. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Tuesday, July 22, 2008 3:11 PM To: [email protected] Subject: Re: Unqualified Searches in Very Large Enterprises -- Thoughts, Please ** Is there any specific fields they add data to before searching? We have a similar situation where tech will add data to at least 1 of probably 10 different fields. We have an AL that fires on search and display's an error if all 10 of them are NULL. The problem with the limit rows returned setting is it does not alter the call to the database. It only grabs the top x rows from the database results so even with a setting of 1000 the database pulls all 150,000 rows where Remedy only display's 1000. Fred ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Tuesday, July 22, 2008 2:25 PM To: [email protected] Subject: Unqualified Searches in Very Large Enterprises -- Thoughts, Please Hi everyone: I wanted to get everyone's take on this thorny issue...I know this matter has been discussed many times before, but I wanted to put a new twist on it. Specifically, I wanted to get anyone and everyone's thoughts on the problem of unqualified searches in a large enterprise. Specifically, suppose the following: Suppose you have a custom app being used in a very large environment. Suppose in that environment you have established a ticket isolation system by setting hidden fields on the form on SEARCH. Tickets are isolated by every company within the enterprise. Now, each company has in excess of 150,000 tickets, and there are 20 companies. The problem is, techs are accidentally clicking the SEARCH button without any qualification...kicking off what is *seemingly* an unqualified search. But the search is not truly unqualified because fields are getting set on SEARCH to effect the ticket isolation. But the problem remains - such a search goes out and attempts to fetch 150,000+ tickets. Several techs accidentally doing this at once (we have 800+ techs, so the possibility of techs doing this is pretty high) causes the server to slow way down. Thoughts on how to minimize this issue? Hopefully I've described the problem well enough. TIA, Norm __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.*** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
