Incorrect query results when merging Participant or Event queries using AND or SUB

One participant record exists for each event. If one query groups participants for Event A and another query groups participants for Event B, each query has unique records. If the same constituent attends both events, that constituent has separate participant records for each event.  Merging these queries using AND or SUB gives inaccurate results.

Also, merging Participant or Event queries with operator SUB when filtering on Constituent fields, such as Constituency Code, can result in inaccurate results.

Article Number: 75498

Products:

  • Raiser_s_Edge_RE
     
    • Create a constituent query**
       
    • On the Criteria tab, select Event Participations, Events, Event Name one of [events] and mark Each record must meet all specified criteria
       
    **Please note that this will only show constituents. Non-Constituents will not show within this query.

    Environment

     Duplicated in version 7.80.1122.1

    Was this article helpful?

    Blackbaud Community

    Connect and collaborate with fellow Blackbaud users.

    Chat with Support

    Chat with our experienced staff to receive help right away.

    Connect

    The Blackbaud team is online and ready to connect with you!