Announcements
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 and 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
Try count like below:
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true" count="10">
Hi,
did you publish the entity after saving the view?
Hello, it should work, but a question after saving it, it also has been published?
Thanks!
Community Support Team - Esteban
If this Post helps, then please consider Accept as solution to help the other members find it more quickly.
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 and 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
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 and 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
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 and 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
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156