Creating local filters

As part of an ACL operation, you can create a local filter, or select an existing named filter, to restrict which records in a view are processed.

Simple filters can be manually entered in the If text box in ACL command dialog boxes. More complex filters, using multiple criteria, are easier to create in the Expression Builder. If you want to name and save a local filter, you must create it in the Expression Builder.

To create or select a local filter and apply it to an ACL operation:

  1. Do one of the following:
    • Enter the filter expression in the If text box (for example, Invoice_Amount > 1000.00).

      The filter is ad hoc and retained only during processing of the ACL operation.

    • Click If to create a filter, or select an existing filter, using the Expression Builder.

  2. If you are using the Expression Builder, do one of the following:
    • Create the filter expression, optionally enter a name for the filter in the Save As text box, and click OK.

      If you enter a name for the filter, it is permanently saved with the table. If you do not enter a name, the filter is ad hoc and retained only during processing of the ACL operation.

      Filter names are limited to 31 alphanumeric characters and cannot begin with a number.

      For information about using the Expression Builder, see Creating expressions using the Expression Builder.

    • Double-click a named filter in the Filters list, and click OK.

      Only named filters permanently saved with the table appear in the Filters list. Ad hoc filters do not appear in the Filters list.

Related concepts
About local filters (command filters)
Related tasks
Applying global filters to views
Maintaining named filters


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