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
