- Posts tagged Records
- Explore Records on posterous
Get past the 250 records per page limit
Dynamics CRM 4 only allows users to view a maximum of 250 records per page within a view. This can be quite limiting when you need to run an on demand workflow against thousands of records.
There are 2 ways to get around this limit. The Microsoft supported solution is to use a plugin as described here. The unsupported and more risky workaround (and what I did...) is to update the organisation database directly as below.
UPDATE UserSettingsBase SET PagingLimit=1000 WHERE SystemUserId IN (Select SystemUserId from SystemUserBase WHERE FullName = 'neil mcdonald')
If using the SQL method, I recommend that you change it back to 250 rows or less once you've accomplished your tasks, as this is not supported by Microsoft and could cause errors with future updates.
