Cannot export more than 500 results from smart query

After running a smart query with more than 500 results, When you export the results to excel, you may only get the first 500 results of that query.

Article Number: 89341

Products:

  • Altru_Arts_Cultural
We are currently evaluating this issue and will update this article when we have more information.

In the meantime, edit your smart query and click Export to Excel from the Preview Results tab to get all results from your smart query: 
  1. Go to Analysis > Information Library.
  2. search for and select your query.
  3. Click Edit Definition on the top left.
  4. Go to the Preview Results tab.
  5. Click Export to Excel.

Steps to Duplicate

  1. From Analysis, select Information library
  2. Select Add a Smart query
  3. build a Smart query that will produce more than 500 results
  4. Run the query, click the excel button to export to csv

Environment

 Altru Arts & Cultural

Was this article helpful?

Blackbaud Community

Connect and collaborate with fellow Blackbaud users.

Chat with Support

Chat with our experienced staff to receive help right away.

Connect

The Blackbaud team is online and ready to connect with you!