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.