FetchXML get total count of record

(0) Share

Report

Posted on by sdnd2000

2,510

Hi, by default, Fetchxml gets 5000 results, what if the result is after 5000, I have to call multiple times?

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Suggested answer

Gopalan Bhuvanesh 11,401 on at

Like (0)

Report

Hi

You would have to use paging cookie.

Please refer the following:

https://msdn.microsoft.com/en-us/library/gg328046.aspx

Was this reply helpful? Yes No
sdnd2000 2,510 on at

Like (0)

Report

The link doesn't work

Was this reply helpful? Yes No
Brekh 192 on at

Like (0)

Report

Hi,

You can check for Morerecords property from the resultset of Entity collection and use pagingCookie. Below link shows the example.

stackoverflow.com/.../how-to-fetch-more-than-5000-entities-from-crm

Hope this helps.

Was this reply helpful? Yes No
Suggested answer

Thomas David Dayman 11,323 on at

Like (0)

Report

If you download XRMToolBox and download the Record Counter plugin :)

Was this reply helpful? Yes No
Gopalan Bhuvanesh 11,401 on at

Like (0)

Report

msdn.microsoft.com/.../gg328046.aspx

Was this reply helpful? Yes No
Suggested answer

BadrinathB 970 on at

Like (0)

Report

What is your exact requirement?

If you have to fetch more than 5k records then you can use either paging concept or update system settings to fetch more record.

The below link will help you to understand better.

www.softchief.com/.../retrieve-more-than-5000-records-in-dynamics-crm

Was this reply helpful? Yes No
sdnd2000 2,510 on at

Like (0)

Report

I can use linq to retrieve all records?

Was this reply helpful? Yes No
ashlega 34,477 on at

Like (0)

Report

You can use a paging cookie with Fetch (that link Gopalan provided seems to work fine.. at least today)

You can use Linq, just keep in mind it'll work slightly differently - I believe it will try to grab all records at once, so this may take a while if you have too many. Also, it will be retrieving all entity attributes (unlike fetch where you can specify which exactly)

Was this reply helpful? Yes No
sdnd2000 2,510 on at

Like (0)

Report

yes, I understand, I have to use earlybound

Was this reply helpful? Yes No
Verified answer

ashlega 34,477 on at

Like (0)

Report

You can do it with latebound (if we are talking about linq), just need to follow a workaround descrbied here:

community.dynamics.com/.../querying-crm-data-with-linq

Was this reply helpful? Yes No