When users select the advanced search tool, two additional drop-down menus will be displayed at the top of the list page. This first menu contains any previously saved searches. The second will contain a list of data fields that can be used to filter and sort the data. Once a desired field has been selected, the system will generate a list of available filter operations dependent on the chosen data type.
- Is Equals (=) This filter can apply to columns with numerical or character values and will filter out
rows where the data in the column selected data does not exactly match the item that was input. This provides an exact match for the value or term entered. - Is Less Than (<) This filter can apply to columns with numerical or date data, such as age or
grade. The resulting list view will filter out any rows where the selected column data is greater
than what was input. - Is Greater Than (>) This filter can apply to columns with numerical or date data, such as age or
grade. The resulting list view will filter out any rows where the selected column data is less than
what was input. - Is not This will filter applies to numeric, character, and date columns. When selected, the list
view will filter out any rows where data in the column selected is equivalent to what was input. - Is between (exclusive) This filter applies to columns with either numerical or date data and will provide a more narrow result. For example, if the values entered are 2 and 8, the system will return all rows where the column value being filtered on is either 3, 4, 5, 6 or 7.
- Is between (inclusive) This filter applies to columns with either numerical or date data and will provide a broader result. For example, if the values entered are 2 and 8, the system will return all rows where the column value being filtered on is either 2, 3, 4, 5, 6, 7 and 8.
- Matches This filter applies to character data, such as an email address or name and is a wild
card search. This will return any rows where the column selected matches the
value including a partial match. For example, if the email column is selected when filtering the People list view and the value entered is “@gmail” the system will return all rows with gmail.com email domains.