How to pull a list of registrants with registration option for special events

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. 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.
  4. 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.
  5. 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. 
  6. To see how many tickets they purchased: From the left column, select Registrations. From the middle column, drag Quantity into Results Fields to Display.

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

Environment

 3.15

Was this article helpful?