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

Version: Available or changed with runtime version 1.0.

Assigns a filter to a field that you specify.

Syntax

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

Parameters

Record
 Type: Record
An instance of the Record data type.

Field
 Type: Any
The field that you want to filter.

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

Remarks

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