Static Query Returns 0 results

A static query is like taking a snapshot of the database at the time the query is created. Only the records selected when the query is first created will be included when the query is used in the program. The same constituents are still in the static query so you can easily find them again if the need arises.  Sometimes the static query may later contain a different grouping, or 0 records.
Static queries create a new table in the database that contains the records in the query. If the query is refreshed and saved, this table is overwritten with the new records that meet the criteria.

If the query is refreshed and resaved when it contains 0 records, the underlying table is emptied, and those records can't be restored unless they meet the criteria again.


Steps to Duplicate

  1. With the static query already created, click Export in the left navigation bar
  2. Click New Export
  3. Choose Constituent
  4. Choose Excel as the export format
  5. Click Create Now
  6. Click on the Include button
  7. Choose Selected Records
  8. Find the name of the static query
  9. Click Open on the far right
  10. Mark the button to export both constituents separately
  11. Mark the checkboxes to include constituents who are inactive, deceased, and no valid address
  12. Click on the Output tab at the top
  13. Expand Constituent Information
  14. Double Click on Name
  15. Click Export Now
  16. Choose the location to export the excel file
  17. Click save
  18. 0 records exported



 Raiser's Edge

Was this article helpful?

Thanks for your feedback! Did this solve your issue?

Comments (optional):

Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):

Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.