How to pull a list of registrants with registration option for special events (includes video demo)

You may need to have a detailed list of registrants attending your upcoming special fundraising event. This solution will provide steps to build a query with information you may need about your registrants who will be in attendance (for example, seating notes, host name, etc.)
Start your query: 
  1. Go to Analysis > Information Library
  2. Click Add an ad-hoc query
  3. Select source view of Registrants and click OK
Add fields to Include Records Where:
  1. In the left column, select Event. From the middle column, drag Event Record into Include Records Where. Search for your event and click OK.
  2. In the left column, select Registrants. In the middle column, drag Will not Attend into Include Records Where. Set the criteria to equal to No.
  3. In the left column, select Registrants. In the middle column, drag Attended/No-show into Include Records Where. Set the criteria to Not equal to No-show or is blank.
 Add fields to Results Fields to Display: 
  1. To add registrants name: Name is included in the Results Fields to Display of a Registrants Query by Default. 
  2. To see registration option: From the left column, select Mapped Registrations. From the middle column, drag Registration option into Results fields to display.
  3. (Optional) To see email address: In the left column, expand Constituent, then select Email addresses. From the middle, drag Email address into Results fields to display.
  4. (Optional) To see phone number: From the left column, expand Constituent, then select Phones. From the middle, drag Number into Results fields to display.
    • Note: If the constituent has more than one phone number or email address on file, you want to use the steps here to only show the primary.
  5. (Optional) To see their Host, if they are a guest: From the left column, select Host. From the middle column, drag Name into Results fields to display.
  6. (Optional) To output any seating information: In the left column, select Registrant. In the middle column, drag Table\Row Number AND Seating Note into Results fields to display.
  7. (Optional) To output any preference information: From the left column, select Preferences. From the middle column, drag Preference Group AND Preference into Results fields to display.
    • Note: this may create duplicate lines if you have more than one preference. 
  8. (Optional) To see how many tickets they purchased: From the left column, select Registrations. From the middle column, drag Quantity into Results Fields to Display.
Save your query:
  1. Click Set save options tab
  2. Name query
  3. Save and Close

Your final query will look similar to below:
User-added image


Environment

 3.15

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.