---
title: "Filter Editor"
slug: "filter-editor"
updated: 2023-08-02T09:48:41Z
published: 2023-08-02T09:48:41Z
canonical: "docs.avontus.com/filter-editor"
---

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

# Filter Editor

You can access the **Filter Editor** by right-clicking on a column heading and selecting **Filter Editor**.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/357a1f0d-fba3-4ea7-ae69-966778accc95.png)

In the **Requests**, **Scaffolds**, **Activities**, **Users**, and **Notifications** screens you can find the **Filter** **Editor** which allows the user to specify what data is displayed in the table. This is done by using the following formulas

- [And](/v1/docs/and)
- [Or](/v1/docs/or)
- [NotAnd](/v1/docs/not-and)
- [NotOr](/v1/docs/not-or)

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/ddd17d2d-eeea-4fd0-8c99-5e12acfeb685.png)

The **Filter** **Editor** is accessed in the **Requests**, **Scaffolds**, **Activities**. **Users**, **Notifications** screens by right-clicking a column heading and selecting **Filter** **Editor**.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/4e867364-240b-47a2-afb9-030a6d5672ef.png)

Selecting the downward arrow icon will reveal three ways to filter your data

- **Add Condition** - Create a single condition.
- **Add Group** - Create a group where you can combine two different formulas such as the **And** formula and the **Not And** formula.
- **Add Custom Expression** - Modify and create your own expression.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/3250cd61-54df-422e-a462-ad1b3bb7918d.png)

**Add Condition**

Using either **And**, **Or**, **Not** **And**, **Not** **Or**, users can create a single condition which determines what data is displayed in the table.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/991f6542-9a13-4dcc-81e8-65b0a4b7fcc0.png)

This will display content where the **Activity** **Type** is equal to build.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/22956115-37d5-478b-b363-b7f09e02d24c.png)

**Grouped Formulas**

Grouped expressions allow a user to create an expression that combines two different formulas. For example, you can combine the **And** formula and the **Not And** formula.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/48436e8c-49fc-4086-8f92-3188fa432e13.png)

In the example above, you are filtering results where the status is equal to Awaiting Build but not assigned to Jean Gabin

This will only display content where the status is equal to Awaiting Build but not assigned to Jean Gabin.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/717fd0af-d152-4934-88ca-43edbb58ffdb.png)