You are here: netFORUM Pro Modules > Reports and Queries > List of Baseline Queries > Individuals by Chapter Affiliation (single/multi-select) Query
Individuals by Chapter Affiliation (single/multi-select) Query
This query returns a list of individuals by chapter.
Query Parameters
Parameter | Description |
---|---|
Member Flag Is Equal To | Select a member flag from the drop down list: Member, Non-Member, All. |
Chapter/Affiliate Is Equal To (5) | Select up to four (4) chapters/affiliates from the drop down lists. |
Query (Default) Fields
Field | Description |
---|---|
Query Header | Displays the query name, number of records returned, and the total number of pages for the query. |
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, City, State/Territory, Postal Code | Lists the individual primary address. |
HomeAdr Address Line 1, 2, City, State/Territory, Postal Code | Lists the individual home address. |
PriPhone Phone Number | Lists the individual primary phone number. |
PriFax Fax Number | Lists the individual primary fax number and extension. |
PriEMail E-Mail Address | Lists the individual primary email address. |
cat Chapter Affiliate Name | Lists the individual chapter affiliate name. |
cat Chapter Affiliate Description | Lists the individual chapter affiliate description. |
cat Chapter Affiliate Type | Lists the individual chapter affiliate type. |