Filters are made up of expressions, which consist of fields, operators, values, and more. These key parts play the following roles in the expression:
- Field—Which column you want to filter. For example, the Date column.
- Operator—How you want to filter the column. For example,
Greater Than or Equal To. - Value—What to filter for. For example, 01/01/2022.
This would filter for dates greater than or equal to, 01/01/2022 in the Date column.
Once a filter is applied, you are able to use modifiers in the column header's filter fields to refine values further. Learn more in Column header filters.
The following diagram shows the elements of the Advanced Filter:
| Filter Menu—Select, create, or edit saved filters. | |
Filter—Create groups of expressions, which are connected by a condition type. A condition type is used to either widen or narrow your filter results. A condition type can be either:
For example, you are configuring an expression to display records with a balance equal to $100, and a second to filter for the date of May 4. If your condition type for the expression group is | |
| Sort—Sorts the record list by either ascending or descending values for the field, or fields selected. | |
| Aggregation—Summarize the contents of a column at the bottom of the list form. For a column of number fields, the count results in a summation of the values of all records returned by the active filter. For non-number columns, the count represents the number of records returned by the filter that have a value in that field. For a column of currency values, the aggregate is automatically grouped by currency codes. Each currency code represented in the list form has its own aggregated value at the bottom of the column. |