You are here: netFORUM Pro Modules > Reports and Queries > List of Baseline Queries > Individuals by Organization Relationship Type (single/multi-select) Query
Individuals by Organization Relationship Type (single/multi-select) Query
This query returns a list of individuals by their relationships to organizations.
Query Parameters
Parameter | Description |
---|---|
Relationship Type Is Equal To |
Select up to five (5) relationship types 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. |
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, Post 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. |
Relationship Tyep | Lists the individual relationship type. |
Title | Lists the individual title. |