Understand Referenced Interaction Types in Query
When adding an Interactions phrase in Query, interaction types that reference campaigns or other objects (such as surveys or action alerts) are now in a separate group called Referenced Types. When selecting an item from this new group of Referenced Interactions, you will now see an applicable list of campaigns/objects. You can then specify that your query return only constituents who interacted with one or more of these specific campaigns or other objects.
For example, if you select Donation from the Referenced Types group, you will see a list of all Donation Campaigns for your site, including those associated with TeamRaiser and Personal Fundraising. You can then select the campaigns for which you wish to see the list of constituents who donated.
Important Considerations:
-
You can filter large lists of referenced objects by Name and by Security Category
-
The system will only display a maximum of 500 Referenced objects for each Referenced Interaction Type; if you know that you have more than 500 referenced objects for an Interaction Type (such as Donations), use the Name and Security Category filters to refine the list
-
While you can select multiple campaigns or objects within a single phrase, they will be entered into your query as separate lines and must be edited individually.
-
You can select objects for which you may not have permissions, but the query will only return constituents that you do have permission to see. (For example, if you have contact management permissions only in Center A, you can select a Campaign in Center B, but you will not see constituents who donated to that campaign unless they are also members of Center A.)
-
Campaigns and objects with the following status will be listed: draft, published, unpublished, closed (archived objects will not appear)