Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum

Can't Get top x rows in a view

Posted on by Microsoft Employee

Hi,

I am trying to create a view in CRM that returns the top 40 accounts based on a roll up field.

This works in Fetch XML Builder, but when I publish the FetchXML to CRM I still get 1000 accounts returned in the view.

Is there something that prevents that functionality in CRM but allows it in the FetchXML Builder plugin?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Can't Get top x rows in a view

    Are you confirming it is not possible to limit a view to the top 40 rows?

  • Suggested answer
    RaviKashyap Profile Picture
    RaviKashyap 55,410 on at
    RE: Can't Get top x rows in a view

    Hi,

    Changing the page size (record count) is the property of the fetchxml which doesn't change when you publish. You can only change the definition of the entity like layout, filter criteria, columns, sorting etc. The view will return all the records based on the filter condition specified.

    Hope this helps.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans