Answered by:
Is there any way to increase Number of results per page in CRM 2015 Online?

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
- Proposed as answer by Andrii ButenkoMVP, Moderator Thursday, October 29, 2015 8:27 PM
- Marked as answer by jattscorpion Friday, October 30, 2015 9:15 AM
Thursday, October 29, 2015 12:19 PMModerator -
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 blogThursday, October 29, 2015 11:48 AMModerator -
Hello,
OOB you have possibility to switch to paging by 250 records per page.
Dynamics CRM MVP
My blogThursday, October 29, 2015 11:49 AM -
Thursday, October 29, 2015 12:15 PMModerator
-
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
- Proposed as answer by Andrii ButenkoMVP, Moderator Thursday, October 29, 2015 8:27 PM
- Marked as answer by jattscorpion Friday, October 30, 2015 9:15 AM
Thursday, October 29, 2015 12:19 PMModerator -
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