Yes, AND...not OR...correct...typo on my part. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Tuesday, July 22, 2008 3:33 PM To: arslist@ARSLIST.ORG Subject: Re: Unqualified Searches in Very Large Enterprises -- Thoughts, Please
True ... Advanced Only search users would fall victim to it (We are lucky here in that the users who use the Advanced Search bar also use at least 1 of the fields). FYI: The Run if is all AND qualifications (If a = $NULL$ and b = $NULL$ and ... throw error). -----Original Message----- 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 3:18 PM To: arslist@ARSLIST.ORG 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 Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Tuesday, July 22, 2008 3:17 PM To: arslist@ARSLIST.ORG Subject: Re: Unqualified Searches in Very Large Enterprises -- Thoughts, Please Hmmm...that's an idea...it's more than 10 fields, but it could be... If A = $NULL$ or B = $NULL$ or C = $NULL$ . . . or ZZZ = $NULL$ then throw error. Actually...that's a very good idea. I would have to be sure to include every possible searchable field, but that's doable. -----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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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 ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
