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.
     
    • 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?