Wednesday, July 8, 2009

CRM 4.0: Increasing Page Limit for CRM Grid Views

The number of records displayed on the lookup, or for that matter any view that displays the grid has a Paging Limit to it, which can be configured for each user from the Workplace->Personalize Workspace.


The maximum value available in Workplace however is only 250. Once this value is set to 250, the number of records per page in the lookup, and all other views will be 250 records.

However, there is a workaround to increase this Paging Limit for any user from the Database.

You can use the following query to set the value to say 1000.

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

This will display 1000 records per page in views and lookups.
Cheers!
Posted by at

9 comments:

  1. AnonymousMay 28, 2010 at 2:39 AM

    This doesn't work. I updated the database and this didn't change the paging limit.

    ReplyDelete
  2. MonoJune 5, 2010 at 9:12 PM

    I've a correction: the table of the base is named "UserSettingsBase" insted of "UserSettings". The last one it's a name of a view. I paste the correct query:

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

    Anyway thanks for help!!

    ReplyDelete
  3. Tom CastigliaJanuary 26, 2011 at 5:19 AM

    This does not work for CRM 3.0. The only valid settings are 25, 50, 75, 100, 250. After changing this setting in the database to say 1000, the system would default to 25 instead.

    ReplyDelete
  4. Ananta P dasDecember 7, 2012 at 6:51 PM

    Hi, where is this change made?

    ReplyDelete
  5. AnonymousDecember 21, 2012 at 2:22 PM

    Hi Ashish,
    Is it possible to show the total number of retrieved records in an advanced find (without having to click through all pages)

    ReplyDelete
  6. UnknownJune 29, 2015 at 12:43 PM

    Thanks for sharing. Nice article a customer relationship management application makes it possible to assemble the customer data and various business reports.

    ReplyDelete
  7. yusufJune 30, 2023 at 7:48 AM

    canlı sex hattı
    heets
    salt likit
    salt likit
    puff bar
    1VAC

    ReplyDelete
  8. TBWBAugust 16, 2023 at 11:02 AM

    What is the Future of Artificial intelligence in India USA, UK and other countries

    ReplyDelete
  9. AnonymousOctober 13, 2024 at 4:42 AM

    شركة كشف تسربات المياه بالاحساء RMtxtsb6ek

    ReplyDelete

Subscribe to: Post Comments (Atom)