Using Constituent Queries To Gather Event Registrant Information
Published
Ever had a scheduled program or event occur in Altru and you wanted to get a list of constituents that attended for a mailing? This action can be performed with a constituent query in Altru and used in one of Altru’s mailing processes or exported to Excel.
To create a query of constituents that attended a scheduled or preregistered program you can do this
First create a query with a Constituents source view:
Â
Then filter the query on your program:
Â
You can further adjust the criteria of the query by adding transaction dates or program event start dates to the include records where section.
To add a transaction date filter:
Â
To find constituents based on the Program Event Start Date you need to follow a path like the one we pulled earlier when pulling the program record:
Â
If you’re looking to find constituents registered to a Fundraising or Special Event in Altru you can follow these steps:
Â
Create a Constituent query:
Â
Filter your query on constituents that have purchased a ticket to your fundraising event:
Â
Now that you have your constituent queries created feel free to turn them into a selection by clicking on the set save options tab of your query and then mark create a selection and show this selection in the query designer:
Â
Once your query is saved you can use it in one of Altru’s mailing processes like the appeal mailing process or the invitations process for Special Events. Check out these other articles we have below that include instructions on using constituent queries to retrieve other information from Altru:
Â
Â
To create a query of constituents that attended a scheduled or preregistered program you can do this
First create a query with a Constituents source view:
- Click Analysis > Information Library > click add an ad-hoc query
- Click the drop-down box next to Record Type > Choose Constituent
- Double click on Constituents in the Source View Section
Â
Then filter the query on your program:
- Under the Browse for fields in section expand the Sales Orders node by clicking the ‘ ’ button next to Sales Orders
- Then expand sales order item > expand Sales order Item Ticket
- Click on Program (It should highlight Blue)
- Drag Program Record from the middle column to the Include records where section
Â
You can further adjust the criteria of the query by adding transaction dates or program event start dates to the include records where section.
To add a transaction date filter:
- Click on the Sales Orders field under browse for fields in
- Then drag Transaction date from the middle column to the include records where section
- Then change the first drop down to Between and enter your dates:
Â
To find constituents based on the Program Event Start Date you need to follow a path like the one we pulled earlier when pulling the program record:
- In the query under browse for fields in expand Sales Orders
- Expand Sales Order Item > then expand sales order item ticket
- Click on Program Events
- Drag start date from the middle column to the include records where section > enter your date or select one of the options in the first drop down menu
Â
If you’re looking to find constituents registered to a Fundraising or Special Event in Altru you can follow these steps:
Â
Create a Constituent query:
- Click Analysis > Information Library > click add an ad-hoc query
- Click the drop-down box next to Record Type > Choose Constituent
- Double click on Constituents in the Source View Section
Â
Filter your query on constituents that have purchased a ticket to your fundraising event:
- Under browse for fields in expand Registrant
- Click on Event > Drag Event record from the middle column to the include records where section
- Search for and select your Event and click OK
- Under browse for fields in expand Registrant > then expand Registrations
- Click Mapped Registrations
- Then drag Registrant from the Middle Column to the Results fields to display section
Â
Now that you have your constituent queries created feel free to turn them into a selection by clicking on the set save options tab of your query and then mark create a selection and show this selection in the query designer:
Â
Once your query is saved you can use it in one of Altru’s mailing processes like the appeal mailing process or the invitations process for Special Events. Check out these other articles we have below that include instructions on using constituent queries to retrieve other information from Altru:
- Query on Constituents who have a certain Constituency code
- I need to query on the number of guest passes a constituent has remaining
- I need to query on all constituents that don’t have a membership
Â
Â
News
ARCHIVED | Blackbaud Altru® Tips and Tricks
01/10/2018 10:05am EST
Leave a Comment