---
title: "Searching, Filtering, and Grouping"
slug: "searching-filtering-grouping"
updated: 2024-09-13T15:27:19Z
published: 2024-09-13T15:27:19Z
canonical: "help.schola.com/searching-filtering-grouping"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.schola.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Searching, Filtering, and Grouping

The Schola Relationship Manager is a comprehensive database. With that comes thorough search, sort, and filter capabilities for working with leads and their data.

This is helpful for understanding groups of leads, trends, and making bulk edits.

#### Searching

You can search for any term within the Relationship Manager by entering your search term into the field at the top left of the database. As you start typing, you'll start to see corresponding Leads filter through based on your search term.

You can also search for the same term in each Stage Tab by clicking through those tabs.

Simply delete your search term and all Leads will show up again.

![searching 1 v2.png](https://cdn.us.document360.io/24561116-0905-4f9f-91ac-4173c94f303a/Images/Documentation/searching%201%20v2.png)

#### Filtering

#### 

You can easily filter by School Year by clicking the School Year(s) field in the top right of the database. Here, you'll see options for any school years included in Lead records within your Relationship Manager. You can also select multiple school years at a time.

Click the Clear All Filters Button to view all your Leads again.

![searching 2 v2.png](https://cdn.us.document360.io/24561116-0905-4f9f-91ac-4173c94f303a/Images/Documentation/searching%202%20v2.png)

To filter more granularly, click the Filter icon at the bottom right of the database.

![searching 3 v2.png](https://cdn.us.document360.io/24561116-0905-4f9f-91ac-4173c94f303a/Images/Documentation/searching%203%20v2.png)

This will bring up a prompt to create filter rules or groups.

![searching 7 v2.png](https://cdn.us.document360.io/24561116-0905-4f9f-91ac-4173c94f303a/Images/Documentation/searching%207%20v2.png)

Select the field you'd like to filter for in the first box. Choices will correspond to Lead information columns.

![searching 4 v2.png](https://cdn.us.document360.io/24561116-0905-4f9f-91ac-4173c94f303a/Images/Documentation/searching%204%20v2.png)

Select the function for your filter in the next box.

![searching 5 v2.png](https://cdn.us.document360.io/24561116-0905-4f9f-91ac-4173c94f303a/Images/Documentation/searching%205%20v2.png)

Finally, add the specific term you're filtering for in the last box.

![searching 6 v2.png](https://cdn.us.document360.io/24561116-0905-4f9f-91ac-4173c94f303a/Images/Documentation/searching%206%20v2.png)

You'll see Lead records update as soon as you add the filter parameters.

You can add additional filter rules or groups by clicking the +Add button.

![searching 8 v2.png](https://cdn.us.document360.io/24561116-0905-4f9f-91ac-4173c94f303a/Images/Documentation/searching%208%20v2.png)

When you're done working with your filters and are ready to see all of your Leads again, click Clear Filters.

![searching 9 v2.png](https://cdn.us.document360.io/24561116-0905-4f9f-91ac-4173c94f303a/Images/Documentation/searching%209%20v2.png)

#### Grouping

Grouping is a great way to visualize your leads in a different way - essentially by categories based on the information included in Relationship Manager columns.

You can group Leads by clicking on the Group by icon at the bottom right of the database.

![searching 10 v2.png](https://cdn.us.document360.io/24561116-0905-4f9f-91ac-4173c94f303a/Images/Documentation/searching%2010%20v2.png)

Select the column you'd like to group by, and you'll see your view change to a pivot table format, based on the parameter(s) you chose.

![searching 11 v2.png](https://cdn.us.document360.io/24561116-0905-4f9f-91ac-4173c94f303a/Images/Documentation/searching%2011%20v2.png)

Click the arrow next to each category to see the Leads within that group.

![searching 12 v2.png](https://cdn.us.document360.io/24561116-0905-4f9f-91ac-4173c94f303a/Images/Documentation/searching%2012%20v2.png)

You can group by multiple parameters by clicking + Add another group.

![searching 14 v2.png](https://cdn.us.document360.io/24561116-0905-4f9f-91ac-4173c94f303a/Images/Documentation/searching%2014%20v2.png)

This will add the second grouping beneath the first. View Leads within each group by clicking the arrows next to each category.

![searching 15 v2.png](https://cdn.us.document360.io/24561116-0905-4f9f-91ac-4173c94f303a/Images/Documentation/searching%2015%20v2.png)

Your grouping will apply to each Stage Tab until you select the X in the Group by prompt.

![searching 13 v2.png](https://cdn.us.document360.io/24561116-0905-4f9f-91ac-4173c94f303a/Images/Documentation/searching%2013%20v2.png)

#### Sorting

You can sort leads by Relationship Manager columns by clicking on the Sort by icon at the bottom right of the database.

![searching 16 v2.png](https://cdn.us.document360.io/24561116-0905-4f9f-91ac-4173c94f303a/Images/Documentation/searching%2016%20v2.png)

Note: You can also sort by clicking directly on the column title you'd like to sort by.

![searching 17 v2.png](https://cdn.us.document360.io/24561116-0905-4f9f-91ac-4173c94f303a/Images/Documentation/searching%2017%20v2.png)

The central database for all of your school's Leads - including those generated by Schola and/or those that you upload directly.