locked
Is there any way to increase Number of results per page in CRM 2015 Online? RRS feed

  • Question

  • Hi, 

    I know in CRM 2011 On-Premises we can increase number of results per page by running a SQL query. But is there any way to change in CRM 2015 Online. 

    Actually I need to activate more than 5000 contracts, so I was think if there is any quick way of doing rather than activating only 50 contracts at a time. 

    Thanks

    Thursday, October 29, 2015 11:38 AM

Answers

  • The page size is stored as an integer in the paginglimit attribute of the usersettings entity. This attribute is ValidForUpdate, so you could try changing the value with an UpdateRequest to the Organization web service

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Thursday, October 29, 2015 12:19 PM
    Moderator
  • I was looking for the same. Did that actually work?

    Hi, Yes it works but Maximum you can set is 500 (still better than 250 through UI).

    Please have a look here for the code: How to increase Paging Limit in Dynamics CRM 2015 Online using C#

    • Marked as answer by jattscorpion Friday, October 30, 2015 9:18 AM
    • Edited by jattscorpion Friday, October 30, 2015 9:18 AM
    Friday, October 30, 2015 9:18 AM

All replies

  • Hello,

    OOB you have possibility to switch to paging by 250 records per page.


    Dynamics CRM MVP
    My blog

    Thursday, October 29, 2015 11:48 AM
    Moderator
  • Hello,

    OOB you have possibility to switch to paging by 250 records per page.


    Dynamics CRM MVP
    My blog

    Thanks, so there is no way to increase more than 250!
    Thursday, October 29, 2015 11:49 AM
  • AFAIK there is no easy way of doing that.


    Dynamics CRM MVP
    My blog

    Thursday, October 29, 2015 12:15 PM
    Moderator
  • The page size is stored as an integer in the paginglimit attribute of the usersettings entity. This attribute is ValidForUpdate, so you could try changing the value with an UpdateRequest to the Organization web service

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Thursday, October 29, 2015 12:19 PM
    Moderator
  • I was looking for the same. Did that actually work?
    Thursday, October 29, 2015 12:27 PM
  • The page size is stored as an integer in the paginglimit attribute of the usersettings entity. This attribute is ValidForUpdate, so you could try changing the value with an UpdateRequest to the Organization web service

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Hi David, Thanks for the idea, I managed to update it but maximum you can set it 500. When I tried to set PagingLimit to 501 it throws the following error.

    "Additional information: Paging limit over maximum configured value."

    I think there is no such way to increase it beyond 500. However it is still better then 250 maximum through UI.

    Thursday, October 29, 2015 4:42 PM
  • I was looking for the same. Did that actually work?

    Hi, Yes it works but Maximum you can set is 500 (still better than 250 through UI).

    Please have a look here for the code: How to increase Paging Limit in Dynamics CRM 2015 Online using C#

    • Marked as answer by jattscorpion Friday, October 30, 2015 9:18 AM
    • Edited by jattscorpion Friday, October 30, 2015 9:18 AM
    Friday, October 30, 2015 9:18 AM
  • It helps! Thank you guys!
    Friday, October 30, 2015 9:19 AM