Filter data and filter documents

Filter data

On many Onvio screens that present lists or grids of data, you can create filters to control the information that is displayed on the screen and in various firm management reports.
You can access filters through a
Show Filter
button, a
Filters
panel on the left side of the screen, and in some cases, a quick filter button.
  1. If the filter area is hidden, select
    Show Filter
    , and then select
    Edit Filter
    .
  2. Select
    Add Rule
    and create 1 or more filter rules by selecting an option and building a statement to include or exclude information. Use
    AND
    /
    OR
    statements to make the rule more specific.
  3. If you're mixing
    AND
    and
    OR
    statements, add a group to combine the rules so that they’ll operate together. You can use multiple groups to create complex rules. The primary
    AND
    or
    OR
    statement is at the top of the panel. The
    AND
    or
    OR
    statements for groups are indented below it.
Example
The following filter shows all clients who have the status of active, OR clients who are inactive AND have left the firm since 1/1/2017. (For dates, "less than" means "before," and "greater than" means "after.")
Filter Data Example
(Rule 1)
Status is Active
OR
(Group 1 Rule 1)
Status is Inactive
AND
(Group 1 Rule 2)
Left Date is greater than 1/1/2017
Once you create and apply a filter, it will stay active for future Onvio sessions until you change or remove the filter. You can remove filters, or rules and groups from a filter, one of two ways.
  • Select an
    X
    in the
    Filter
    panel to delete a specific rule or group.
  • Select
    Edit Filter
    to open a panel with all of the filter's details, where you can delete specific rules or clear the entire filter.

Filters panel

Use the Filters panel to organize projects and tasks.
  1. If necessary, select the
    Show Panel
    Show Panel button to expand the
    Filters
    panel.
  2. Make selections in one or more of the expandable sections.
  3. To filter by criteria not represented by the available sections, use the
    Advanced Filters
    section at the bottom of the panel, where you can build a custom filter.
    All the filtering criteria you select in the panel combine to narrow the data displayed on the screen. Onvio will retain the filter until you change it or clear it.
    1. When building a custom filter in the
      Advanced Filters
      section, mark the
      Custom Filter
      checkbox and select
      Edit
      .
    2. Select
      Add Rule
      and create 1 or more filter rules by selecting an option and building a statement to include or exclude information. Use
      AND
      /
      OR
      statements to make the rule more specific.
    3. If you are mixing
      AND
      and
      OR
      statements, add a group to combine the rules so that they’ll operate together. You can use multiple groups to create complex rules. The primary
      AND
      or
      OR
      statement is at the top of the panel. The
      AND
      or
      OR
      statements for groups are indented below it.
Example
The following filter shows all clients who have the status of active, OR clients who are inactive AND have left the firm since 1/1/2017. (For dates, "less than" means "before," and "greater than" means "after.")
Filter Data Example
(Rule 1)
Status is Active
OR
(Group 1 Rule 1)
Status is Inactive
AND
(Group 1 Rule 2)
Left Date is greater than 1/1/2017
Once you create and apply a filter, it will stay active for future Onvio sessions until you change or remove the filter.
The heading on this screen is followed by
(Filtered)
when a filter has been applied.
You can remove filters, or rules and groups from a filter, one of two ways.
  • Remove an
    X
    in an expandable section of the
    Filters
    panel to delete a specific rule or group.
  • Select
    Edit
    in the
    Advanced Filters
    section to open a panel with all of the custom filter's details, where you can delete specific rules or clear the entire custom filter.

Quick Filter button

On some screens, other filtering capabilities may be supplemented by a quick filter button, which enables you to quickly filter by a common criterion. One example is on the
Billing Selection
screen (
Setup
Time & Billing
Billing
Selection
tab), where you can hide entries with zero balances using the
Zero Balance WIP
Zero Balance WIP button. Select the button to turn this quick filter on or off. When the button is orange, the filter is applied (in this case, items with zero balances are hidden).
When you remove a filter, Onvio applies the changes immediately.

Filter documents

In the
Client
,
Firm
, and
My Documents
tabs of the
Documents
area, you can select
Show Filter
to turn on filtering at the storage level to create filters, and/or clear all existing filters.
  1. To display filter buttons in the storage area of the
    Client
    ,
    Firm
    , or
    My Documents
    tab, select the
    Show Filter
    button.
    note
    The
    Show filter
    button appears white when the column filter buttons are hidden, and orange when the column filter buttons are displayed in the header row for each column in the grid.
  2. Select a filter button in a column to sort the column by ascending or descending order, and/or create a filter to include or exclude information by condition or value.
    • If you choose to filter by value, you can enter a search term in the
      Search
      field, and/or mark the checkboxes next to the items that you want to display in the grid.
    • If you choose to filter by condition, you can apply a filter for items where the value Contains, Equals, Begins with, and so forth. Use AND or OR statements to make the rule more specific.