Cannot export more than 500 results from smart query

When viewing the results of a smart query in Altru one will notice they only receive the first 500 records. In order to see the additional records beyond 500 you must export to excel. However, when you export it to excel you still only receive 500 records. 

Article Number: 89341

Products:

  • Altru_Arts_Cultural
Edit your smart query and click Export to Excel from the Preview Results tab to get all results from your smart query: 
  1. Click Analysis at the top of the screen in Altru
  2. Click Information Library
  3. Search for and select your query.
  4. Click Edit Definition on the top left.
  5. Go to the Preview Results tab.
  6. 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!