Search Results export to excel/json record limit?

Chris King

When we try to use the Search Results export to either excel or json, we only get 100 records in the resulting file. Is there a limit somewhere in settings that can be modified? I cant find one

AbelJM

Hi @Chris King the 100-record limit you are encountering is a known constraint of the out-of-the-box (OOTB) SmartView export functionality, which is often tied to the UI's pagination or specific configuration settings that aren't always easily accessible for modification without affecting system performance.

If you are looking for a way to bypass these limits and gain more control over the export process, I highly recommend looking into Module Suite from AnswerModules.

With Module Suite, you can easily create a custom "Search & Export" tool using a Content Script. This approach allows you to:

1. Bypass UI Limits: Use the searchService to programmatically gather all search results. You can iterate through result slices (paging) until the entire result set is captured, effectively removing the 100-record barrier.
2. Generate Native Excel Files: Use the built-in Excel APIs to create high-quality .xlsx files with custom headers, formatting, and multiple sheets if needed.
3. Automate Delivery: Instead of just a browser download, you can script the system to email the resulting file to the user or save it directly into a specific Content Suite folder.
4. Custom UI: You can trigger this script via a simple button in a SmartView dashboard or a Beautiful WebForm, providing a seamless experience for the end-users.

It’s a much more flexible way to handle reporting and data extraction compared to the standard export feature.

Hope this helps!
Regards
Abel