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.