Re: Can you restrict searches to eg TOP 100 - like in SQL?

[Gulati, Ankur]

Title: RE: Can you restrict searches to eg TOP 100 - like in SQL?

** In the user tool, go to Tools->Options then click on Behaviours tab. You'll see an option " set number of rows returned" you can set whatever number you want to in there.   -- Ankur -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Angus Comber Sent: Friday, July 07, 2006 2:03 AM To: arslist@ARSLIST.ORG Subject: Re: Can you restrict searches to eg TOP 100 - like in SQL? ** There does not appear to be a way to restrict number of records returned in the user tool.   Angus   ----- Original Message ----- From: McKenzie, James J C-E LCMC HQISEC/L3 Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, July 06, 2006 8:53 PM Subject: Re: Can you restrict searches to eg TOP 100 - like in SQL? ** Agnus: Yes.  Check out the advanced tab for user options.  If you want to do this at the database level, I don't know of a method to do this other than a really refined query. James McKenzie -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Angus Comber Sent: Thursday, July 06, 2006 12:50 PM To: arslist@ARSLIST.ORG Subject: Can you restrict searches to eg TOP 100 - like in SQL? If I go into user tool and do an advanced search I can use SQL type syntax. But is there any means of restricting the number of records returned.  Eg the first 100? Angus _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___