Online Help Center :: Search and Filter Comparison Types

Knowledgebase Home

Search the Knowledgebase

Browse by Category

Knowledgebase Home > DataPages > DataPage Elements

Search and Filter Comparison Types

Equal	A positive match occurs when the provided value is identical to the field value. Not case sensitive. Date/Time fields must match for the entire date and time. Applies to: Text, AutoNumber, Number, Date/Time, Yes/No, File
Contains	Keyword(s) are searched within text fields or file names. If multiple keywords are entered, AND operator is assumed between them. User can also provide a desired operator by entering it in ALL CAPS (i.e. blue OR orange). Use parenthesis to group parameters. Positive match: "The flower that is red." Negative match: "Blue flower" Positive match: "The flower that is blue." Negative match: "Pink flower" Positive match: "Can a red flower turn blue?" Negative match: "Red flower" Applies to: Text, File
Greater Than	All fields containing values greater than the provided value are a positive match. Characters are compared based on their alphabetic position. B is greater than A and C is greater than either A or B. Applies to: Text, AutoNumber, Number, Date/Time, File
Greater Than or Equal	All fields containing values greater than or equal the provided value are a positive match. Characters are compared based on their alphabetic position. B is greater than A and C is greater than either A or B. Applies to: Text, AutoNumber, Number, Date/Time, File
Less Than	All fields containing values less than the provided value are a positive match. Characters are compared based on their alphabetic position. B is less than C and A is less than either B or C. Applies to: Text, AutoNumber, Number, Date/Time, File
Less Than or Equal	All fields containing values less than or equal the provided value are a positive match. Characters are compared based on their alphabetic position. B is less than C and A is less than either B or C. Applies to: Text, AutoNumber, Number, Date/Time, File
Does Not Contain	Performs a negative search on the data within a field and returns records that do not contain keywords defined in the search. A positive match occurs when the keyword(s) are not found within text fields or file names. If multiple keywords are entered, an AND operator is assumed between them. Applies to: Text, File
Not Equal	A positive match occurs when the value provided does not exactly match the values of fields. Applies to: Text, AutoNumber, Number, Date/Time, File
Is Blank	A positive match occurs when the given field has no value. Applies to: Text, Number, Date/Time, File
Is Not Blank	A positive match occurs when the given field has some value. Applies to: Text, Number, Date/Time, File
Today	A positive match occurs when the value of the date field is equal to today's date. Applies to: Date/Time
Current Week	A positive match occurs when the value of the date field is equal to any of the days in the current week. Weeks start on Sunday. Applies to: Date/Time
Current Month	A positive match occurs when the value of the date field is equal to any of the days in the current month. Applies to: Date/Time
Current Year	A positive match occurs when the value of the date field is equal to any of the days in the current year. Applies to: Date/Time
Previous X Days	A positive match occurs when the value of the date field is equal to any of the previous X days. At design time you specify the value for X. Applies to: Date/Time
Next X Days	A positive match occurs when the value of the date field is equal to any of the next X days. At design time you specify the value for X. Applies to: Date/Time
Before Now	A positive match occurs when the value of the date field is in the past. Applies to: Date/Time
After Now	A positive match occurs when the value of the date field is in the future. Applies to: Date/Time
Range	All fields containing values within a specified range. Applies to: AutoNumber, Number, Date/Time,
Begins With	All fields containing values within a specified range based on the starting character(s) of the text string. Applies to: Text (255)

Date/Time Precision

Fields of type Date/Time automatically contain both date and time values, however there may be cases where you want to search for all records belonging to an entire year, or a range of months. In these situations, you can to control the precision by which the date and time values are compared against the search criteria.

To configure the precision of Date/Time fields, use the Precision option in the Configure Search Fields screen (Figure 1).

Each Precision option increases in preciseness:

Date and time: Both date and time values are used in the search. User must search for exact values: “1/12/2007 11:20:23”.
Date: Ignores time values and uses only the date to find matches.
Month and Year: Both the day and time portions are ignored.
Year: Ignores everything except the year portion of the date.