How do I get a list of all campaigns, funds and appeals that have no gifts associated so I can clean those out of Raiser's Edge?
Three separate queries must be created (one for each - appeal, fund campaign).
1. Create a New Query 2. Query type should be either appeal, fund or campaign. For these steps we will use appeal. Query format is Dynamic. 3. Under Criteria, expand Summary for Appeal field and select Total Given. Make this amount equal $0. 4. Under Output I selected Appeal ID, Appeal Description and Total Given_1 (already selected based on criteria chosen). You can obviously customize the output as needed. 5. Results should show only those which have zero gifts given.
Repeat this process for the remaining two types and use each query's results to know which to remove from Raiser's Edge.
It is not possible to merge different query types which is why three separate queries are needed.