SETRECFILTER Function (RecordRef)
Sets a filter on a record that is referred to by a RecordRef.
Syntax
RecordRef.SETRECFILTER
Parameters
RecordRef
Type: RecordRef
The RecordRef used to identify the record on which you want to place a filter.
Remarks
This function works the same as the SETRECFILTER Function (Record).
Example
The following example opens the Customer table as a RecordRef variable that is named MyRecordRef. The SETRECFILTER function sets the values in the current key of the current record as a record filter. The GETFILTERS Function (RecordRef) retrieves the filters that have been set and displays them in a message box. No. is displayed because the filter is set on the No. field, which is the current key. This example requires that you create the following variables and text constant and text constants in the C/AL Globals window.
| Variable name | DataType |
|---|---|
| MyRecordRef | RecordRef |
| varFilters | Test |
| Text constant name | ENU value |
|---|---|
| Text000 | The filter is set on the %1 field. |
MyRecordRef.OPEN(DATABASE::Customer);
MyRecordRef.SETRECFILTER;
varFilters := MyRecordRef.GETFILTERS;
MESSAGE(Text000, varFilters);