Removes all filters, including any special filters set by the MARKEDONLY Function (Record) and changes the current key to the primary key. Also removes any marks on the record and clears any C/AL variables on the record.

RecordRef.RESET

Parameters

RecordRef

Type: RecordRef

Refers to the record that you want to reset.

Remarks

If no table is selected, this function returns an error.

This function works the same as the RESET Function (Record).

Example

The following example opens the Customer (18) table and creates a RecordRef variable that is named RecRef. The GETFILTERS Function (RecordRef) gets filters that have been applied to records in the table. The filters that are returned, if any, are stored in the Filters1 variable and displayed in message box. In this example, no filters are set so the message is blank. The SETRECFILTER Function (RecordRef) sets a filter on the current key of the current record that is represented by the RecRef variable. The GETFILTERS Function (RecordRef) gets the filters that have been set and stores the value in the Filters2 variable. The message displays No. because the No. field is set as a filter. The RESET function removes the filter that was set. The value of the filter that is returned by the GETFILTERS Function (RecordRef) after the RESET Function (RecordRef) is executed is stored in the Filters3 variable. Filter3 is blank because the filter that was set by RecRef.SETRECFILTER; is removed by the RESET function. This example requires that create the following variables text constants in the C/AL Globals window.

Variable name DataType

RecRef

RecordRef

Filters1

Text

Filters2

Text

Filters3

Text

Text constant name DataType ENU value

Text000

Text

Filter before filter is set is: %1.

Text001

Text

Filter after filter is set is: %1.

Text002

Text

Filter after filter is reset is: %1.

 Copy Code
RecRef.OPEN(DATABASE::Customer);
Filters1 := RecRef.GETFILTERS;
MESSAGE(Text000, Filters1);
RecRef.SETRECFILTER;
Filters2 := RecRef.GETFILTERS;
MESSAGE(Text001, Filters2);
RecRef.RESET;
Filters3 := RecRef.GETFILTERS;
MESSAGE(Text002, Filters3);

See Also