Yes ... and that does limit the number of results returned but it does limit
the number of rows fetched which was what I was looking for. I don't think I
made that clear
We are getting the following error (404) from Sybase when there are too many
rows being returned:
"Too many ANDS or ORs in expression (limit 1024 per expression level)"
Remedy is putting togetehr a query like: select * from ??? where c1 in
("1","2","3","4"). It puts each ID in the IN clause until it runs into the
Sybase limit.
On Fri, Jul 25, 2008 at 11:23 AM, Robert Halstead <[EMAIL PROTECTED]>
wrote:
> ** Frank,
>
> On a getList operation in the web service click on output mapping. Then
> click on the child element under ROOT on the XML Data Type side of the
> window. Bring up the properties of the getListValues element. Set the
> MaxOccurs from unbounded to a specified number.
>
> This is on 6.3 patch 20.
>
> On Wed, Jul 23, 2008 at 10:46 AM, Frank Caruso <[EMAIL PROTECTED]>
> wrote:
>
>> **
>> Any other suggestions on how to limit the number of rows returned from a
>> Web Service
>>
>>
>> On Tue, Jul 22, 2008 at 9:45 AM, Frank Caruso <[EMAIL PROTECTED]>
>> wrote:
>>
>>> Don't see this as an option. I am on 6.3 p20
>>>
>>>
>>> On Sat, Aug 11, 2007 at 2:42 AM, ITSM Support <[EMAIL PROTECTED]>
>>> wrote:
>>>
>>>> **
>>>>
>>>> *Hi Frank,*
>>>>
>>>>
>>>>
>>>> Yes, we can limit the number of rows returned while publishing the
>>>> services in remedy.
>>>>
>>>> While creating web service for the get operation or get list operation
>>>> in remedy, below the Qualification there is two options called *Start
>>>> record* and *Max Limit*.
>>>>
>>>> Where we can limit the number of rows return.
>>>>
>>>>
>>>>
>>>> Hope this helps...
>>>>
>>>>
>>>>
>>>> Regards,
>>>>
>>>>
>>>>
>>>> *Sandeep *
>>>>
>>>> *Vyom Labs Pvt. Ltd. *
>>>>
>>>> *An ISO 20000 certified company. *
>>>>
>>>> *Consulting | Outsourcing | Training || BMC Remedy BSM | ITIL *
>>>>
>>>> *Web: www.vyomlabs.com*
>>>>
>>>>
>>>> ------------------------------
>>>>
>>>> *From:* Action Request System discussion list(ARSList) [mailto:
>>>> [EMAIL PROTECTED] *On Behalf Of *Frank Caruso
>>>> *Sent:* Tuesday, July 22, 2008 12:06 AM
>>>> *To:* [email protected]
>>>> *Subject:* Limiting Web Service Results
>>>>
>>>>
>>>>
>>>> **
>>>>
>>>> Is there a way that a consumer of a Remedy web service can limit the
>>>> number of rows returned?
>>>> Or, is there something I can do to the web service in Remedy to only
>>>> allow so many results to be returned.
>>>>
>>>> Thank you
>>>>
>>>> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>>>> html___
>>>> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>>>> html___
>>>
>>>
>>>
>> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>> html___
>>
>
>
>
> --
> "A fool acts, regardless; knowing well that he is wrong. The ignoramus acts
> on only what he knows, but all that he knows.
> The ignoramus may be saved, but the fool knows that he is doomed."
>
> Robert Halstead
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
