All Invitees appear in results when querying on Constituents included in one particular event invitation

When an event has multiple invitation lists the invitees are always grouped at event level in a Constituent query. Query can't distinguish between the separate invitation lists when outputting by invitee, the total number of invitees is outputted when a single invitation list is filtered.
We're currently evaluating this issue for a fix in a future release 

Steps to Duplicate

Prerequisite: ensure you have a single layer event with more than one invitation list with each list having a different number of invitees.

 
  1. Go to Analysis>Information Library
  2. Create a new Events Query
  3. For filters select Invitees\Invitation\Invitation Process and Event Record equal to one of your invitation lists for your chosen event
  4. For Output Fields add Invitees\Constituent Name
  5. Click Results tab.  You will get 10 results which matches the number of Invitations sent for the invitation
  6. Close that query and create a new Constituent Query
  7. Select the criteria of Invitee\Event\Invitations\ Invitation Process and Event Record equal to one of your invitation lists for your chosen event
  8. Select Preview results and notice that the results are a list of all invitees for the event and not just the invitees for the particular invitation
 
Workaround: Use an event Query to pull this information 
 

Environment

 Blackbaud CRM
 4.0
 4.0.141.12

Was this article helpful?