Customer experience | Sales, Customer Insights,...

Limit number of records returned by view

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (6)

Answers (0)

Suggested answer

SamiraM 571 on at

Like (0)

Report

RE: Limit number of records returned by view

Try count like below:

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true" count="10">
Community Member Microsoft Employee on at

Like (0)

Report

RE: Limit number of records returned by view

Hi,

did you publish the entity after saving the view?
Esteban Coto Alfaro on at

Like (0)

Report

RE: Limit number of records returned by 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.
Community Member Microsoft Employee on at

Like (0)

Report

Limit number of records returned by view

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
Community Member Microsoft Employee on at

Like (0)

Report

Limit number of records returned by view

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
Community Member Microsoft Employee on at

Like (0)

Report

Limit number of records returned by view

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