GETFILTER Function (Record)
Gets a list of the filters within the current filter group that are applied to a field.
String := Record.GETFILTER(Field)
Parameters
- Record
Type: Record The input record.
- Field
Type: Field The input field.
Property Value/Return Value
Type: Text constant or code
This string contains a list of the filters applied to the field in the record.
Example
This example requires that you create the following variables and text constant in the C/AL Globals window.
| Variable name | Data type | Subtype |
|---|---|---|
String |
Text |
Not applicable |
CustomerEntry |
Record |
Cust. Ledger Entry |
| Text constant | ConstValue |
|---|---|
Text000 |
The filter is:\%1 |
// Write the following code in the OnRun trigger.
CustomerEntry.SETRANGE(Amount, -100, 100);
String := CustomerEntry.GETFILTER(Amount);
MESSAGE(Text000, String);
The following message is displayed:
The filter is:
-100..100
Example
This example requires that you create the following variable in the C/AL Globals window.
| Variable name | DataType | Subtype |
|---|---|---|
Item |
Record |
Item |
Item.FILTERGROUP(2); // Filter group 2 is applied.
Item.SETFILTER("No.", '1000..1450'); // A filter is set in filter group 2.
MESSAGE('Filtergroup 2 filters, No. field: ' + Item.GETFILTER("No."));
// GETFILTERS prints the filter that is set in filter group 2
Item.FILTERGROUP(0); // Change the current filter group.
// Now filter group 0 is applied.
MESSAGE('Filtergroup 0 filter, No. field: ' + Item.GETFILTER("No."));
// GETFILTERS returns an empty string because there is no filter set
// in the current filter group (0).
Item.SETFILTER("No.", '70000..79999'); // Set another filter, now in filter group 0.
MESSAGE('Now Filtergroup 0 filters, No. field: ' + Item.GETFILTER("No."));
// GETFILTERS prints the new filter set in the filter group 0.
The message windows display the following:
Filtergroup 2 filters, No. field: 1000..1450
Filtergroup 0 filters, No. field:
Now Filtergroup 0 filters, No. field: 70000..79999
See Also
Reference
GETFILTERS Function (Record)
SETFILTER Function (Record)
SETRANGE Function (Record)
FILTERGROUP Function (Record)
Record Data Type