These functions allow us to retrieve the filters on a single field or all the filters on a record (table) and assign the result to a text variable. Their syntax is as follows:
ResultString := FilteredRecord.GETFILTER(FilteredField) ResultString := FilteredRecord.GETFILTERS
Similar functions exist for query objects. Those syntaxes are as follows:
ResultString := FilteredQuery.GETFILTER(FilteredColumn) ResultString := FilteredQuery.GETFILTERS
The text contents of the ResultString will contain an identifier for each filtered field and the currently applied value of the filter. GETFILTERS is often used to retrieve the filters on a table and print them as part of a report heading. The ResultString will look similar to the following:
Customer:.No.: 10000..999999, Balance: >0