You are here: netFORUM Pro Modules > Reports and Queries > List of Baseline Queries > Open Orders for Registrants by Event Query
Open Orders for Registrants by Event Query
This query returns a list of event registrants with open orders.
Query Parameters
Parameter | Description |
---|---|
Event Is Equal To | Select an event from the drop down list. |
Query (Default) Fields
Field | Description |
---|---|
Query Header | Displays the query name, number of records returned, and the total number of pages for the query. |
Badge First, Last, Name | Lists the customer badge first, last, and full name. |
Registrant Type Code | Lists the registrant type code. |
trx Amount | Lists the transaction amount. |
Event Product Name | Lists the event product name. |
Order Number | Lists the associated order number. |
Order Status | Lists the order status. |
Confirmation Number | Lists the order confirmation number. |