Record.SetFilter(Any, String [, Any,...]) Method

Version: Available or changed with runtime version 1.0.

Assigns a filter to a field that you specify.


 Record.SetFilter(Field: Any, String: String [, Value: Any,...])


 Type: Record
An instance of the Record data type.

 Type: Any
The field that you want to filter.

 Type: String
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.

[Optional] Value
 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.


SetFilter does not filter for empty values. For example, if you set MyRecord.SetFilter(MyTextField, ''); no filter is applied. This method is like the SetFilter Method (FieldRef) method. For more information, see FieldRef.SetFilter(String [, Any,...]) Method.

See Also

Record Data Type
Getting Started with AL
Developing Extensions