You’re offline. This is a read only version of the page.
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
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.
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.
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?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (