You are currently reviewing an older revision of this page.

DRAFT KB-[SP-4639] Export to CSV or Export to Excel smart service only returns 1000 rows

Symptoms

When using the Export to CSV or Export to Excel smart service on a database view, only 1,000 rows are exported even though more rows are expected to be exported.

Cause

The CDT and database view used for the smart server do not have the same field set as the primary key. Without the same field set as the primary key, Appian will not be able to export the data consistently. As mentioned in the Export to CSV documentation:

Exporting data store entities from either record lists or smart services relies on sorting the entity by its primary key. This sorting ensures that data is exported consistently - that is, all rows are exported and no row is exported more than once

Action

Update the database view and/or the CDT to use the same field for the primary key.

Affected Versions

This article applies to all versions of Appian.

Last Reviewed: August 2020