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

# filters

# `prefect.server.schemas.filters`

Schemas that define Prefect REST API filtering operations.

Each filter schema includes logic for transforming itself into a SQL `where` clause.

## Classes

### `Operator` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L41](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L41)</sup>

Operators for combining filter criteria.

**Methods:**

#### `auto` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/utilities/collections.py#L70](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/utilities/collections.py#L70)</sup>

```python theme={null}
auto() -> str
```

Exposes `enum.auto()` to avoid requiring a second import to use `AutoEnum`

### `PrefectFilterBaseModel` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L48](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L48)</sup>

Base model for Prefect filters

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

#### `model_validate_list` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/\_internal/schemas/bases.py#L56](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/_internal/schemas/bases.py#L56)</sup>

```python theme={null}
model_validate_list(cls, obj: Any) -> list[Self]
```

#### `reset_fields` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/\_internal/schemas/bases.py#L85](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/_internal/schemas/bases.py#L85)</sup>

```python theme={null}
reset_fields(self: Self) -> Self
```

Reset the fields of the model that are in the `_reset_fields` set.

**Returns:**

* A new instance of the model with the reset fields.

### `PrefectOperatorFilterBaseModel` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L70](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L70)</sup>

Base model for Prefect filters that combines criteria with a user-provided operator

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `FlowFilterId` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L88](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L88)</sup>

Filter by `Flow.id`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `FlowFilterDeployment` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L109](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L109)</sup>

Filter by flows by deployment

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

### `FlowFilterName` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L139](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L139)</sup>

Filter by `Flow.name`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `FlowFilterTags` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L169](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L169)</sup>

Filter by `Flow.tags`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

### `FlowFilter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L195](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L195)</sup>

Filter for flows. Only flows matching all criteria will be returned.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

### `FlowRunFilterId` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L228](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L228)</sup>

Filter by `FlowRun.id`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `FlowRunFilterName` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L249](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L249)</sup>

Filter by `FlowRun.name`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `FlowRunFilterTags` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L279](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L279)</sup>

Filter by `FlowRun.tags`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

### `FlowRunFilterDeploymentId` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L319](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L319)</sup>

Filter by `FlowRun.deployment_id`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

### `FlowRunFilterWorkQueueName` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L345](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L345)</sup>

Filter by `FlowRun.work_queue_name`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

### `FlowRunFilterStateType` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L373](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L373)</sup>

Filter by `FlowRun.state_type`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `FlowRunFilterStateName` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L394](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L394)</sup>

Filter by `FlowRun.state_name`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `FlowRunFilterState` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L415](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L415)</sup>

Filter by `FlowRun.state_type` and `FlowRun.state_name`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

### `FlowRunFilterFlowVersion` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L440](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L440)</sup>

Filter by `FlowRun.flow_version`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `FlowRunFilterStartTime` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L456](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L456)</sup>

Filter by `FlowRun.start_time`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `FlowRunFilterEndTime` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L494](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L494)</sup>

Filter by `FlowRun.end_time`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `FlowRunFilterExpectedStartTime` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L526](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L526)</sup>

Filter by `FlowRun.expected_start_time`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `FlowRunFilterNextScheduledStartTime` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L549](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L549)</sup>

Filter by `FlowRun.next_scheduled_start_time`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `FlowRunFilterParentFlowRunId` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L578](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L578)</sup>

Filter for subflows of a given flow run

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

### `FlowRunFilterParentTaskRunId` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L605](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L605)</sup>

Filter by `FlowRun.parent_task_run_id`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

### `FlowRunFilterIdempotencyKey` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L631](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L631)</sup>

Filter by FlowRun.idempotency\_key.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `FlowRunFilterCreatedBy` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L652](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L652)</sup>

Filter by `FlowRun.created_by`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

### `FlowRunFilter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L691](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L691)</sup>

Filter flow runs. Only flow runs matching all criteria will be returned

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

#### `only_filters_on_id` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L741](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L741)</sup>

```python theme={null}
only_filters_on_id(self) -> bool
```

### `TaskRunFilterFlowRunId` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L800](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L800)</sup>

Filter by `TaskRun.flow_run_id`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

### `TaskRunFilterId` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L825](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L825)</sup>

Filter by `TaskRun.id`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `TaskRunFilterName` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L841](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L841)</sup>

