Customer Registration by All Events and Date Range Query with Demographics

This query returns a list of all customer registrations within a given registration date range for all events.

Query Parameters

Parameter	Description
Registration Date Greater Than or Equal To	Enter a date, or select a date from the drop down calendar, for the query.
Registration Date Less Than or Equal To	Enter a date, or select a date from the drop down calendar, for the query.

Query (Default) Fields

Field	Description
Query Header	Displays the query name, number of records returned, and the total number of pages for the query.
Registration Date	Lists the customer registration date.
Badge First, Last, Name	Lists the customer badge first, last, and full name.
reg_custom_flag_01, 2, 3, 4 (multiple...)	TBD
Flag 5 (5)	TBD
reg_custom_date_01 (multiple...)	TBD
reg_custom_currency_01 (multiple...)	TBD
Currency 2, 3, 4, 5	TBD
reg_custom_integer_01 (multiple...)	TBD
Integer 2	TBD
String 1 (10)	TBD
String 3 (4)	TBD
reg_custom_text_01 (multiple...)	TBD
Text 2	TBD
Registrant Type Code	Lists the registrant type code.
trx Type	Lists the transaction type.
trx Amount	Lists the transaction amount.
trx Quantity	Lists the transaction quantity.
trx Total Amount	Lists the transaction total dollar amount.
trx Add Date	Lists the transaction add date.
First, Last, Middle Name, Suffix	Lists the registrant first, last, and middle name with any suffix.
Designation	TBD
Age, Gender	Lists the registrant age and gender.
Flag 1, 2, 3, 4, 5	TBD
String 1	TBD
Event Product Name	Lists the event product name.
Date	Lists the event date.
Order Number	Lists the associated order number for the event.
Order Status	Lists the associated order status.
Billing Address Line 1, 2, 3, City, State, Postal Code, Country	Lists the registrant billing address.
Event Fee Name	Lists the event fee name.
Phone Number	Lists the registrant phone number.
E-Mail Address	Lists the registrant email address.
Fax Number	Lists the registrant fax number.