Constituents appear in both result sets - When querying on Communications\Event Invitations\Included Invitees\Status in a constituent query

When running a constituent query and filtering on a particular event and the Included Invitees\Status, you might notice that constituents appear in the results for multiple statuses.
We are currently evaluating this issue for a fix in a future service pack. 

Steps to Duplicate

1) Run a query like the following:
Communications\Event Invitations\Event\Event record is equal to example event A
and Communications\Event Invitations\Included Invitees\Status is equal to Invited with no response
2) Notice the number of results, which reflects an accurate value.
3) Then change the query to: 
Communications\Event Invitations\Event\Event record is equal to example event A
and Communications\Event Invitations\Included Invitees\Status is equal to Registered
4) Notice that the result set returned by this contain many of the same results from the query run in step 1, which is incorrect because those statuses are mutually exclusive.

Environment

 Blackbaud CRM
 4.0
 4.0.168.0

Was this article helpful?