Asked by:
Retriving only 50 records out of a retrieve multiple request

Question
-
HI
We have a retrieve multiple function which is being called to get a set of account records inside a HTML Table .
The problem is when we have more than 50 records this function is not working . We want to know if there is a way to show only first 50 records then on click of next button we want to see the next 50 (Without using it in a single function response_next) as it will affect performance .
We want that when the user clicks on next button in HTML page only then the next 50 records should be called .
Kindly help .
ThanksTuesday, September 8, 2015 10:30 AM
All replies
-
If I understand you right you need to retrieve from the system first 50 records, then on a button click next 50 records and so on. There is a way to do it: https://msdn.microsoft.com/en-us/library/gg309717.aspx
- Edited by Pr8K Tuesday, September 8, 2015 11:45 AM
Tuesday, September 8, 2015 11:44 AM -
HI ,
Thanks for your reply . Actually i am currently using Odata to retrieve the records. The provided solution is for fetch xml or c# .
Is there a similar way for Odata also ?
Thanks!
- Edited by CRM Developer 2015 Tuesday, September 8, 2015 12:27 PM
Tuesday, September 8, 2015 12:20 PM -
Tuesday, September 8, 2015 2:56 PMModerator
-
You can use $skip and $top.
https://msdn.microsoft.com/en-us/library/gg309461.aspx
The former specifies how many records in a result to ignore and the latter would be 50.
As you page through you'd start with %skip 0 and increase it 50 each time you do next.
That's broadly speaking how you could do this.
- Proposed as answer by Piyush Parate Wednesday, September 9, 2015 2:42 PM
Wednesday, September 9, 2015 12:41 PM