Record.SetFilter(Any, Text [, 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: Text [, Value: Any,...])


 Type: Record
An instance of the Record data type.

 Type: Any
The field that you want to filter.

 Type: Text
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 runtime.

[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.

The filter set by the SetFilter Method (Record) or the SetRange Method (Record) apply to the currently selected filter group. For more information see FilterGroup Method (Record).

See Also

Record Data Type
Get Started with AL
Developing Extensions