About global filters (view filters)

Global filters restrict which records in a view are displayed, or processed by ACL operations. 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.

You can build complex filters with multiple criteria to isolate just the data you are interested in viewing or analyzing in a table. For example, this filter restricts an Accounts Payable 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.

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:

Section contents

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

(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback