Event Summary node no longer appears after Version 4.0 Service Pack 9

After the addition of Service Pack 10, this client has noticed that when creating an ad-hoc query, the Constituent Source view no longer contains the Invitee\Event node as an available field. 

This is problematic for this as they recently upgraded from Service Pack 9 - 12 and no longer have the ability to create a list of invites that can be used in a marketing effort for mailing. 
This node was specifically removed due to returning incorrect and hard to understand summary data when starting from a constituent record.  Users will need to use the following path to for any invitee filters.

Registrant\Event\Invitee\Constituent name

Steps to Duplicate

1. Navigate to Analysis
2. Click Information library
3. Add a new ad-hoc query using the "Constituent Source" view. 
4. From the "Browse for fields in:" navigate to Invitee/Events 

Note from here you have the ability to create a list of invites that can be used in a marketing effort for mailings


Using Service Pack 12
1. Navigate to Analysis
2. Click Information library
3. Add a new ad-hoc query using the "Constituent Source" view. 
4. From the "Browse for fields in:" navigate to Invitee. 

Note: Events was removed from the Constituent Source view. 

Environment

 Blackbaud CRM
 4.0
 4.0.172.0

Was this article helpful?