Assigns a filter to a field that you specify.
Record.SETFILTER(Field, String, [Value],...) |
Parameters
- Record
- Type: RecordThe record that contains the field that you want to filter.
- Field
- Type: FieldThe field that you want to filter.
- String
- Type: Text or codeThe filter expression. A valid expression consists of alphanumeric characters and one or more of the following operators: <, >, *, &, |, and =. You can use replacement fields (%1, %2, and so on) to insert values at run-time.
- Value
- Type: AnyReplacement values to insert in replacement fields in the filter expression. The data type of Value must match the data type of Field.
Remarks
If the function is called with a field for which a filter already exists, that filter will be removed before the new one is set. You can construct filters using the following operators:
- .. Range
- & And
- | Or
- < Less than
- <= Less than or equal
to
- > Greater than
- >= Greater than or equal
to
- <> Different
from
- * Forms a part of
value
- @ Case-insensitive
Example
The following table shows examples of filters.
Filter | Description |
---|---|
A..Z |
A range from A to Z |
A|G |
A or G |
F.. & *A/S |
A range from F and A/S is included in the field |
<>B |
All except B |
<>'' |
All not blank |
<=200 | >500 |
All less than or equal to 200 or greater than 500 |
This example requires that you create the following variable.
Name | DataType | Subtype |
---|---|---|
GLAccountRec |
Record |
G/L Account |
Copy Code | |
---|---|
// Using a filter with replacement field. // This filter selects all accounts in the range from 100 to 200 // and No. 300. GLAccountRec.SETFILTER("No.", '%1..%2|%3', '100', '200', '300'); // Using a filter entered directly in a string. // This filter, which is entered as a string, has the same result as // the previous example. // This filter selects all accounts in the range from 100 to 200 and // and No. 300. GLAccountRec.SETFILTER("No.", '100..200|300'); |