# Filter conditions
A "filter condition" is a `(column, operator, value)` triple. The grid
stores filter conditions in `state.columnFilters`.
> Live demo: Excel-style filters - https://svgrid.com/demos/03-excel-filters/
## Shape
The examples on this page run against these rows:
```svelte
```
```ts
type ColumnFilter = {
id: string // column id
value: unknown // operator-specific value
fn?: keyof typeof filterFns // optional explicit filter function
}
type ColumnFiltersState = ColumnFilter[]
```
Through the wrapper, the menu uses a richer per-column representation
(operator + value) - the wrapper converts between the two when state
crosses the boundary.
## Multiple conditions on one column (AND / OR)
A single column can hold **two** conditions joined by `AND` or `OR` - a
numeric band, an either/or text match, an outlier filter. In the UI, open a
column's funnel menu and click **"+ Add condition"**, pick a second operator +
value, and toggle **AND / OR**. From the API, pass the second condition to
`setFilter`:
```ts
// salary band: > 80,000 AND < 150,000
api.setFilter('salary', {
operator: 'greaterThan', value: '80000',
operator2: 'lessThan', value2: '150000',
join: 'AND',
})
// age outliers: < 25 OR > 60
api.setFilter('age', {
operator: 'lessThan', value: '25',
operator2: 'greaterThan', value2: '60',
join: 'OR',
})
```
> Live demo: Multi-condition filter (AND / OR) - https://svgrid.com/demos/178-multi-condition-filter/
Conditions on **different columns** always AND together. For a set / value
checklist ("status in {active, pending}") use the [set filter](https://svgrid.com/docs/help/filtering/set-filter/);
for OR **across** columns, use the [advanced filter builder](https://svgrid.com/demos/98-advanced-filter-builder/).
## Conditions via the imperative API
Apply or update conditions through the `SvGridApi` once it's available:
```svelte
(api = next)}
/>
```
## Clearing
```ts
api.clearFilter('department') // single column
```
A `clearAllFilters()` helper is on the
[Missing features](https://svgrid.com/docs/help/missing-features/) list. Until then, iterate
the columns you know are filtered and call `clearFilter` per id - the
list of currently-filtered columns is reported by `onFiltersChange`.
```ts
columnFilters = []
```
## Try it
Open a column's filter menu and the operator list is typed to the column: the
text columns offer contains / equals / starts with, and Age and Salary offer the
numeric comparisons and between. Nothing configures that - it follows the value.
```svelte
```
## See also
- [Applying filters](https://svgrid.com/docs/help/filtering/applying-filters/)
- [Filter API](https://svgrid.com/docs/help/filtering/filter-api/)
---
SvGrid is the Svelte 5 data grid (`npm install @svgrid/grid`, MIT). This page: https://svgrid.com/docs/help/filtering/filter-conditions/ . All docs: https://svgrid.com/llms.txt