Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
AggregateQueryRecordLimit exceeded RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    How to get more than 50000 records count using fetchXML in MS CRM. Except config changes. If any solution please let me know.

    Regards,

    Bala

    Monday, November 27, 2017 12:31 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    There is a free tool in the XrmToolbox called "FetchXml / View Record Counter" that you can point at a view and it will count the records in the view. It does this by returning all the rows, 5000 at a time.

    I have also built two commercial add-on products that run any FetchXml aggregate on any number of records (without returning all the rows). One works inside CRM via a managed solution and the other works via the command line. They're currently in beta.

    If you're interested in more info, please contact me here: https://www.xrmedge.com/home/contact/

    Regards,

    Aron



    • Edited by Aron F Monday, November 27, 2017 11:10 PM
    Monday, November 27, 2017 11:06 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    Hello,

    You can use Fetch XML with paging-cookie

    Thanks and Regards.

    • Proposed as answer by MGCRM Monday, December 4, 2017 9:45 AM
    Monday, December 4, 2017 8:50 AM