Operators for Advanced Search

When you apply advanced settings to a search, you can use a number of comparative operators, such as "equals," "less than," "greater than," and "starts with."

You use different operators with different data types: string, date, number, memo, check box, and employee. The operators that display depend on the type of field that is selected.

Operator	Data Type	Description
equals	string; date; number; employee	Finds exact match. The user can select only one value from a list for a drop-down or lookup. The user can select only one date from a calendar or type one date using the keyboard for a date field. For other fields, the user can enter text and the system must find an exact match on that text.
does not equal	string; date; number; employee	Finds records that are not an exact match.
in list	string; date;employee	Default for drop-down list and radio buttons Select many values from a list for a drop-down, lookup, or radio button. You can select many dates from a calendar or type in a date using the keyboard. You can enter multiple text phrases in the search list separated by semicolons for character and memo fields. The system will search for a record that has an exact match on one of those phrases.
is not in list		Searches for records that do not have the items in the list.
starts with	string	Find all records that start with certain characters.
greater than	date; number	Default for number and currency fields. Find all records that have a number, date or text (by ascending sort order) greater than the entered number, date or text.
less than	date; number	Find all records that have a number, date or text (by ascending sort order) less than the entered number, date or text.
contains	memo	Default for character and memo fields Find all records that have the entered text somewhere in the field.
does not contain	memo
empty	memo	Find all records that have nothing in this field. The search list is disabled or not available when this operator is selected.
not empty	memo	Find all records that have something populated in this field. The search list is disabled or not available when this operator is selected
checked	checkbox
not checked	checkbox
starts with	employee
greater than or equal to		Find all records that have a number, date or text (by ascending sort order) greater than or equal to the entered number, date or text.
less than or equal to		: Find all records that have a number, date or text (by ascending sort order) less than or equal to the entered number, date or text.
between		Enter exactly two values in the search list for this operator. Finds all records that have a value between the two values entered.
is me	employee name; employee number	Search for records that belong to you.
is not me	employee name; employee number	Search for records that do not belong to you.
is mine	organizations	Find all records where the user's employee home organization is associated in the selected organization lookup
is not mine	organizations	Find all records where the user's employee home organization is not associated
is active company	Multicompany only; Company lookups only	The search list is disabled and the system searches for records that are in the same company as the user is currently in.
is home company	Multicompany only; Company lookups only	The search list is disabled and the system searches for records that are in the same company as the home company for the employee of this user
is not home company	Multicompany only; Company lookups only	The search list is disabled and the system searches for records that are in a different company than the home company for the employee of this user.
checked	checkboxes only	Default is selected; search list is disabled or not available when this operator is selected.
not checked		Search list is disabled or not available when this operator is selected
is today	date	Finds records where the date is the same as today's date. The search list is disabled or not available when this operator is selected.
month is	date	Finds records where the date is in the selected month. The search list is a drop-down with all the months (January - December) listed. The user can select multiple months. Usually used in conjunction with Year is.
quarter is	date	Finds records where the date is in the selected quarter. The search list is a drop-down with all the quarters (1st - 4th) listed. The user can select multiple quarters. The quarters are Jan 1 - Mar 31, Apr 1 - Jun 30, Jul 1 - Sep 30, Oct 1 - Dec 31. Usually used in conjunction with Year is.
year is	date	Finds records where the date is in the selected year. The search list is a number field where the user must enter 4 digits.
this week	date	Finds records where the date is in this week (defined from Sun - Sat). The search list is disabled or not available when this operator is selected. For example, if today is Wed 3/9 and I use This week, it will search for dates between Sun 3/6 - Sat 3/12.
this month	date	Finds records where the date is in this month (defined from the 1st - last date of the current month). The search list is disabled or not available when this operator is selected. For example, if today is Wed 3/9 and I use This month, it will search for dates between 3/1 - 3/31.
last month	date	Finds records where the date is in last month (defined from the 1st - last date of the previous month). The search list is disabled or not available when this operator is selected. For example, if today is Wed 3/9 and I use Last month, it will search for dates between 2/1 - 2/29.
next month	date	Finds records where the date is in the next month (defined from the 1st - last date of the next month). The search list is disabled or not available when this operator is selected. For example, if today is Wed 3/9 and I use Next month, it will search for dates between 4/1 - 4/30.
this quarter	date	Finds records where the date is in the this quarter. The search list is disabled or not available when this operator is selected. The quarters are Jan 1 - Mar 31, Apr 1 - Jun 30, Jul 1 - Sep 30, Oct 1 - Dec 31. If I search on 3/9 and I use This quarter, it will search for dates between 1/1/2016 - 3/31/2016.
last quarter	date	Finds records where the date is in last quarter. The search list is disabled or not available when this operator is selected. The quarters are Jan 1 - Mar 31, Apr 1 - Jun 30, Jul 1 - Sep 30, Oct 1 - Dec 31. If I search on 3/9 and I use Last quarter, it will search for dates between 10/1/2015 - 12/31/2015.
next quarter	date	Finds records where the date is in the next quarter. The search list is disabled or not available when this operator is selected. The quarters are Jan 1 - Mar 31, Apr 1 - Jun 30, Jul 1 - Sep 30, Oct 1 - Dec 31. If I search on 3/9 and I use Next quarter, it will search for dates between 4/1/2016 - 6/30/2016
last days	date	Finds records where the date was in the number of entered days. The user must enter a number. For example, if today is 3/9 and I enter Last days 3, it will find all records with a date between 3/6 - 3/9 (today is counted plus the previous 3 days).
next days	date	Finds records where the date will occur in the number of entered days. The user must enter a number. For example, if today is 3/9 and I enter Next days 3, it will find all records with a date between 3/9 - 3/12 (today is counted plus the next 3 days).