Notifications
Announcements
No record found.
I have one view and this view returns more than 5.000 records.I want to return only one record. All records are created on the same day so I cannot use sorting by CreatedOn column.I used FetchXML Builder to modify view definition and now it is like this:<fetch version="1.0" top="1" output-format="xml-platform" mapping="logical">When I execute this view in FetchXML Builder i get only one row in results.After I saved this view in CRM I tried to get records directly from Advanced Find inside CRM but I still see more than 5.000 records.The requirement is to return only one record.CRM version: 1612 (9.0.19.8) (DB 9.0.19.8) on-premises
Hi mrsmith,
Top attribute cannot be specified in fetch XML of an entity view.
Can I check what is your need and criteria to show only one record out of 5000?
Hello Charan,
Within Query Dynamics 365 Data step inside Dialog there is one query. Since there are more than 5.000 records that meet the required criteria inside dialog on the next page there are 25/50/75/100/250 records shown to the user (depending on what is defined on user's personal settings).
The user in this case does not have to see more than one record in the list, only one is enough.
In that case, my suggestion is to create a flag on this entity and set this flag using some custom code for only one record based on your need. Then create a view with criteria where flag = yes and use this view in your dialog.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tom_Gioielli 70 Super User 2025 Season 2
Gerardo RenterÃa Ga... 43 Most Valuable Professional
Daniyal Khaleel 32 Most Valuable Professional
