Start your query:
  1. Navigate to Analysis> Information Library
  2. Click Add ad-hoc query
  3. Select the source view of Sales Order and click OK

Add fields to Include records where:
  1. In the left column, highlight Sales Orders, then from middle column drag Email into Include records where. Set equal to Not Blank.
  2. In the left column, select Sales Orders. From middle column, drag Transaction date into Include records where. Set equal to date you want to review (ex: Yesterday)
  3. (Optional) If you want to see only tickets to a specific program, such as general admission: In the left column, expand Sales Order Item, expand Sales Order Item Ticket, then select Program. From the middle column, drag Program record into Include records where. Set Equal to your program.

Add fields to Results fields to display:
  1. In the left column, select Email Addresses. From middle column, drag Email address into Results fields to display
  2. In the left column, select Sales Orders. From middle column, drag Transaction date into Results fields to display.
  3. To see Constituent name: In the left column, select Constituent. From the middle, drag Name into Results fields to display.
  4. To see Constituent lookup ID: In the left column, select Constituent. From the middle, drag Lookup ID into Results fields to display.

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

Your final query should look similar to below:
Sales Order Email Query