<< Click to Display Table of Contents >> Navigation:  Available Functions > InLists()

Syntax

InLists( <SpecificLists> )

 

Purpose

To determine whether a donor has one or more specific list codes in their history.

 

Parameters

<SpecificLists> is a character value containing any number of specific list codes, with each code separated by a comma.

 

Returns

InLists() will return true if one more of the <SpecificLists> is equal to one of the up to nine list codes a donor may have in their history. This true/false (logical) value is intended for use with selection conditions, and cannot be used directly in a report.

 

Usage

Recall from section one that List codes are used to store donor source code or "tag" information. List codes are basically used to "tag" a given donor in some way or other. For example, you may use the list codes to specify the list from which you got the donor's name. Establishing list codes makes it very easy to select subgroups of donors for specialized mailings. Up to nine list codes may be stored for each donor.

 

When creating Template or Custom selections, the InLists() function provides a convenient way to check all of a donor's nine list fields for specific codes. The InLists() function gives you the same capability which exists in the specific list code selection (covered in section two), but it does so using a single line in a Template or Custom selection definition.

 

Example

The following examples illustrate InLists():