COPYFILTERS Function (Record)
Copies all the filters set by the SETFILTER Function (Record) or the SETRANGE Function (Record) from one record to another.
Record.COPYFILTERS(FromRecord)
Parameters
- Record
Type: Record The record to which you want to copy filters.
- FromRecord
Type: Record The record from which you want to copy filters.
Remarks
This function is used to apply the filters defined for one record to another record. The filters are used as a basis for counting, searching, calculating, or a similar operation.
Example
This example requires that you create the following variables.
| Variable name | DataType | Subtype |
|---|---|---|
Customer1 |
Record |
Customer |
Customer2 |
Record |
Customer |
Count |
Integer |
Not applicable |
// Set filters on fields in a Customer record
Customer1.SETFILTER("No.", '<1000');
Customer1.SETRANGE("Credit Limit (LCY)", 10000, 20000);
Customer1.MARKEDONLY(TRUE);
// Apply filters to another record
Customer2.COPYFILTERS(Customer1);
Count := Customer2.COUNT;
The filters defined for Customer1 are copied and applied to Customer2. This affects the result returned by the COUNT Function (Record).