Filter by `TaskRun.name`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `TaskRunFilterTags` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L871](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L871)</sup>

Filter by `TaskRun.tags`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

### `TaskRunFilterStateType` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L899](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L899)</sup>

Filter by `TaskRun.state_type`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `TaskRunFilterStateName` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L915](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L915)</sup>

Filter by `TaskRun.state_name`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `TaskRunFilterState` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L931](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L931)</sup>

Filter by `TaskRun.type` and `TaskRun.name`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

### `TaskRunFilterSubFlowRuns` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L956](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L956)</sup>

Filter by `TaskRun.subflow_run`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `TaskRunFilterStartTime` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L978](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L978)</sup>

Filter by `TaskRun.start_time`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `TaskRunFilterEndTime` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1010](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1010)</sup>

Filter by `TaskRun.end_time`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `TaskRunFilterExpectedStartTime` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1042](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1042)</sup>

Filter by `TaskRun.expected_start_time`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `TaskRunFilter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1065](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1065)</sup>

Filter task runs. Only task runs matching all criteria will be returned

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

### `DeploymentFilterId` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1123](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1123)</sup>

Filter by `Deployment.id`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `DeploymentFilterName` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1144](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1144)</sup>

Filter by `Deployment.name`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `DeploymentOrFlowNameFilter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1174](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1174)</sup>

Filter by `Deployment.name` or `Flow.name` with a single input string for ilike filtering.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `DeploymentFilterPaused` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1199](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1199)</sup>

Filter by `Deployment.paused`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `DeploymentFilterWorkQueueName` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1216](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1216)</sup>

Filter by `Deployment.work_queue_name`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `DeploymentFilterConcurrencyLimit` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1234](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1234)</sup>

DEPRECATED: Prefer `Deployment.concurrency_limit_id` over `Deployment.concurrency_limit`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `DeploymentFilterTags` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1259](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1259)</sup>

Filter by `Deployment.tags`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

### `DeploymentFilter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1297](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1297)</sup>

Filter for deployments. Only deployments matching all criteria will be returned.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

### `DeploymentScheduleFilterActive` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1344](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1344)</sup>

Filter by `DeploymentSchedule.active`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `DeploymentScheduleFilter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1361](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1361)</sup>

Filter for deployments. Only deployments matching all criteria will be returned.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

### `LogFilterName` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1379](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1379)</sup>

Filter by `Log.name`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `LogFilterLevel` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1397](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1397)</sup>

Filter by `Log.level`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `LogFilterTimestamp` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1423](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1423)</sup>

Filter by `Log.timestamp`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `LogFilterFlowRunId` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1446](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1446)</sup>

Filter by `Log.flow_run_id`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `LogFilterTaskRunId` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1462](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1462)</sup>

Filter by `Log.task_run_id`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `LogFilterTextSearch` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1489](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1489)</sup>

Filter by text search across log content.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

#### `includes` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1503](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1503)</sup>

```python theme={null}
includes(self, log: 'Log') -> bool
```

Check if this text filter includes the given log.

### `LogFilter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1598](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1598)</sup>

Filter logs. Only logs matching all criteria will be returned

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

### `FilterSet` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1636](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1636)</sup>

A collection of filters for common objects

**Methods:**

#### `model_validate_list` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/\_internal/schemas/bases.py#L56](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/_internal/schemas/bases.py#L56)</sup>

```python theme={null}
model_validate_list(cls, obj: Any) -> list[Self]
```

#### `reset_fields` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/\_internal/schemas/bases.py#L85](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/_internal/schemas/bases.py#L85)</sup>

```python theme={null}
reset_fields(self: Self) -> Self
```

Reset the fields of the model that are in the `_reset_fields` set.

**Returns:**

* A new instance of the model with the reset fields.

### `BlockTypeFilterName` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1654](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1654)</sup>

Filter by `BlockType.name`

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `BlockTypeFilterSlug` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1676](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1676)</sup>

Filter by `BlockType.slug`

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `BlockTypeFilter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1693](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1693)</sup>

Filter BlockTypes

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `BlockSchemaFilterBlockTypeId` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1717](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1717)</sup>

Filter by `BlockSchema.block_type_id`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `BlockSchemaFilterId` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1733](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1733)</sup>

Filter by BlockSchema.id

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `BlockSchemaFilterCapabilities` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1749](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1749)</sup>

Filter by `BlockSchema.capabilities`

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `BlockSchemaFilterVersion` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1770](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1770)</sup>

Filter by `BlockSchema.capabilities`

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `BlockSchemaFilter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1788](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1788)</sup>

