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.

// 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.

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