Incorrect query results when using filters in summary volunteer information

When using Summary Information for Volunteer in a Constituent query, the results are incorrect if filters are added to the summary information.
If you encounter this issue in the latest version and patch of Raiser's Edge please contact support and reference this article.

Steps to Duplicate

1. Query > New Query > Constituent
2. Add criteria Volunteer > Summary Information for Volunteer > Total Number of Job Assignments greater than 0
3. Add to Output fields Name and Total Number of Job Assignments
4. Run Now
5. In sample data, Mark Adamson Total Number of Job Assignments is 4 assignments, which  matches his record
6. On Criteria tab add to Summary filter Time Sheets > Date between 1/1/00-1/1/16
7. Run Now
8. Mark Adamson Total Number of Job Assignments is 72 assignments


 Raiser's Edge

Was this article helpful?