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?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.