ProClass | Class Management Software | Registration Software | Membership Software

Customizable Class Management

SEARCH OPERATORS

Operator	Use to see a list of records that .....
Starts With	Start with the data typed in the value field.
Contains	Contain an instance or instances of the data typed in the value field.
Ends With	End with the data typed in the value field.
Like	Contain characters or numbers of which you are unsure of the spelling or sequence. Use the %(percent) and _(underscore) symbols as wildcard symbols. Use the _(underscore) wildcard symbol in the following example: If you wanted to search for a contact but you could not recall if his last name was Bensen or Jensen, type _ensen into Value column of the Last Name filter. The results list could contain any of the following names if they existed in the system: Jensen, Bensen and Densen. Use the %(percent) wildcard symbol in the following example: If you recalled that the last name ended in ensen but were unsure of how many letters preceded the ensen, type %ensen into the Value column of the Last Name. The results list could contain any of the following names if they existed in the system: Jensen, Bensen, Densen, Christensen, and Mortensen.
=	Are equal to the data typed in the value field.
<>	Are not equal to the data typed in the value field.
>	Are greater than the data typed in the value field. (for numeric searches only)
>=	Are greater than or equal to the data typed in the value field. (for numeric searches only)
<	Are less than the data typed in the value field. (for numeric searches only)
<=	Are less than or equal to the data typed in the value field. (for numeric searches only)
Is Missing	The field selected is null or contains no value.
Is Not Missing	The field selected is not null, or does contain a value.

Note: Not every operator is appropriate to use with every field. For example:

When using a search filter in which the name ends in "List", you can expect the value for that field to be a comma delimited list of values. For Category List you would expect to see for example "Instructor, Donor". "Starts With" is almost never an appropriate operator in this case. For Category List, you would most likely want to use the operator "Contains" to locate all records in which the contact's category list contains a particular category.

Conversely, for a search field that does not end in "List", you can expect that this field describes just one piece of data. In that case, "Starts With" or "=" is very likely appropriate.

ProClass Sitemap