Favorite Links
Archives by Tag 'lists'

Increasing Paging Limits

By Carlton Colter - Last updated: Tuesday, February 10, 2009

Paging Limits control how many items show up on the list pages in crm. Most notably advanced finds. I like to be able to display a lot of information, and I need to be able to run operations on more than 250 items. Using the following SQL query I was able to increase my paging limit to 1000. 

UPDATE UserSettings SET PagingLimit=1000 WHERE SystemUserId IN
(Select SystemUserId from SystemUserBase WHERE FullName like 'Carlton%')

Click Here To View Post With Syntax Highlighting

Copyright © 2009 MSCRM Blogger

MSCRM Blogger has made every effort to supply trademark information about company names, products and services mentioned on this service. All third party trademarks are the property of their respective owners.

Any rights not expressly granted herein are reserved.

Use at your own risk. Some of our code may use unsupported methods, or if used improperly break your system. We are not responsible for your system and request that you use a test environment first. If you run into problems and need assistance, please post a comment and we might try to help you.