You are currently reviewing an older revision of this page.
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.
The CDT and database view used for the smart server do not have the same primary key. 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
Update the database view to have the same primary key.
This article applies to all versions of Appian.
Last Reviewed: August 2020