Friday, February 14, 2014

Increase CRM Paging Limit for User

Below is an unsupported method for increasing the number of records in each page of a view.  This setting is individual to each users.  In the case below we are updating it for the user related to the DOMAIN\User account.  This is not recommended for normal user but I find it helpful when I need to add 2000 plugin steps to a solution.

UPDATE US
SET US.[PagingLimit] = 1000
FROM [Default_MSCRM].[dbo].[UserSettings] US
LEFT JOIN [Default_MSCRM].[dbo].[SystemUser] SU ON SU.SystemUserId = US.SystemUserId
WHERE SU.[DomainName] like 'DOMAIN\User'

No comments: