- Remove criteria in Include Records Where, one by one until results begin to show in query. This will show which line is problematic in the query, and it will help narrow down what is needed to fix the query to show the correct results.
- Verify that the AND/OR operators are being used appropriately.
- Check any date ranges listed in the Include Records Where include the correct dates.
- Find an example of a record that should be included in results, and verify you have the correct filters specified in Include Records Where to display that record.
Connect and collaborate with fellow Blackbaud users.