el

Retrieve 5000 + records using fetchXML in CRM 2011

Monday, October 17, 2016

Last time I was working on fetchXML. It was working for me properly but later our client told us that it won't retrieve more than 5000 records. This was a new case for me. When I searched more about it, I found that it was true. Microsoft has limited the count of records user can see per page, which is 5000 only using FetchXML. So after some more digging I found a pretty easy bypass for this by which we can turn of paging feature. For this follow below steps. 1. Open the registry and locate 'HKEY_LOCAL_MACHINE\Software\Microsoft\MSCRM'. 2. Add new DWORD key as TurnOffFetchThrottling 3. Set the key value as 1. Remember this is unsupported method, so in future after installing rollups you may need to set this value again. Hope this helps you By: Pramod Vilas Zite

No items found.