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

# Where Filters

> Reference for the Python DSL used to build where filters.

Use the `K` (Key) builder to construct where filters in Python. Filters are passed to `get`, `query`, `search`, `delete`, and similar methods via the `where` parameter.

## Field references

| Type | DSL | Example |
| - | - | - |
| Metadata field | `K("field_name")` | `K("category")`, `K("year")` |
| Document | `K.DOCUMENT` | `K.DOCUMENT.contains("text")` |
| ID | `K.ID` | `K.ID.is_in(["id1", "id2"])` |

## Comparison operators

| Predicate | Operator | Example |
| - | - | - |
| Equal | `==` | `K("status") == "active"` |
| Not equal | `!=` | `K("count") != 0` |
| Greater than | `>` | `K("price") > 100` |
| Greater than or equal | `>=` | `K("year") >= 2020` |
| Less than | `<` | `K("stock") < 10` |
| Less than or equal | `<=` | `K("discount") <= 0.25` |

## Set operators

| Predicate | DSL | Example |
| - | - | - |
| In list | `K("field").is_in([...])` | `K("category").is_in(["tech", "ai"])` |
| Not in list | `K("field").not_in([...])` | `K("status").not_in(["draft", "deleted"])` |

## Array operators

| Predicate | DSL | Example |
| - | - | - |
| Contains | `K("field").contains(value)` | `K("tags").contains("action")` |
| Not contains | `K("field").not_contains(value)` | `K("tags").not_contains("draft")` |

## Document operators

| Predicate | DSL | Example |
| - | - | - |
| Contains | `K.DOCUMENT.contains(value)` | `K.DOCUMENT.contains("machine learning")` |
| Not contains | `K.DOCUMENT.not_contains(value)` | `K.DOCUMENT.not_contains("draft")` |
| Regex match | `K.DOCUMENT.regex(pattern)` | `K.DOCUMENT.regex("^quantum\\s+\\w+")` |
| Regex not match | `K.DOCUMENT.not_regex(pattern)` | `K.DOCUMENT.not_regex("^draft")` |