Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    1
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    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

  • Question
    Sign in to vote
    1
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    AFAIK there is no easy way of doing that.

    Dynamics CRM MVP
    My blog

    Thursday, October 29, 2015 12:15 PM
    Moderator
  • Question
    Sign in to vote
    1
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    I was looking for the same. Did that actually work?
    Thursday, October 29, 2015 12:27 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    It helps! Thank you guys!
    Friday, October 30, 2015 9:19 AM