Individuals With Subscription Purchases by Date Range Query

This query returns a list of individuals with subscription purchases by date range.

Query Parameters

Parameter	Description
Product Name Contains	Enter a product name for the query.
Add Date Greater Than or Equal To	Enter a date, or select a date from the drop down calendar, for the query.
Add 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.
Prefix, First, Last Name	Lists the individual first and last name with any prefix.
Individual Member Flag	Indicates whether or not the individual is a member (1) or non-member (0).
PriAddress Address Line 1, 2, 3, City, State/Territory	Lists the individual primary address.
PriEMail E-Mail Address	Lists the individual primary email address.
trx_sub Type	Lists the individual subscription type.
trx_sub Total Amount	Lists the individual subscription total amount.
subscription Product Code	Lists the individual subscription product code.
subscription Product Name	Lists the individual subscription product name.