Filtering Grids

Filtering Grids

The results listed in any AdvisorEngine 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. Select a comparator from the drop-down and enter your filter criteria if applicable. (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. Multiple filters act as "AND" logic, showing you only rows that match all filters you have in place.

Note: You cannot add multiple filters to the same column. If you need to filter a column by more than one criteria, use Advanced Search instead.

Removing an Active Filter

  1. Click the active funnel .
  2. Click Clear Filter.

    • Related Articles

    • Grids Overview

      Grids are one of the primary methods of displaying data in AdvisorEngine CRM. Although the purpose of each Grid may differ, they all retain similar functionality. Being comfortable with organizing the data presented to you in a Grid will greatly ...

    • New User Module 2-3: Grids and Searching

      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 you see. Grids Overview Sorting Grids Filtering ...

    • Navigating Grids

      Grids in AdvisorEngine CRM have basic navigation features to help you move around and view your data in whatever manner you need. Along the bottom of most Grids you will find the following controls: Expand or Compress Vertical View Expanded view will ...

    • 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 ...

    • Model Center Searching and Filtering

      The Model Center contains a robust search and filtering engine to help you narrow down what you are looking for. Searching Models can be searched by all or part of the Product Name. Start typing in the Search box to have the list dynamically filtered ...