Operators for Advanced Searches
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.
|
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.
|
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 |
|
less than | date; number |
|
contains | memo |
|
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 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/2021 - 3/31/2021. |
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/2020 - 12/31/2020. |
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/2021 - 6/30/2021. |
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). |
Parent Topic: Advanced Searches