locked
Retriving only 50 records out of a retrieve multiple request RRS feed

  • 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 .

    Thanks
    Tuesday, 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!


    Tuesday, September 8, 2015 12:20 PM
  • Provide your code please.

    Dynamics CRM MVP
    My blog

    Tuesday, September 8, 2015 2:56 PM
    Moderator
  • 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