FetchXML schema - specifiying number of records to return

Hi,

I am trying to establish whether there is any way of using the Query object
to return only a certain number of records from the CRM db. I have a a very
simple app that either prompts a user for query conditions, or alternatively
returns all objects from the specified entity (account/contact etc). The
problem is that the db has upwards of 25,000 contacts, and the result set is
huge. I cannot find anything in the FetchXML schema that suggests I can
specifiy a number of records to return. If anyone can help me that would be
great.

Cheers

Chris

Anna
Mon Aug 23 04:34:32 CDT 2004

Hi Chris
I havnt found a way to restrict the rows returned,
however when i read through the xml and bind to a dataset
or datatable i restrict the count to 50. Although this
will be the first 50 of the results set. I therefore had
to include more options for the user, like search
starting with 'A' or 'Abc'

You would have thought they would have included a top *
or similar, but i cant find it either.


>-----Original Message-----
>Hi,
>
>I am trying to establish whether there is any way of
using the Query object
>to return only a certain number of records from the CRM
db. I have a a very
>simple app that either prompts a user for query
conditions, or alternatively
>returns all objects from the specified entity
(account/contact etc). The
>problem is that the db has upwards of 25,000 contacts,
and the result set is
>huge. I cannot find anything in the FetchXML schema
that suggests I can
>specifiy a number of records to return. If anyone can
help me that would be
>great.
>
>Cheers
>
>Chris
>
>
>.
>

Vinícius
Mon Aug 23 07:21:35 CDT 2004

You must set the count property of the fecth tag.
Eg:
<fetch mapping='logical' count='50'>
...
</fetch>

Hope this helps.
[]'s
Vinícius Pitta Lima de Araújo

"Chris Ericoli" <cericoliNOspm@removethisfamill.com.au> escreveu na mensagem
news:O8f7QzKiEHA.1048@tk2msftngp13.phx.gbl...
> Hi,
>
> I am trying to establish whether there is any way of using the Query
object
> to return only a certain number of records from the CRM db. I have a a
very
> simple app that either prompts a user for query conditions, or
alternatively
> returns all objects from the specified entity (account/contact etc). The
> problem is that the db has upwards of 25,000 contacts, and the result set
is
> huge. I cannot find anything in the FetchXML schema that suggests I can
> specifiy a number of records to return. If anyone can help me that would
be
> great.
>
> Cheers
>
> Chris
>
>