Filtering Grids

Filtering Grids

The results listed in any CRM Grid may be filtered based on the contents of a column and the criteria you specify.

For example, you may wish to view only those Records with a particular Advisor 1, or find Records whose Primary Phone is blank.

Adding a Filter

  1. Click the funnel on the column to filter by.
  2. Enter your filter criteria. (The available options to filter by will vary based on the data type of the column.)
  3. Click Filter to view the results. The funnel icon changes to denote an active filter .

You may filter more than one column at a time to further refine your view.

Removing an Active Filter

  1. Click the active funnel .
  2. Click Clear Filter.
Note:
You cannot add multiple filters to the same column, but you can accomplish the same results by using an Advanced Search.
    • Related Articles

    • New User Module 2-3: Grids and Searching

      Denotes an Article that contains video resources. Grid Navigation Learn all the flips and switches in a Grid to help you refine the view of your data. Navigating Grids Grid Tools Learn about the various tools in a Grid that let you control what data ...
    • Grids Overview

      Grids are one of the primary methods of displaying data in AdvisorEngine CRM. Although the purpose and defaults for each Grid may differ, they all retain similar functionality. Being able to organize the data presented to you in a Grid will greatly ...
    • Navigating Grids

      Grids in AdvisorEngine CRM have basic navigation features to help you move around and view your data easily. Along the bottom of most Grids you will find the following controls. Expand or Compress Vertical View Expanded view will continue the Grid ...
    • Grouping Grids

      Grids may be shown in a view that groups together like data from a particular column. For example, you could group all Actions by Record Name to see how many Actions each Record has or group all Records by State of Residence to see which clients are ...
    • Sorting Grids

      Any Grid in AdvisorEngine CRM may be sorted by any visible column. Click a column header to sort all rows by the contents of that column in ascending order. . Click the column header a second time to sort in descending order. . Click the column ...