Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Dynamics 365 general forum

Can't Get top x rows in a view

(0) ShareShare
ReportReport
Posted on by

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
    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
    55,410 Moderator 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 > Dynamics 365 general forum

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans