Feb 102009
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%')
Posted by Carlton Colter at 9:37 am
Tagged with: advanced find, crm4, lists, paging, sql


Of course, this customization is not supported. Changes are small that this will break the system in the future, but still worth to note.
Is there any chance to change next limit:
When you trying to add some entity to N:N relation, and use find entity form,
keep search text box empty and press search button (for example), I see a hint that there was more than 100 entities found, but displayed only first 100.
I’m not sure on that one. There may be a way.