Share
ReportHi, 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
You’re offline. This is a read only version of the page.
2,397
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
True that linq to crm will retrieve all records even if it's > 5000. It's better than fetchxml in the sense that you don't have to run a while loop, 5000 at a time to get everything. Codes is cleaner.
But do bear in mind, that in the background, crm is running a 5000 at a time query against sql.
You can do it with latebound (if we are talking about linq), just need to follow a workaround descrbied here:
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)
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
If you download XRMToolBox and download the Record Counter plugin :)
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.
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