Filter BlockSchemas

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

### `BlockDocumentFilterIsAnonymous` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1821](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1821)</sup>

Filter by `BlockDocument.is_anonymous`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `BlockDocumentFilterBlockTypeId` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1840](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1840)</sup>

Filter by `BlockDocument.block_type_id`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `BlockDocumentFilterId` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1856](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1856)</sup>

Filter by `BlockDocument.id`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `BlockDocumentFilterName` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1872](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1872)</sup>

Filter by `BlockDocument.name`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `BlockDocumentFilter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1898](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1898)</sup>

Filter BlockDocuments. Only BlockDocuments matching all criteria will be returned

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

### `WorkQueueFilterId` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1934](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1934)</sup>

Filter by `WorkQueue.id`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `WorkQueueFilterName` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1951](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1951)</sup>

Filter by `WorkQueue.name`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `WorkQueueFilter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1985](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L1985)</sup>

Filter work queues. Only work queues matching all criteria will be
returned

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

### `WorkPoolFilterId` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2010](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2010)</sup>

Filter by `WorkPool.id`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `WorkPoolFilterName` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2026](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2026)</sup>

Filter by `WorkPool.name`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `WorkPoolFilterType` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2042](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2042)</sup>

Filter by `WorkPool.type`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `WorkPoolFilter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2058](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2058)</sup>

Filter work pools. Only work pools matching all criteria will be returned

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

### `WorkerFilterWorkPoolId` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2086](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2086)</sup>

Filter by `Worker.worker_config_id`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `WorkerFilterStatus` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2102](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2102)</sup>

Filter by `Worker.status`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `WorkerFilterLastHeartbeatTime` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2123](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2123)</sup>

Filter by `Worker.last_heartbeat_time`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `WorkerFilter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2150](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2150)</sup>

Filter by `Worker.last_heartbeat_time`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

### `ArtifactFilterId` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2180](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2180)</sup>

Filter by `Artifact.id`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `ArtifactFilterKey` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2196](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2196)</sup>

Filter by `Artifact.key`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `ArtifactFilterFlowRunId` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2237](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2237)</sup>

Filter by `Artifact.flow_run_id`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `ArtifactFilterTaskRunId` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2253](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2253)</sup>

Filter by `Artifact.task_run_id`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `ArtifactFilterType` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2269](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2269)</sup>

Filter by `Artifact.type`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `ArtifactFilter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2290](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2290)</sup>

Filter artifacts. Only artifacts matching all criteria will be returned

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

### `ArtifactCollectionFilterLatestId` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2328](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2328)</sup>

Filter by `ArtifactCollection.latest_id`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `ArtifactCollectionFilterKey` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2344](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2344)</sup>

Filter by `ArtifactCollection.key`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `ArtifactCollectionFilterFlowRunId` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2386](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2386)</sup>

Filter by `ArtifactCollection.flow_run_id`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `ArtifactCollectionFilterTaskRunId` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2402](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2402)</sup>

Filter by `ArtifactCollection.task_run_id`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `ArtifactCollectionFilterType` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2418](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2418)</sup>

Filter by `ArtifactCollection.type`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `ArtifactCollectionFilter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2439](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2439)</sup>

Filter artifact collections. Only artifact collections matching all criteria will be returned

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

### `VariableFilterId` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2477](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2477)</sup>

Filter by `Variable.id`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `VariableFilterName` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2493](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2493)</sup>

Filter by `Variable.name`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L53)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

Generate SQL filter from provided filter parameters. If no filters parameters are available, return a TRUE filter.

### `VariableFilterTags` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2519](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2519)</sup>

Filter by `Variable.tags`.

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```

### `VariableFilter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2547](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L2547)</sup>

Filter variables. Only variables matching all criteria will be returned

**Methods:**

#### `as_sql_filter` <sup>[https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78](https://github.com/PrefectHQ/prefect/blob/main/src/prefect/server/schemas/filters.py#L78)</sup>

```python theme={null}
as_sql_filter(self) -> sa.ColumnElement[bool]
```