How to extract report more than 10k records using database view
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-08-2024 02:18 AM
Hi
Im creating a report using export set and the export definition is through database view. The report will be exported to mid server in a csv format. Currently, im having issue with the report extraction where by the report does not contain the complete record (i.e. expected: 96 000 rows, exported: 10001 rows). I've done the necessary configuration, kindly refer to the attachment. Please help me with solutions.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-20-2024 10:47 PM
@PatriciaA987250 Try the following steps:
1. Go to Import Export under System Properties and open
2. Try updating the Row Limits and see if that helps
NOTE: Keeping higher numbers while exporting data to csv/excel isn't recommended as it may create performance issues and hence, this must be tested properly.
If this helps answering your question, please mark this as "Accepted Solution".
-Shiwan Agrawal