Working with Filters

Filters control the records that you see in list views and reports. You can apply filters against profiles, reconciliations, or reconciliation transaction attributes, including system attributes as well as alert types, balances and balance details.

Everyone can save private filters for future use. Administrators and power users can also publish filters so that they are accessible by other users and these are then marked as Public.

You can provide values for the attributes that you want to filter on and the operand to use for filtering. Typical operands include the following: equal to, not equal to, starts with, ends with, contains, greater than, less than, and so on. The available operands depends on the attribute's data type. For example, operands for filtering text values are different than the operands for filtering numeric values. Filters are combined together using and logic, which means only those records that meet all filter criteria are displayed.

You can also create more complex filters using and as well as or logic and grouping logic to determine the order in which filters are applied.

Where Are Filters Used in Reconciliation Compliance

There are many locations within Reconciliation Compliance where filters can be used. The functionality remains consistent throughout these different areas:

  • Reconciliations
  • Transactions
  • Profiles
  • Periods -

    You can use filters on the Periods dialog to help you narrow down your period list so that you can view only the periods you want to work with. This is especially useful when you are working with large numbers of periods over several years or are working with daily periods. See Filtering the Periods List

  • Manage Currency Rates
  • Manage Data Load
  • Manage Formats
  • Jobs
  • Archiving
  • Manage Attributes
  • Manage Filters
  • Manage Lists
  • Manage Currencies
  • Manage Users
  • Manage Teams
  • Manage Alert Types and Alerts
  • Managing Reports - Used in Manage Queries, Manage Report Groups, Manage Reports

To View Existing Saved Filters

To view filters:

  1. From Home, click Application, then Configuration
  2. Click Filters to see existing filters. Public filters are marked with a check mark.


    Filters configuration dialog

    Actions you can take from this dialog are:
    Filters action bar

    • New (+) - create a new filter
    • Edit - to make changes to an existing filter
    • Duplicate - to create a second filter the same as the existing one
    • Delete - to delete a filter
    • Publish - to publish a filter which makes it Public and available to all users
    • View - allows you to sort and reorder the columns

Creating a New Filter

To create a new filter:

  1. From Home, click Application, then Configuration and then Filters.
    Filters configuration dialog
  2. Click New (+) to add a new filter.

    Note:

    You can also add filters from the Reconciliations List, Transactions List, or Profiles List.

    New Filter Definition Dialog
  3. Enter the following:

    • Name

    • Description

    • Type—Select one filter type: Alert, Balance, Detail Balance, Matching, Profile, Reconciliation, or Transaction

    • Filter Definition

      A group of conditions that limit the list.

    • Condition—You can define the properties of a condition or group:

      • Conjunction—Select And or Or. These state how this condition or group relate to prior sibling conditions or groups. This field is enabled only if the selected node is not the first child of its parent node.

      • Attribute—An attribute is a field or value that a condition will be comparing to a value for inclusion in the result set of a filter. However, for the case of a filter, an attribute denotes more than the list of user-defined attributes.

      • Operand—States what kind of evaluation to perform against the attribute. For example, Equals, Between, Does not Equal, Greater than, Is blank, Is not blank, Less than, Not between.

      • Value—Specifies what values to compare the attribute against. The type of attribute determines what input field is available.

Using the Filter Bar to Adjust Your View

The filter bar works across many different areas in Account Reconciliation. Here's an example of the filter bar on the Filter configuration. Note that the default of ALL is used. This means that all objects are displayed unless you choose to make a selection of filter attributes.
Filter bar

To add a filtering attribute, click + Add a New Filter. Choose the filter attribute you'd like to add and it appears on the filter bar.


Filter bar add

Another example of a list of possible filtering attributes looks like this from the Reconciliations dialog. You can scroll through the list or search to find the filter attributes you want to add.
Filter columns on Reconciliations

Using a Date Range

Some filter atributes have a date range. For example, if you wanted to add another filter attribute to the filter bar, such as Created On, you can use the date range feature. Narrow your view by using a date value and then use the Operand field to set the conditions for dates values that meet this criteria:
Filter Bar Date Range

Saving and Publishing Filters

All filters are saved as private filters but can be set to Published so that other users can use those same filters.

If you Publish the filter, it will be marked as Public .