Begin your query:

  1. Navigate to Analysis, then click on Information Library
  2. Click Add an ad-hoc query
  3. Select Sales order source view and click OK


Add fields to Include records where:

  1. In the left column, expand Sales order item, expand Sales order item ticket, and select Program Events. From the middle column, drag Event record and move to Include records where. Set Equal to your program.
  2. In the left column, expand Tickets under sales order item, sales order item ticket.  In the middle column, click Scan date and move to Include Records Where. Set the criteria to Not Blank.
  3. In the left column, expand Constituent, then select Email Addresses. In the middle column, click primary email address and move to Include records where. Set the criteria to equal to Yes.
  4. Note: this will return only primary email addresses and people without email addresses will not be included.


Add fields to Results fields to display:

  1. In the left column, expand Constituent, then select Email Addresses. In the middle column, click Email Address and move to Results fields to display.
  2. In the left column, click on Constituent. From the middle column, drag Name into Results fields to display.


Save your query:

  1. Click Set save options tab
  2. Name your query
  3. Save and Close