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
