Page History

In the right pane of the Filter dialog box there is a drop-down list that changes depending on what type of column is selected in the left pane. The following table summarizes the operators that are available for each type of column and the function of the operator. For List data, this table also describes the field for directly entering filter criteria as well as the Select Like right-click command.

Note
Note: By default, Filter uses the exact term that you entered in the filter. For example, if you filter with the term pavement, it will not include examples like cracked pavement or pavement structure. To expand the results in a filter, use % as a wildcard character. See examples below: pavement: for results that have only the word pavement %pavement: for results that end with the word pavement %pavement%: for cases that contain the word pavement pavement%: for cases that start with the word pavement
Note
Note: This table is the general list of available operators, but not all implementations include all of these. To add another operator, contact AgileAssets Contact AgileAssets if your particular implementation does not include an operator you need and ask them to amend the WHERE clause of the SETUP_FILTER table.

Data Type	Operator	Description
Date	=	All records where the date in the column matches the entered date exactly are displayed.
	>=	All records where the date in the column matches or is later than the entered date are displayed.
	<=	All records where the date in the column matches or is earlier than the entered date are displayed.
	>	All records where the date in the column is later than the entered date are displayed.
	<	All records where the date in the column is earlier than the entered date are displayed.
	<>	All records where the date in the column is not the same as the entered date are displayed.
	Between	All records where the date in the column is within the time period set by the two entered dates (the earlier date on the left, the later on the right) are displayed. Note: The displayed dates include the earlier date, but exclude the later date. Therefore, the later date should be set to one day later than the latest date you want displayed.
	Today	All records where the date in the column matches your computer's current date are displayed.
	Yesterday	All records where the date in the column is one day earlier than your computer's current date are displayed.
	This Month	All records where the date in the column has the same month as the month in your computer's current date are displayed.
	Previous Month	All records where the date in the column is one month earlier than the month in your computer's current date are displayed.
	This Week	All records where the date in the column falls on a day that is within the same week as the day in your computer's current date are displayed. (A week is defined is being from Sunday to Saturday.)
	Previous Week	All records where the date in the column falls on a day that is within the previous week as the day in your computer's current date are displayed.
	This Year	All records where the year of the date in the column matches the year of your computer's current date are displayed.
	This Fiscal Year	All records where the date falls within the current fiscal year. (The fiscal year is defined directly in the Oracle database, not in the AgileAssets application.)
	Previous Year	All records where the year of the date in the column is one year earlier than the year of your computer's current date are displayed.
	Previous Fiscal Year	All records where the date falls within the previous fiscal year.
	Current Pay Period	All records where the date falls within the current pay period.
	Previous Pay Period	All records where the date falls in the previous pay period.
	Is Null	All records where the column is null ('blank') are displayed.
	Is Not Null	All records where the column is not null ('blank') are displayed.
List	In List	All records where the column has the selected data element(s) are displayed.
	Not In List	All records where the column does not have the selected data element(s) are displayed.
	Is Null	All records where the column is null ('blank') are displayed.
	Is Not Null	All records where the column is not null ('blank') are displayed.
	Direct Entry Field	After selecting either In List or Not in List, the system displays a list of values along with a field for the direct entry of the item to be selected. Type the string and as you type the system will attempt to identify what you are typing by displaying suggestions. You may continue typing or use the arrow keys to highlight a choice from the displayed suggestions. Once the desired string is shown in the field, press the Enter key to select the item in addition to items already selected, if any. Alternately, you may press Shift+Enter to select only the item (deselecting all other selections, if any). The system places a check mark in the check box to denote that the item is selected.
	Select Like	Once a list of values is displayed by selecting either In List or Not in List, this command is available on a shortcut menu displayed by right-clicking the list. After selecting the command, the application displays a dialog box. In the dialog box, type a string and then choose Select. The application then selects all values in the list that have the string anywhere in the value.
Number	=	All records where the number in the column matches the entered number exactly are displayed.
	>=	All records where the number in the column matches or is larger than the entered number are displayed.
	<=	All records where the number in the column matches or is smaller than the entered number are displayed.
	>	All records where the number in the column is larger than the entered number are displayed.
	<	All records where the number in the column is smaller than the entered number are displayed.
	<>	All records where the number in the column does not match the entered number are displayed.
	Between	All records where the number in the column is within the range set by the two entered numbers (the smaller on the left, the larger on the right), inclusive (that is, the number is between or matches the entered numbers).
	Is Null	All records where the column is null ('blank') are displayed.
	Is Not Null	All records where the column is not null ('blank') are displayed.
Text	=	All records where the column has the text string exactly are displayed.
	<	All records where the column has text that comes before the entered text (that is, earlier in the alphabet).
	>	All records where the column has text that comes after the entered text (that is, later in the alphabet).
	LIKE	This is similar to the equal sign, but is used for wildcard searches. Permitted variables for wildcard searches are the percentage sign (%), which stands for one or more characters, and the underscore (_), which stands for a single character, with the variable appearing in the text string at the location where various characters could occur.
	Is Null	All records where the column is null ('blank

(null

') are displayed.
Is Not Null	All records where the column is not

blank (not null

null ('blank') are displayed.

Space shortcuts

Page tree

Versions Compared

Old Version 2

New Version 3

Key