You got it. Axton
On 7/7/06, McKenzie, James J C-E LCMC HQISEC/L3 <[EMAIL PROTECTED]> wrote:
** Axton: I understood exactly what you meant. In my case I run with Oracle so the select would be something like this: SELECT C536870914 FROM T165 WHERE C3 < 1234566789 HAVING rownum < 100; This would select the first 100 entries in Table T165 (let's say for work purposes this is the HPD:HelpDesk form) and return the values in Column C536870914 (let's say that this is a time field that I added to this form). Now you have to have a process that handles this return. Of course this would be a Direct SQL action. James McKenzie -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Grams Sent: Friday, July 07, 2006 5:37 AM To: [email protected] Subject: Re: Can you restrict searches to eg TOP 100 - like in SQL? Was responding to James's comment: "I don't think it is possible to set a limit to the number of returned items in an SQL statement other than careful selection of the WHERE portion of the SELECT statement." That's why I started the message with slightly off-topic Axton Serouche Rahimpour wrote: > hi, > > just to be sure I understand the concern correctly: > in the Advanced Search bar you type something like "select <columns> > from <table> where <conditions> and/or <chunks>" ? > Or was Angus just refering to the use of the relational operators ? > Because I am not sure whether we could use select top ... or select ... > rownum. Could we ? > Thanks lightening the dark. > Serouche > > > > Axton Grams wrote: > >> Slightly off-topic, but for sql statements... >> >> SQL Server: >> select top 100 a,b,c from x where y = z >> >> Oracle: >> select a,b,c from x where y = z having rownum < 100 >> >> Axton Grams >> >> McKenzie, James J C-E LCMC HQISEC/L3 wrote: >> >> >>> ** >>> Angus: >>> >>> Please accept my apologies as I remember it being there. I just >>> checked again and could not find it. This is sad. >>> >>> However, it is possible to use the User Preferences form to set this >>> value for a particular user. Otherwise, you would have to set this >>> value for the entire server. I don't think it is possible to set a >>> limit to the number of returned items in an SQL statement other than >>> careful selection of the WHERE portion of the SELECT statement. >>> >>> James McKenzie >>> >>> >>> -------------------------------------------------------------------- >>> ---- >>> *From:* Action Request System discussion list(ARSList) >>> [mailto:[EMAIL PROTECTED] *On Behalf Of *Angus Comber >>> *Sent:* Thursday, July 06, 2006 1:33 PM >>> *To:* [email protected] >>> *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 >>> <mailto:[EMAIL PROTECTED]> >>> *Newsgroups:* public.remedy.arsystem.general >>> *To:* [email protected] <mailto:[email protected]> >>> *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:[EMAIL PROTECTED] On Behalf Of Angus Comber >>> Sent: Thursday, July 06, 2006 12:50 PM >>> To: [email protected] >>> 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___ >>> >> >> _____________________________________________________________________ >> __________ >> >> UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org >> >> >> > > ______________________________________________________________________ > _________ > > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125_______________________This posting was submitted with HTML in it___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
