Theresa:
I would try ORDER BY C3 DESC. That should sort them newest to oldest. Put this between the WHERE and HAVING parts. It might work.
James McKenzie
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Fannin, Teresa
Sent: Friday, July 07, 2006 1:15 PM
To: [email protected]
Subject: Re: Can you restrict searches to eg TOP 100 - like in SQL?
Sorry to piggyback but when you set the Limit Number of Items Returned in the AR System User Preference form that is from oldest to newest. Can that be switched to newest to oldest for just that one user. It sounds from this email you can't unless you do this with some direct SQL. Do I have this right?
Thanks,
Teresa
________________________________
From: Action Request System discussion list(ARSList) on behalf of Axton
Sent: Fri 7/7/2006 10:09 AM
To: [email protected]
Subject: Re: Can you restrict searches to eg TOP 100 - like in SQL?
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
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
