You are here: netFORUM Pro Modules > Reports and Queries > List of Baseline Queries > Individuals by Subscription Name Query
Individuals by Subscription Name Query
This query returns a list of individuals by subscription name.
Query Parameters
Parameter | Description |
---|---|
Product Name Contains |
Enter a product name 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. |
First, Last Name | Lists the individual first and last name. |
PriAddr Address Line 1, 2, City, State/Territory, Postal Code, Country |
Lists the individual primary address. |
PriPhone Phone Number |
Lists the individual primary phone number. |
PriFax Fax Number | Lists the individual primary fax number. |
PriEMail E-Mail Address | Lists the individual primary email address. |
Start, End Date | Lists the individual subscription start and end dates. |
trx_sub Type | Lists the individual subscription type. |
trx_sub Amount | Lists the individual subscription amount. |
trx_sub Total | Lists the individual subscription total amount. |
subscription Product Name | Lists the individual subscription product name. |