You are here: netFORUM Pro Modules > Reports and Queries > List of Baseline Queries > Individuals by Activity Code (single/multi-select) Query
Individuals by Activity Code (single/multi-select) Query
This query returns a list of individuals by activity code.
Query Parameters
Parameter | Description |
---|---|
Activity Code Is Equal To (5) | Select up to five (5) activity codes from the drop down lists. |
Member Flag Is Equal To | Select a member flag from the drop down list: Member, Non-Member, All. |
Query (Default) Fields
Field | Description |
---|---|
Query Header | Displays the query name, number of records returned, and the total number of pages for the query. |
Title | Lists the individual title. |
Individual Member Flag | Indicates whether or not the individual is a member (1) or non-member (0). |
Individual Sort Name | Lists the individual sort name. |
PriAddr Address Line 1, 2, 3, City, State/Territory, Postal Code, Country | Lists the individual primary address. |
PriPhone Phone Number, Extension | Lists the individual primary phone number and extension. |
PriFax Fax Number, Extension | Lists the individual primary fax number and extension. |
PriEMail E-Mail Address | Lists the individual primary email address. |
Code | Lists the associated activity code. |