> For the complete documentation index, see [llms.txt](https://docs.whaly.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.whaly.io/data-management/workbench/model-data/flow-models/flow-steps/filter.md).

# Filter

## What does it do?

It allows you to filter rows from your model.

## How to use it?

On any previously steps available in your editor select a step and click on **Filter**

<figure><img src="/files/AeDbF4JkXtQ9es1LmKM2" alt=""><figcaption></figcaption></figure>

## How to configure it?

<figure><img src="/files/ibeMAGxHdb9xNbTS0wsX" alt=""><figcaption></figcaption></figure>

In order to use the filters you can:

* Modify the global condition from **ANY** to **ALL**
  * ANY means that if one condition is met then the line will be included in the results
  * ALL means that all conditions must be met for the line to be included in the results
* Apply condition to each lines by selecting a column, an operator and value. Depending on your column type, the available operator will change.
  * **STRING**&#x20;
  * **DATE**:
  * **NUMBERS**:
  * **BOOLEAN**:

### List of Available Operators

#### is set / is not set &#x20;

available for STRING / TIME / NUMERIC / BOOLEAN

expects no value

#### equals / does not equal

available for STRING / TIME / NUMERIC / BOOLEAN

expects one or more values

#### is in date range / is not in date range

available for TIME

expects one or more values

#### is before / is after

available for TIME

expects one or more values

#### is greater than

available for NUMERIC

expects one or more values

#### is greater or equal than

available for NUMERIC

expects one or more values

#### is lower than

available for NUMERIC

expects one or more values

#### is lower or equal than

available for NUMERIC

expects one or more values

#### contains

available for STRING

expects one or more values

#### does not contains

available for STRING

expects one or more values

When multiple values are inputed we expect the condition to match at least one of the values to return the line.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.whaly.io/data-management/workbench/model-data/flow-models/flow-steps/filter.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.