Recurring gifts with a canceled status are showing as completed in queries.
This happened to a very old query that hadn't been changed since some major updates to this area. The solution is to simply remove the node from the query, save it, and then add the node back. This should produce more consistent results.
Steps to Duplicate
1. Login to BBCRM.
2. Go to the Analysis functional area.
3. Click information library.
4. Create a query looking for both recurring gifts and their status'
5. Preview results.
6. Note despite the recurring gift having a canceled status on the gift record, it is being displayed as completed in query.