You are here: netFORUM Pro Modules > Reports and Queries > List of Baseline Queries > Individuals by Custom Date Demographics Query
Individuals by Custom Date Demographics Query
This query returns results based on custom demographics fields.
Note: Includes Custom Date, Custom Date 1, Custom Date 2, Custom Date 3, Custom Date 4, and Custom Date 5.
Query Parameters
Parameter | Description |
---|---|
Member Flag Is Equal To | Select a member flag from the drop down list: Member, Non-Member, All. |
Date 1 Greater Than or Equal To | Enter a date, or select a date from the drop down calendar, for the query. |
Date 1 Less Than or Equal To | Enter a date, or select a date from the drop down calendar, for the query. |
Note: Custom Date 4 does not have the Member Flag query parameter. Custom Date lists Date 1 through Date 5 Is Equal To query parameters and no Member Flag query parameter.
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 Type | Lists the individual type. |
Flag 1 |
Custom row Flag. Note: Lists in Custom Date and Custom Date 4. |
Date |
Custom row Date. Note: Custom Date lists Date 1 through Date 5. Custom Date 5 also lists Custom Date 1. |
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 City, State/Territory, Postal Code | Lists the individual primary partial 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. |