Assigns a filter to a field that you specify.

Record.SETFILTER(Field, String, [Value],...)



Type: Record

The record that contains the field that you want to filter.


Type: Field

The field that you want to filter.


Type: Text or code

The filter expression. A valid expression consists of alphanumeric characters and one or more of the following operators: <, >, *, &, |, and =. You can use replacement fields (%1, %2, and so on) to insert values at run-time.


Type: Any

Replacement values to insert in replacement fields in the filter expression. The data type of Value must match the data type of Field.

Expand imageRemarks

Expand imageExample

Expand imageSee Also