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: RecordThe record to which you want to copy filters.
- FromRecord
- Type: RecordThe 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 |
 Copy Code |
|
|---|---|
// 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).