Using the field filter
The field filter allows you to quickly filter values by each field. Grouping of different fields and filtering timestamp fields by date are not supported in this method.
Insert a filter
Right-click the field that you want to filter on. From the drop-down menu, select Add to Filter. To specify a value to filter, either input it manually or use the simple filter builder. Operator validity is determined by the field type.
You can use the standard Landmark operators to filter data. They include:
| Operator | Description |
|---|---|
| > | Returns values greater than the value entered |
| < | Returns values less than the value entered |
| = | Returns values equal to the value entered |
| >= | Returns values greater than or equal to the value entered |
| <= | Returns values less than or equal to the value entered |
| != | Returns values not equal to the value entered |
| | | Creates an OR statement. This filter returns records that matches at least one
condition. For example, typing 1010 | 1015 in the
value field for the Vendor field returns all the records for both vendors, 1010 and
1015. |
Access the simple filter builder
The simple filter builder is useful if you want to know what the valid operators are for a field. String, Numeric, and Boolean fields have different valid operators.
Infor does not recommend the construction of filters with complex operations in the field filters. When you use the |, or, and, or & operators, a warning appears. This warning can be accepted by clicking Yes or disabled by navigating to Settings and disabling Filter notifications. This is especially helpful if you need to use | or or.