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.
- Type: RecordRef Refers to the record that you want to reset.
If no table is selected, this function returns an error.
This function works the same as the RESET Function (Record).
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.
|Text constant name||DataType||ENU value|
Filter before filter is set is: %1.
Filter after filter is set is: %1.
Filter after filter is reset is: %1.
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);