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.