---
title: "Understanding AND vs. OR Filter"
slug: "understanding-and-vs-or-filter"
updated: 2022-06-16T20:40:02Z
published: 2022-06-16T20:40:02Z
canonical: "support.smarteru.com/understanding-and-vs-or-filter"
---

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

# Understanding AND vs. OR Filter

Many of the [grids](/v1/docs/grids) in SmarterU allow you to search the columns to find specific values. By providing a filter, you can limit the contents of the grid to only those rows that meet your criteria.

Oftentimes, you can provide two search filters for a column. If you provide two search filters for a column, you'll need to specify how you want the two filters to be evaluated: AND vs OR.

- AND returns only those rows that meet both of the filters. For example, if you have filter A and filter B, using AND would return rows that meet both filter A and filter B.
- OR returns rows that meet either of the filters. For example, if you have filter A and filter B, using OR would return rows that either meet filter A, meet filter B, or meet filter A and filter B.

![Diagram - And vs Or 20220616](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/Diagram%20-%20And%20vs%20Or%2020220616.png)

For example, suppose we apply two filters to the [Course Builder Dashboard's](/v1/docs/course-builder-dashboard) Task column:

- Contains "exchange"
- Contains "policy"

If we use AND to evaluate the two filters, only tasks that have both "exchange" and "policy" in their name are included.

![](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/understanding-and-vs.-or-filter-image-t3jg7cey.png)

However, if we use OR to evaluate the two filters, users that have either "exchange" or "policy" in their name are included.

![Interface gráfica do usuário, Aplicativo Descrição gerada automaticamente](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/understanding-and-vs.-or-filter-image-ut4om284.png)

## Related

- [Learner Interface: Searching for Courses](/learner-interface-searching-for-courses.md)
- [Learner Interface: Searching the Knowledge Base](/learner-interface-searching-the-knowledge-base.md)
- [Searching a Knowledge Base](/searching-a-knowledge-base.md)
- [Searching for Users](/searching-for-users.md)
- [Searching Quiz Questions](/searching-quiz-questions.md)
- [Searching the Audit Log Report](/searching-the-audit-log-report.md)
- [Searching the Course Builder Dashboard's Grid](/searching-the-course-builder-dashboards-grid.md)
- [Searching the Enrollment Report's Output](/searching-the-enrollment-reports-output.md)
