About global filters (view filters)

Global filters restrict which records in a view are displayed, or processed by ACL operations. You can build simple filters with a single criterion to broadly filter records, or complex filters with multiple criteria to isolate very specific subsets of data.

For example, you could filter an Accounts Payable table by vendor number so that only the records associated with a particular vendor are displayed or processed:

Vendor_No = "14438"

Or you could build a complex filter that restricts the table to invoices from vendor 14438, submitted in 2014, that are $1000.00 or greater:

(Vendor_No = "14438") AND (BETWEEN(Invoice_Date,`20140101`,`20141231`)) AND
(Invoice_Amount >= 1000.00)

You can apply only one filter at a time to a view, but as the example above shows, you can use Boolean operators to combine multiple criteria in a single filter. You can also use operators to combine two or more existing named filters, or to combine named and ad hoc filters.

Partial matching is supported when filtering character data – that is, the filter value can be contained by a longer value in the field you are using for filtering. For example:

The filter values must appear at the start of fields to constitute a match. Partial matching is enabled when the Exact Character Comparisons option is off (the default setting). If the option is on, partial matching is disabled and the filter value must exactly match a value in a field to constitute a match. For more information, see Options dialog box: Table tab.

A global filter remains active until you remove it, replace it with another global filter, or close the table. You can make a global filter the default filter for a table so that it is automatically applied every time you open the table. Global filters differ from local filters, which are active only during a single execution of a single ACL operation.

When a global filter is active, the Global Filter indicator appears in the status bar followed by the filter syntax or the filter name, depending on whether the filter is ad hoc or named. For example:

There are several different ways to create and apply global filters:

Related concepts
Using filters
About local filters (command filters)
About quick filters
About data filters

(C) 2015 ACL Services Ltd. All Rights Reserved.