# Filtering
Package: @mantine/data-grid
Import: import { Filtering } from '@mantine/data-grid';
Description: DataGrid column and global filtering

## Overview

DataGrid manages the filter state but does not render filter inputs. Build the filter UI
with `@mantine/core` components and connect it to the store:

```ts
interface DataGridStore<TData extends RowData = any> {
  /** Active column filters, each with an id and value. */
  columnFilters: ColumnFiltersState;

  /** Set one filter. Pass undefined, null or '' to remove it. */
  setColumnFilter: (columnId: string, value: unknown) => void;
  getColumnFilterValue: (columnId: string) => unknown;

  /** Replace all column filters, or update them from the previous state. */
  setColumnFilters: (updater: Updater<ColumnFiltersState>) => void;
  resetColumnFilters: () => void;

  /** Distinct column values. Requires withFaceting. */
  getFacetedUniqueValues: (columnId: string) => DataGridFacetedValue[];

  /** Numeric column range. Requires withFaceting. */
  getFacetedMinMaxValues: (columnId: string) => [number, number] | undefined;

  /** Global search value and setter. */
  globalFilter: any;
  setGlobalFilter: (value: any) => void;
}
```

Column filtering is enabled automatically when any column has `enableColumnFilter: true` or
`filterFn`. Set `withFiltering: true` to enable it for all columns.

Rows are filtered with `filterFn` of the column. It is the name of a built-in TanStack Table
filter function, for example `includesString` or `inNumberRange`, or your own function.

## Global search

Pass `withGlobalFilter` to `useDataGrid` to enable search across all columns.
`DataGrid.GlobalFilter` renders the search input, `DataGrid.Toolbar` without children includes it.
To use your own input, connect it with `store.getGlobalFilter()` and `store.setGlobalFilter()`:

```tsx
// Demo.tsx
import { DataGrid, useDataGrid } from '@mantine/data-grid';
import { TextInput } from '@mantine/core';
import { employees } from './data';

function Demo() {
  const store = useDataGrid({
    data: employees,
    columns: [
      { accessorKey: 'firstName', header: 'First Name' },
      { accessorKey: 'lastName', header: 'Last Name' },
      { accessorKey: 'email', header: 'Email', size: 220 },
      { accessorKey: 'department', header: 'Department' },
      { accessorKey: 'salary', header: 'Salary' },
    ],
    withGlobalFilter: true,
  });

  return (
    <>
      <TextInput
        placeholder="Search..."
        value={store.getGlobalFilter() ?? ''}
        onChange={(event) => store.setGlobalFilter(event.currentTarget.value)}
        mb="md"
      />
      <DataGrid store={store} />
    </>
  );
}

// data.ts
export const employees = [
  { id: '1', firstName: 'Alice', lastName: 'Johnson', email: 'alice.johnson@example.com', department: 'Engineering', salary: 95000, startDate: '2021-03-15', status: 'active' },
  { id: '2', firstName: 'Bob', lastName: 'Smith', email: 'bob.smith@example.com', department: 'Marketing', salary: 72000, startDate: '2020-07-01', status: 'active' },
  { id: '3', firstName: 'Carol', lastName: 'Williams', email: 'carol.williams@example.com', department: 'Sales', salary: 68000, startDate: '2022-01-10', status: 'active' },
  { id: '4', firstName: 'David', lastName: 'Brown', email: 'david.brown@example.com', department: 'HR', salary: 65000, startDate: '2019-11-20', status: 'inactive' },
  { id: '5', firstName: 'Eva', lastName: 'Davis', email: 'eva.davis@example.com', department: 'Finance', salary: 88000, startDate: '2021-06-05', status: 'active' },
  { id: '6', firstName: 'Frank', lastName: 'Miller', email: 'frank.miller@example.com', department: 'Engineering', salary: 102000, startDate: '2018-09-12', status: 'active' },
  { id: '7', firstName: 'Grace', lastName: 'Wilson', email: 'grace.wilson@example.com', department: 'Marketing', salary: 76000, startDate: '2022-04-18', status: 'active' },
  { id: '8', firstName: 'Henry', lastName: 'Taylor', email: 'henry.taylor@example.com', department: 'Sales', salary: 71000, startDate: '2020-02-28', status: 'inactive' },
  { id: '9', firstName: 'Irene', lastName: 'Anderson', email: 'irene.anderson@example.com', department: 'Engineering', salary: 97000, startDate: '2021-08-30', status: 'active' },
  { id: '10', firstName: 'James', lastName: 'Thomas', email: 'james.thomas@example.com', department: 'Finance', salary: 91000, startDate: '2019-05-14', status: 'active' },
  { id: '11', firstName: 'Karen', lastName: 'Jackson', email: 'karen.jackson@example.com', department: 'HR', salary: 63000, startDate: '2023-01-09', status: 'active' },
  { id: '12', firstName: 'Leo', lastName: 'White', email: 'leo.white@example.com', department: 'Engineering', salary: 110000, startDate: '2017-12-01', status: 'active' },
  { id: '13', firstName: 'Mia', lastName: 'Harris', email: 'mia.harris@example.com', department: 'Sales', salary: 74000, startDate: '2022-07-22', status: 'active' },
  { id: '14', firstName: 'Nathan', lastName: 'Martin', email: 'nathan.martin@example.com', department: 'Marketing', salary: 69000, startDate: '2021-10-03', status: 'inactive' },
  { id: '15', firstName: 'Olivia', lastName: 'Garcia', email: 'olivia.garcia@example.com', department: 'Finance', salary: 85000, startDate: '2020-04-11', status: 'active' },
  { id: '16', firstName: 'Patrick', lastName: 'Martinez', email: 'patrick.martinez@example.com', department: 'Engineering', salary: 99000, startDate: '2019-08-25', status: 'active' },
  { id: '17', firstName: 'Quinn', lastName: 'Robinson', email: 'quinn.robinson@example.com', department: 'HR', salary: 67000, startDate: '2022-11-14', status: 'active' },
  { id: '18', firstName: 'Rachel', lastName: 'Clark', email: 'rachel.clark@example.com', department: 'Sales', salary: 73000, startDate: '2021-02-07', status: 'active' },
];
```


## Filters popover

A **Filters** button in the toolbar opens a popover with one control per filterable column.
Controls read values with `getColumnFilterValue` and write them with `setColumnFilter`:

```tsx
// Demo.tsx
import { Badge, Button, Group, Popover, Select, Stack, TextInput } from '@mantine/core';
import { DataGrid, useDataGrid } from '@mantine/data-grid';
import { employees } from './data';

function Demo() {
  const store = useDataGrid({
    data: employees,
    columns: [
      { accessorKey: 'firstName', header: 'First Name', enableColumnFilter: true },
      { accessorKey: 'lastName', header: 'Last Name' },
      { accessorKey: 'email', header: 'Email', size: 220 },
      { accessorKey: 'department', header: 'Department', filterFn: 'equals' },
      { accessorKey: 'status', header: 'Status', filterFn: 'equals' },
    ],
    withFaceting: true,
  });

  const activeCount = store.getColumnFilters().length;

  return (
    <DataGrid store={store}>
      <DataGrid.Toolbar>
        <Popover position="bottom-start" shadow="md">
          <Popover.Target>
            <Button
              size={store.getControlSize()}
              variant="default"
              rightSection={activeCount > 0 ? <Badge size="xs" circle>{activeCount}</Badge> : null}
            >
              Filters
            </Button>
          </Popover.Target>
          <Popover.Dropdown>
            <Stack gap="sm" w={240}>
              <TextInput
                label="First name"
                placeholder="Contains"
                value={(store.getColumnFilterValue('firstName') as string) ?? ''}
                onChange={(event) => store.setColumnFilter('firstName', event.currentTarget.value)}
              />
              <Select
                label="Department"
                placeholder="Any"
                clearable
                data={store.getFacetedUniqueValues('department')}
                value={(store.getColumnFilterValue('department') as string) ?? null}
                onChange={(value) => store.setColumnFilter('department', value)}
              />
              <Select
                label="Status"
                placeholder="Any"
                clearable
                data={store.getFacetedUniqueValues('status')}
                value={(store.getColumnFilterValue('status') as string) ?? null}
                onChange={(value) => store.setColumnFilter('status', value)}
              />
              <Group justify="flex-end">
                <Button
                  size="xs"
                  variant="default"
                  disabled={activeCount === 0}
                  onClick={() => store.resetColumnFilters()}
                >
                  Clear all
                </Button>
              </Group>
            </Stack>
          </Popover.Dropdown>
        </Popover>
      </DataGrid.Toolbar>
    </DataGrid>
  );
}

// data.ts
export const employees = [
  { id: '1', firstName: 'Alice', lastName: 'Johnson', email: 'alice.johnson@example.com', department: 'Engineering', salary: 95000, startDate: '2021-03-15', status: 'active' },
  { id: '2', firstName: 'Bob', lastName: 'Smith', email: 'bob.smith@example.com', department: 'Marketing', salary: 72000, startDate: '2020-07-01', status: 'active' },
  { id: '3', firstName: 'Carol', lastName: 'Williams', email: 'carol.williams@example.com', department: 'Sales', salary: 68000, startDate: '2022-01-10', status: 'active' },
  { id: '4', firstName: 'David', lastName: 'Brown', email: 'david.brown@example.com', department: 'HR', salary: 65000, startDate: '2019-11-20', status: 'inactive' },
  { id: '5', firstName: 'Eva', lastName: 'Davis', email: 'eva.davis@example.com', department: 'Finance', salary: 88000, startDate: '2021-06-05', status: 'active' },
  { id: '6', firstName: 'Frank', lastName: 'Miller', email: 'frank.miller@example.com', department: 'Engineering', salary: 102000, startDate: '2018-09-12', status: 'active' },
  { id: '7', firstName: 'Grace', lastName: 'Wilson', email: 'grace.wilson@example.com', department: 'Marketing', salary: 76000, startDate: '2022-04-18', status: 'active' },
  { id: '8', firstName: 'Henry', lastName: 'Taylor', email: 'henry.taylor@example.com', department: 'Sales', salary: 71000, startDate: '2020-02-28', status: 'inactive' },
  { id: '9', firstName: 'Irene', lastName: 'Anderson', email: 'irene.anderson@example.com', department: 'Engineering', salary: 97000, startDate: '2021-08-30', status: 'active' },
  { id: '10', firstName: 'James', lastName: 'Thomas', email: 'james.thomas@example.com', department: 'Finance', salary: 91000, startDate: '2019-05-14', status: 'active' },
  { id: '11', firstName: 'Karen', lastName: 'Jackson', email: 'karen.jackson@example.com', department: 'HR', salary: 63000, startDate: '2023-01-09', status: 'active' },
  { id: '12', firstName: 'Leo', lastName: 'White', email: 'leo.white@example.com', department: 'Engineering', salary: 110000, startDate: '2017-12-01', status: 'active' },
  { id: '13', firstName: 'Mia', lastName: 'Harris', email: 'mia.harris@example.com', department: 'Sales', salary: 74000, startDate: '2022-07-22', status: 'active' },
  { id: '14', firstName: 'Nathan', lastName: 'Martin', email: 'nathan.martin@example.com', department: 'Marketing', salary: 69000, startDate: '2021-10-03', status: 'inactive' },
  { id: '15', firstName: 'Olivia', lastName: 'Garcia', email: 'olivia.garcia@example.com', department: 'Finance', salary: 85000, startDate: '2020-04-11', status: 'active' },
  { id: '16', firstName: 'Patrick', lastName: 'Martinez', email: 'patrick.martinez@example.com', department: 'Engineering', salary: 99000, startDate: '2019-08-25', status: 'active' },
  { id: '17', firstName: 'Quinn', lastName: 'Robinson', email: 'quinn.robinson@example.com', department: 'HR', salary: 67000, startDate: '2022-11-14', status: 'active' },
  { id: '18', firstName: 'Rachel', lastName: 'Clark', email: 'rachel.clark@example.com', department: 'Sales', salary: 73000, startDate: '2021-02-07', status: 'active' },
];
```


## Faceted filters

Pass `withFaceting: true` to `useDataGrid` to get unique values and numeric ranges of columns
from the data:

* `getFacetedUniqueValues(columnId)` returns `{ value, label }[]` that can be passed as `data` to `Select` or `MultiSelect`
* `getFacetedMinMaxValues(columnId)` returns `[min, max]` for `RangeSlider` or number inputs

Use the matching `filterFn`: `equals` for a single value, `arrIncludesSome` for multiple values
and `inNumberRange` for a range:

```tsx
// Demo.tsx
import { Button, Group, RangeSlider, Select, Text } from '@mantine/core';
import { DataGrid, useDataGrid } from '@mantine/data-grid';
import { employees } from './data';

function Demo() {
  const store = useDataGrid({
    data: employees,
    columns: [
      { accessorKey: 'firstName', header: 'First Name' },
      { accessorKey: 'lastName', header: 'Last Name' },
      { accessorKey: 'department', header: 'Department', filterFn: 'equals' },
      { accessorKey: 'status', header: 'Status', filterFn: 'equals' },
      {
        accessorKey: 'salary',
        header: 'Salary',
        filterFn: 'inNumberRange',
        meta: { align: 'end' },
      },
    ],
    withFaceting: true,
  });

  const [min, max] = store.getFacetedMinMaxValues('salary') ?? [0, 0];
  const range = (store.getColumnFilterValue('salary') as [number, number] | undefined) ?? [min, max];

  return (
    <DataGrid store={store}>
      <DataGrid.Toolbar>
        <Select
          size={store.getControlSize()}
          placeholder="Department"
          clearable
          data={store.getFacetedUniqueValues('department')}
          value={(store.getColumnFilterValue('department') as string) ?? null}
          onChange={(value) => store.setColumnFilter('department', value)}
        />
        <Select
          size={store.getControlSize()}
          placeholder="Status"
          clearable
          data={store.getFacetedUniqueValues('status')}
          value={(store.getColumnFilterValue('status') as string) ?? null}
          onChange={(value) => store.setColumnFilter('status', value)}
        />
        <Group gap="xs" wrap="nowrap" style={{ flex: 1, minWidth: 220 }}>
          <Text size="xs" c="dimmed">
            Salary
          </Text>
          <RangeSlider
            size="sm"
            style={{ flex: 1 }}
            min={min}
            max={max}
            step={1000}
            minRange={1000}
            value={range}
            label={(value) => `$${value.toLocaleString()}`}
            onChange={(value) => store.setColumnFilter('salary', value)}
          />
        </Group>
        <Button
          size={store.getControlSize()}
          variant="default"
          disabled={store.getColumnFilters().length === 0}
          onClick={() => store.resetColumnFilters()}
        >
          Reset
        </Button>
      </DataGrid.Toolbar>
    </DataGrid>
  );
}

// data.ts
export const employees = [
  { id: '1', firstName: 'Alice', lastName: 'Johnson', email: 'alice.johnson@example.com', department: 'Engineering', salary: 95000, startDate: '2021-03-15', status: 'active' },
  { id: '2', firstName: 'Bob', lastName: 'Smith', email: 'bob.smith@example.com', department: 'Marketing', salary: 72000, startDate: '2020-07-01', status: 'active' },
  { id: '3', firstName: 'Carol', lastName: 'Williams', email: 'carol.williams@example.com', department: 'Sales', salary: 68000, startDate: '2022-01-10', status: 'active' },
  { id: '4', firstName: 'David', lastName: 'Brown', email: 'david.brown@example.com', department: 'HR', salary: 65000, startDate: '2019-11-20', status: 'inactive' },
  { id: '5', firstName: 'Eva', lastName: 'Davis', email: 'eva.davis@example.com', department: 'Finance', salary: 88000, startDate: '2021-06-05', status: 'active' },
  { id: '6', firstName: 'Frank', lastName: 'Miller', email: 'frank.miller@example.com', department: 'Engineering', salary: 102000, startDate: '2018-09-12', status: 'active' },
  { id: '7', firstName: 'Grace', lastName: 'Wilson', email: 'grace.wilson@example.com', department: 'Marketing', salary: 76000, startDate: '2022-04-18', status: 'active' },
  { id: '8', firstName: 'Henry', lastName: 'Taylor', email: 'henry.taylor@example.com', department: 'Sales', salary: 71000, startDate: '2020-02-28', status: 'inactive' },
  { id: '9', firstName: 'Irene', lastName: 'Anderson', email: 'irene.anderson@example.com', department: 'Engineering', salary: 97000, startDate: '2021-08-30', status: 'active' },
  { id: '10', firstName: 'James', lastName: 'Thomas', email: 'james.thomas@example.com', department: 'Finance', salary: 91000, startDate: '2019-05-14', status: 'active' },
  { id: '11', firstName: 'Karen', lastName: 'Jackson', email: 'karen.jackson@example.com', department: 'HR', salary: 63000, startDate: '2023-01-09', status: 'active' },
  { id: '12', firstName: 'Leo', lastName: 'White', email: 'leo.white@example.com', department: 'Engineering', salary: 110000, startDate: '2017-12-01', status: 'active' },
  { id: '13', firstName: 'Mia', lastName: 'Harris', email: 'mia.harris@example.com', department: 'Sales', salary: 74000, startDate: '2022-07-22', status: 'active' },
  { id: '14', firstName: 'Nathan', lastName: 'Martin', email: 'nathan.martin@example.com', department: 'Marketing', salary: 69000, startDate: '2021-10-03', status: 'inactive' },
  { id: '15', firstName: 'Olivia', lastName: 'Garcia', email: 'olivia.garcia@example.com', department: 'Finance', salary: 85000, startDate: '2020-04-11', status: 'active' },
  { id: '16', firstName: 'Patrick', lastName: 'Martinez', email: 'patrick.martinez@example.com', department: 'Engineering', salary: 99000, startDate: '2019-08-25', status: 'active' },
  { id: '17', firstName: 'Quinn', lastName: 'Robinson', email: 'quinn.robinson@example.com', department: 'HR', salary: 67000, startDate: '2022-11-14', status: 'active' },
  { id: '18', firstName: 'Rachel', lastName: 'Clark', email: 'rachel.clark@example.com', department: 'Sales', salary: 73000, startDate: '2021-02-07', status: 'active' },
];
```


## Operator filters

`stringOperators`, `numberOperators` and `booleanOperators` are sets of filter operators:
contains, equals, starts with, is empty, greater than, etc. Set
`filterFn: createOperatorFilterFn(stringOperators)` on the column and use an
`{ operator, value }` object as its filter value. To define your own operators,
pass an array of `FilterOperator` objects to `createOperatorFilterFn`:

```tsx
// Demo.tsx
import { useState } from 'react';
import { Group, NumberInput, Select, TextInput } from '@mantine/core';
import {
  createOperatorFilterFn,
  DataGrid,
  numberOperators,
  OperatorFilterValue,
  stringOperators,
  useDataGrid,
} from '@mantine/data-grid';
import { employees } from './data';

const stringOperatorOptions = stringOperators.map(({ value, label }) => ({ value, label }));
const numberOperatorOptions = numberOperators.map(({ value, label }) => ({ value, label }));

function Demo() {
  const [nameOperator, setNameOperator] = useState('contains');
  const [salaryOperator, setSalaryOperator] = useState('gte');

  const store = useDataGrid({
    data: employees,
    columns: [
      {
        accessorKey: 'firstName',
        header: 'First Name',
        filterFn: createOperatorFilterFn(stringOperators),
      },
      { accessorKey: 'lastName', header: 'Last Name' },
      { accessorKey: 'department', header: 'Department' },
      {
        accessorKey: 'salary',
        header: 'Salary',
        filterFn: createOperatorFilterFn(numberOperators),
        meta: { align: 'end' },
      },
    ],
  });

  const nameValue = (store.getColumnFilterValue('firstName') as OperatorFilterValue | undefined)
    ?.value;
  const salaryValue = (store.getColumnFilterValue('salary') as OperatorFilterValue | undefined)
    ?.value;
  const nameValueless = stringOperators.find((op) => op.value === nameOperator)?.valueless;

  const setNameFilter = (operator: string, value: unknown) => {
    const valueless = stringOperators.find((op) => op.value === operator)?.valueless;
    store.setColumnFilter('firstName', valueless || value ? { operator, value } : undefined);
  };

  const setSalaryFilter = (operator: string, value: unknown) => {
    store.setColumnFilter('salary', value === '' ? undefined : { operator, value });
  };

  return (
    <DataGrid store={store}>
      <DataGrid.Toolbar>
        <Group gap={4} wrap="nowrap">
          <Select
            size={store.getControlSize()}
            w={130}
            allowDeselect={false}
            data={stringOperatorOptions}
            value={nameOperator}
            onChange={(operator) => {
              if (operator) {
                setNameOperator(operator);
                setNameFilter(operator, nameValue);
              }
            }}
          />
          <TextInput
            size={store.getControlSize()}
            placeholder="First name"
            disabled={nameValueless}
            value={typeof nameValue === 'string' ? nameValue : ''}
            onChange={(event) => setNameFilter(nameOperator, event.currentTarget.value)}
          />
        </Group>
        <Group gap={4} wrap="nowrap">
          <Select
            size={store.getControlSize()}
            w={72}
            allowDeselect={false}
            data={numberOperatorOptions}
            value={salaryOperator}
            onChange={(operator) => {
              if (operator) {
                setSalaryOperator(operator);
                setSalaryFilter(operator, salaryValue ?? '');
              }
            }}
          />
          <NumberInput
            size={store.getControlSize()}
            placeholder="Salary"
            prefix="$"
            thousandSeparator
            value={typeof salaryValue === 'number' ? salaryValue : ''}
            onChange={(value) => setSalaryFilter(salaryOperator, value)}
          />
        </Group>
      </DataGrid.Toolbar>
    </DataGrid>
  );
}

// data.ts
export const employees = [
  { id: '1', firstName: 'Alice', lastName: 'Johnson', email: 'alice.johnson@example.com', department: 'Engineering', salary: 95000, startDate: '2021-03-15', status: 'active' },
  { id: '2', firstName: 'Bob', lastName: 'Smith', email: 'bob.smith@example.com', department: 'Marketing', salary: 72000, startDate: '2020-07-01', status: 'active' },
  { id: '3', firstName: 'Carol', lastName: 'Williams', email: 'carol.williams@example.com', department: 'Sales', salary: 68000, startDate: '2022-01-10', status: 'active' },
  { id: '4', firstName: 'David', lastName: 'Brown', email: 'david.brown@example.com', department: 'HR', salary: 65000, startDate: '2019-11-20', status: 'inactive' },
  { id: '5', firstName: 'Eva', lastName: 'Davis', email: 'eva.davis@example.com', department: 'Finance', salary: 88000, startDate: '2021-06-05', status: 'active' },
  { id: '6', firstName: 'Frank', lastName: 'Miller', email: 'frank.miller@example.com', department: 'Engineering', salary: 102000, startDate: '2018-09-12', status: 'active' },
  { id: '7', firstName: 'Grace', lastName: 'Wilson', email: 'grace.wilson@example.com', department: 'Marketing', salary: 76000, startDate: '2022-04-18', status: 'active' },
  { id: '8', firstName: 'Henry', lastName: 'Taylor', email: 'henry.taylor@example.com', department: 'Sales', salary: 71000, startDate: '2020-02-28', status: 'inactive' },
  { id: '9', firstName: 'Irene', lastName: 'Anderson', email: 'irene.anderson@example.com', department: 'Engineering', salary: 97000, startDate: '2021-08-30', status: 'active' },
  { id: '10', firstName: 'James', lastName: 'Thomas', email: 'james.thomas@example.com', department: 'Finance', salary: 91000, startDate: '2019-05-14', status: 'active' },
  { id: '11', firstName: 'Karen', lastName: 'Jackson', email: 'karen.jackson@example.com', department: 'HR', salary: 63000, startDate: '2023-01-09', status: 'active' },
  { id: '12', firstName: 'Leo', lastName: 'White', email: 'leo.white@example.com', department: 'Engineering', salary: 110000, startDate: '2017-12-01', status: 'active' },
  { id: '13', firstName: 'Mia', lastName: 'Harris', email: 'mia.harris@example.com', department: 'Sales', salary: 74000, startDate: '2022-07-22', status: 'active' },
  { id: '14', firstName: 'Nathan', lastName: 'Martin', email: 'nathan.martin@example.com', department: 'Marketing', salary: 69000, startDate: '2021-10-03', status: 'inactive' },
  { id: '15', firstName: 'Olivia', lastName: 'Garcia', email: 'olivia.garcia@example.com', department: 'Finance', salary: 85000, startDate: '2020-04-11', status: 'active' },
  { id: '16', firstName: 'Patrick', lastName: 'Martinez', email: 'patrick.martinez@example.com', department: 'Engineering', salary: 99000, startDate: '2019-08-25', status: 'active' },
  { id: '17', firstName: 'Quinn', lastName: 'Robinson', email: 'quinn.robinson@example.com', department: 'HR', salary: 67000, startDate: '2022-11-14', status: 'active' },
  { id: '18', firstName: 'Rachel', lastName: 'Clark', email: 'rachel.clark@example.com', department: 'Sales', salary: 73000, startDate: '2021-02-07', status: 'active' },
];
```


## Filter chips

Render `store.getColumnFilters()` as removable pills to show active filters. Use the `getColumnLabel`
function exported from `@mantine/data-grid` to get the column label:

```tsx
// Demo.tsx
import { Button, Pill, Popover, Select, Stack, TextInput } from '@mantine/core';
import { DataGrid, getColumnLabel, useDataGrid } from '@mantine/data-grid';
import { employees } from './data';

function Demo() {
  const store = useDataGrid({
    data: employees,
    columns: [
      { accessorKey: 'firstName', header: 'First Name', enableColumnFilter: true },
      { accessorKey: 'lastName', header: 'Last Name' },
      { accessorKey: 'department', header: 'Department', filterFn: 'equals' },
      { accessorKey: 'status', header: 'Status', filterFn: 'equals' },
      { accessorKey: 'salary', header: 'Salary', meta: { align: 'end' } },
    ],
    withFaceting: true,
  });

  return (
    <DataGrid store={store}>
      <DataGrid.Toolbar>
        <Popover position="bottom-start" shadow="md">
          <Popover.Target>
            <Button size={store.getControlSize()} variant="default">
              Add filter
            </Button>
          </Popover.Target>
          <Popover.Dropdown>
            <Stack gap="sm" w={220}>
              <TextInput
                label="First name"
                placeholder="Contains"
                value={(store.getColumnFilterValue('firstName') as string) ?? ''}
                onChange={(event) => store.setColumnFilter('firstName', event.currentTarget.value)}
              />
              <Select
                label="Department"
                placeholder="Any"
                clearable
                data={store.getFacetedUniqueValues('department')}
                value={(store.getColumnFilterValue('department') as string) ?? null}
                onChange={(value) => store.setColumnFilter('department', value)}
              />
              <Select
                label="Status"
                placeholder="Any"
                clearable
                data={store.getFacetedUniqueValues('status')}
                value={(store.getColumnFilterValue('status') as string) ?? null}
                onChange={(value) => store.setColumnFilter('status', value)}
              />
            </Stack>
          </Popover.Dropdown>
        </Popover>
        {store.getColumnFilters().map((filter) => {
          const column = store.table.getColumn(filter.id);
          return column ? (
            <Pill
              key={filter.id}
              size={store.getControlSize()}
              withRemoveButton
              onRemove={() => store.setColumnFilter(filter.id, undefined)}
            >
              {getColumnLabel(column)}: {String(filter.value)}
            </Pill>
          ) : null;
        })}
        {store.getColumnFilters().length > 0 && (
          <Button size={store.getControlSize()} variant="default" onClick={() => store.resetColumnFilters()}>
            Clear all
          </Button>
        )}
      </DataGrid.Toolbar>
    </DataGrid>
  );
}

// data.ts
export const employees = [
  { id: '1', firstName: 'Alice', lastName: 'Johnson', email: 'alice.johnson@example.com', department: 'Engineering', salary: 95000, startDate: '2021-03-15', status: 'active' },
  { id: '2', firstName: 'Bob', lastName: 'Smith', email: 'bob.smith@example.com', department: 'Marketing', salary: 72000, startDate: '2020-07-01', status: 'active' },
  { id: '3', firstName: 'Carol', lastName: 'Williams', email: 'carol.williams@example.com', department: 'Sales', salary: 68000, startDate: '2022-01-10', status: 'active' },
  { id: '4', firstName: 'David', lastName: 'Brown', email: 'david.brown@example.com', department: 'HR', salary: 65000, startDate: '2019-11-20', status: 'inactive' },
  { id: '5', firstName: 'Eva', lastName: 'Davis', email: 'eva.davis@example.com', department: 'Finance', salary: 88000, startDate: '2021-06-05', status: 'active' },
  { id: '6', firstName: 'Frank', lastName: 'Miller', email: 'frank.miller@example.com', department: 'Engineering', salary: 102000, startDate: '2018-09-12', status: 'active' },
  { id: '7', firstName: 'Grace', lastName: 'Wilson', email: 'grace.wilson@example.com', department: 'Marketing', salary: 76000, startDate: '2022-04-18', status: 'active' },
  { id: '8', firstName: 'Henry', lastName: 'Taylor', email: 'henry.taylor@example.com', department: 'Sales', salary: 71000, startDate: '2020-02-28', status: 'inactive' },
  { id: '9', firstName: 'Irene', lastName: 'Anderson', email: 'irene.anderson@example.com', department: 'Engineering', salary: 97000, startDate: '2021-08-30', status: 'active' },
  { id: '10', firstName: 'James', lastName: 'Thomas', email: 'james.thomas@example.com', department: 'Finance', salary: 91000, startDate: '2019-05-14', status: 'active' },
  { id: '11', firstName: 'Karen', lastName: 'Jackson', email: 'karen.jackson@example.com', department: 'HR', salary: 63000, startDate: '2023-01-09', status: 'active' },
  { id: '12', firstName: 'Leo', lastName: 'White', email: 'leo.white@example.com', department: 'Engineering', salary: 110000, startDate: '2017-12-01', status: 'active' },
  { id: '13', firstName: 'Mia', lastName: 'Harris', email: 'mia.harris@example.com', department: 'Sales', salary: 74000, startDate: '2022-07-22', status: 'active' },
  { id: '14', firstName: 'Nathan', lastName: 'Martin', email: 'nathan.martin@example.com', department: 'Marketing', salary: 69000, startDate: '2021-10-03', status: 'inactive' },
  { id: '15', firstName: 'Olivia', lastName: 'Garcia', email: 'olivia.garcia@example.com', department: 'Finance', salary: 85000, startDate: '2020-04-11', status: 'active' },
  { id: '16', firstName: 'Patrick', lastName: 'Martinez', email: 'patrick.martinez@example.com', department: 'Engineering', salary: 99000, startDate: '2019-08-25', status: 'active' },
  { id: '17', firstName: 'Quinn', lastName: 'Robinson', email: 'quinn.robinson@example.com', department: 'HR', salary: 67000, startDate: '2022-11-14', status: 'active' },
  { id: '18', firstName: 'Rachel', lastName: 'Clark', email: 'rachel.clark@example.com', department: 'Sales', salary: 73000, startDate: '2021-02-07', status: 'active' },
];
```


## Controlled filters

Pass `columnFilters` and `onColumnFiltersChange` to `useDataGrid` to control filter state.
The state is an array of `{ id, value }` objects:

```tsx
// Demo.tsx
import { useState } from 'react';
import { ColumnFiltersState } from '@tanstack/react-table';
import { Code, Text, TextInput } from '@mantine/core';
import { DataGrid, useDataGrid } from '@mantine/data-grid';
import { employees } from './data';

function Demo() {
  const [columnFilters, setColumnFilters] = useState<ColumnFiltersState>([]);

  const store = useDataGrid({
    data: employees,
    columns: [
      { accessorKey: 'firstName', header: 'First Name', enableColumnFilter: true },
      { accessorKey: 'lastName', header: 'Last Name', enableColumnFilter: true },
      { accessorKey: 'department', header: 'Department' },
      { accessorKey: 'salary', header: 'Salary' },
      { accessorKey: 'status', header: 'Status' },
    ],
    columnFilters,
    onColumnFiltersChange: setColumnFilters,
  });

  return (
    <>
      <TextInput
        placeholder="Filter by first name"
        value={(store.getColumnFilterValue('firstName') as string) ?? ''}
        onChange={(event) => store.setColumnFilter('firstName', event.currentTarget.value)}
        mb="md"
      />
      <Text mb="md">
        Active filters: <Code>{JSON.stringify(columnFilters)}</Code>
      </Text>
      <DataGrid store={store} />
    </>
  );
}

// data.ts
export const employees = [
  { id: '1', firstName: 'Alice', lastName: 'Johnson', email: 'alice.johnson@example.com', department: 'Engineering', salary: 95000, startDate: '2021-03-15', status: 'active' },
  { id: '2', firstName: 'Bob', lastName: 'Smith', email: 'bob.smith@example.com', department: 'Marketing', salary: 72000, startDate: '2020-07-01', status: 'active' },
  { id: '3', firstName: 'Carol', lastName: 'Williams', email: 'carol.williams@example.com', department: 'Sales', salary: 68000, startDate: '2022-01-10', status: 'active' },
  { id: '4', firstName: 'David', lastName: 'Brown', email: 'david.brown@example.com', department: 'HR', salary: 65000, startDate: '2019-11-20', status: 'inactive' },
  { id: '5', firstName: 'Eva', lastName: 'Davis', email: 'eva.davis@example.com', department: 'Finance', salary: 88000, startDate: '2021-06-05', status: 'active' },
  { id: '6', firstName: 'Frank', lastName: 'Miller', email: 'frank.miller@example.com', department: 'Engineering', salary: 102000, startDate: '2018-09-12', status: 'active' },
  { id: '7', firstName: 'Grace', lastName: 'Wilson', email: 'grace.wilson@example.com', department: 'Marketing', salary: 76000, startDate: '2022-04-18', status: 'active' },
  { id: '8', firstName: 'Henry', lastName: 'Taylor', email: 'henry.taylor@example.com', department: 'Sales', salary: 71000, startDate: '2020-02-28', status: 'inactive' },
  { id: '9', firstName: 'Irene', lastName: 'Anderson', email: 'irene.anderson@example.com', department: 'Engineering', salary: 97000, startDate: '2021-08-30', status: 'active' },
  { id: '10', firstName: 'James', lastName: 'Thomas', email: 'james.thomas@example.com', department: 'Finance', salary: 91000, startDate: '2019-05-14', status: 'active' },
  { id: '11', firstName: 'Karen', lastName: 'Jackson', email: 'karen.jackson@example.com', department: 'HR', salary: 63000, startDate: '2023-01-09', status: 'active' },
  { id: '12', firstName: 'Leo', lastName: 'White', email: 'leo.white@example.com', department: 'Engineering', salary: 110000, startDate: '2017-12-01', status: 'active' },
  { id: '13', firstName: 'Mia', lastName: 'Harris', email: 'mia.harris@example.com', department: 'Sales', salary: 74000, startDate: '2022-07-22', status: 'active' },
  { id: '14', firstName: 'Nathan', lastName: 'Martin', email: 'nathan.martin@example.com', department: 'Marketing', salary: 69000, startDate: '2021-10-03', status: 'inactive' },
  { id: '15', firstName: 'Olivia', lastName: 'Garcia', email: 'olivia.garcia@example.com', department: 'Finance', salary: 85000, startDate: '2020-04-11', status: 'active' },
  { id: '16', firstName: 'Patrick', lastName: 'Martinez', email: 'patrick.martinez@example.com', department: 'Engineering', salary: 99000, startDate: '2019-08-25', status: 'active' },
  { id: '17', firstName: 'Quinn', lastName: 'Robinson', email: 'quinn.robinson@example.com', department: 'HR', salary: 67000, startDate: '2022-11-14', status: 'active' },
  { id: '18', firstName: 'Rachel', lastName: 'Clark', email: 'rachel.clark@example.com', department: 'Sales', salary: 73000, startDate: '2021-02-07', status: 'active' },
];
```


## Custom filter functions

Set `filterFn` on a column definition to a function that receives the row, column id and
filter value and returns `true` if the row should be included:

```tsx
// Demo.tsx
import { TextInput } from '@mantine/core';
import { DataGrid, DataGridFilterFn, useDataGrid } from '@mantine/data-grid';
import { employees } from './data';

const exactMatchFilter: DataGridFilterFn = (row, columnId, filterValue) => {
  if (!filterValue) {
    return true;
  }
  const cellValue = String(row.getValue(columnId));
  return cellValue === filterValue;
};

function Demo() {
  const store = useDataGrid({
    data: employees,
    columns: [
      { accessorKey: 'firstName', header: 'First Name' },
      { accessorKey: 'lastName', header: 'Last Name' },
      { accessorKey: 'department', header: 'Department (exact match)', filterFn: exactMatchFilter },
      { accessorKey: 'salary', header: 'Salary' },
    ],
  });

  return (
    <>
      <TextInput
        placeholder="Department, exact match (e.g. Engineering)"
        value={(store.getColumnFilterValue('department') as string) ?? ''}
        onChange={(event) => store.setColumnFilter('department', event.currentTarget.value)}
        mb="md"
      />
      <DataGrid store={store} />
    </>
  );
}

// data.ts
export const employees = [
  { id: '1', firstName: 'Alice', lastName: 'Johnson', email: 'alice.johnson@example.com', department: 'Engineering', salary: 95000, startDate: '2021-03-15', status: 'active' },
  { id: '2', firstName: 'Bob', lastName: 'Smith', email: 'bob.smith@example.com', department: 'Marketing', salary: 72000, startDate: '2020-07-01', status: 'active' },
  { id: '3', firstName: 'Carol', lastName: 'Williams', email: 'carol.williams@example.com', department: 'Sales', salary: 68000, startDate: '2022-01-10', status: 'active' },
  { id: '4', firstName: 'David', lastName: 'Brown', email: 'david.brown@example.com', department: 'HR', salary: 65000, startDate: '2019-11-20', status: 'inactive' },
  { id: '5', firstName: 'Eva', lastName: 'Davis', email: 'eva.davis@example.com', department: 'Finance', salary: 88000, startDate: '2021-06-05', status: 'active' },
  { id: '6', firstName: 'Frank', lastName: 'Miller', email: 'frank.miller@example.com', department: 'Engineering', salary: 102000, startDate: '2018-09-12', status: 'active' },
  { id: '7', firstName: 'Grace', lastName: 'Wilson', email: 'grace.wilson@example.com', department: 'Marketing', salary: 76000, startDate: '2022-04-18', status: 'active' },
  { id: '8', firstName: 'Henry', lastName: 'Taylor', email: 'henry.taylor@example.com', department: 'Sales', salary: 71000, startDate: '2020-02-28', status: 'inactive' },
  { id: '9', firstName: 'Irene', lastName: 'Anderson', email: 'irene.anderson@example.com', department: 'Engineering', salary: 97000, startDate: '2021-08-30', status: 'active' },
  { id: '10', firstName: 'James', lastName: 'Thomas', email: 'james.thomas@example.com', department: 'Finance', salary: 91000, startDate: '2019-05-14', status: 'active' },
  { id: '11', firstName: 'Karen', lastName: 'Jackson', email: 'karen.jackson@example.com', department: 'HR', salary: 63000, startDate: '2023-01-09', status: 'active' },
  { id: '12', firstName: 'Leo', lastName: 'White', email: 'leo.white@example.com', department: 'Engineering', salary: 110000, startDate: '2017-12-01', status: 'active' },
  { id: '13', firstName: 'Mia', lastName: 'Harris', email: 'mia.harris@example.com', department: 'Sales', salary: 74000, startDate: '2022-07-22', status: 'active' },
  { id: '14', firstName: 'Nathan', lastName: 'Martin', email: 'nathan.martin@example.com', department: 'Marketing', salary: 69000, startDate: '2021-10-03', status: 'inactive' },
  { id: '15', firstName: 'Olivia', lastName: 'Garcia', email: 'olivia.garcia@example.com', department: 'Finance', salary: 85000, startDate: '2020-04-11', status: 'active' },
  { id: '16', firstName: 'Patrick', lastName: 'Martinez', email: 'patrick.martinez@example.com', department: 'Engineering', salary: 99000, startDate: '2019-08-25', status: 'active' },
  { id: '17', firstName: 'Quinn', lastName: 'Robinson', email: 'quinn.robinson@example.com', department: 'HR', salary: 67000, startDate: '2022-11-14', status: 'active' },
  { id: '18', firstName: 'Rachel', lastName: 'Clark', email: 'rachel.clark@example.com', department: 'Sales', salary: 73000, startDate: '2021-02-07', status: 'active' },
];
```


## Disable filtering per column

Set `enableColumnFilter: false` on a column definition to disable filtering of that column:

```tsx
const store = useDataGrid({
  data,
  withFiltering: true,
  columns: [
    { accessorKey: 'id', header: 'ID', enableColumnFilter: false },
    { accessorKey: 'name', header: 'Name' },
    { accessorKey: 'email', header: 'Email' },
  ],
});
```

## Global filter column exclusion

Set `enableGlobalFilter: false` on a column definition to exclude the column from the global search:

```tsx
// Demo.tsx
import { DataGrid, useDataGrid } from '@mantine/data-grid';
import { TextInput } from '@mantine/core';
import { employees } from './data';

function Demo() {
  const store = useDataGrid({
    data: employees,
    columns: [
      { accessorKey: 'firstName', header: 'First Name' },
      { accessorKey: 'lastName', header: 'Last Name' },
      {
        accessorKey: 'email',
        header: 'Email (excluded)',
        size: 220,
        enableGlobalFilter: false,
      },
      { accessorKey: 'department', header: 'Department' },
      {
        accessorKey: 'salary',
        header: 'Salary (excluded)',
        enableGlobalFilter: false,
      },
    ],
    withGlobalFilter: true,
  });

  return (
    <>
      <TextInput
        placeholder="Search..."
        value={store.getGlobalFilter() ?? ''}
        onChange={(event) => store.setGlobalFilter(event.currentTarget.value)}
        mb="md"
      />
      <DataGrid store={store} />
    </>
  );
}

// data.ts
export const employees = [
  { id: '1', firstName: 'Alice', lastName: 'Johnson', email: 'alice.johnson@example.com', department: 'Engineering', salary: 95000, startDate: '2021-03-15', status: 'active' },
  { id: '2', firstName: 'Bob', lastName: 'Smith', email: 'bob.smith@example.com', department: 'Marketing', salary: 72000, startDate: '2020-07-01', status: 'active' },
  { id: '3', firstName: 'Carol', lastName: 'Williams', email: 'carol.williams@example.com', department: 'Sales', salary: 68000, startDate: '2022-01-10', status: 'active' },
  { id: '4', firstName: 'David', lastName: 'Brown', email: 'david.brown@example.com', department: 'HR', salary: 65000, startDate: '2019-11-20', status: 'inactive' },
  { id: '5', firstName: 'Eva', lastName: 'Davis', email: 'eva.davis@example.com', department: 'Finance', salary: 88000, startDate: '2021-06-05', status: 'active' },
  { id: '6', firstName: 'Frank', lastName: 'Miller', email: 'frank.miller@example.com', department: 'Engineering', salary: 102000, startDate: '2018-09-12', status: 'active' },
  { id: '7', firstName: 'Grace', lastName: 'Wilson', email: 'grace.wilson@example.com', department: 'Marketing', salary: 76000, startDate: '2022-04-18', status: 'active' },
  { id: '8', firstName: 'Henry', lastName: 'Taylor', email: 'henry.taylor@example.com', department: 'Sales', salary: 71000, startDate: '2020-02-28', status: 'inactive' },
  { id: '9', firstName: 'Irene', lastName: 'Anderson', email: 'irene.anderson@example.com', department: 'Engineering', salary: 97000, startDate: '2021-08-30', status: 'active' },
  { id: '10', firstName: 'James', lastName: 'Thomas', email: 'james.thomas@example.com', department: 'Finance', salary: 91000, startDate: '2019-05-14', status: 'active' },
  { id: '11', firstName: 'Karen', lastName: 'Jackson', email: 'karen.jackson@example.com', department: 'HR', salary: 63000, startDate: '2023-01-09', status: 'active' },
  { id: '12', firstName: 'Leo', lastName: 'White', email: 'leo.white@example.com', department: 'Engineering', salary: 110000, startDate: '2017-12-01', status: 'active' },
  { id: '13', firstName: 'Mia', lastName: 'Harris', email: 'mia.harris@example.com', department: 'Sales', salary: 74000, startDate: '2022-07-22', status: 'active' },
  { id: '14', firstName: 'Nathan', lastName: 'Martin', email: 'nathan.martin@example.com', department: 'Marketing', salary: 69000, startDate: '2021-10-03', status: 'inactive' },
  { id: '15', firstName: 'Olivia', lastName: 'Garcia', email: 'olivia.garcia@example.com', department: 'Finance', salary: 85000, startDate: '2020-04-11', status: 'active' },
  { id: '16', firstName: 'Patrick', lastName: 'Martinez', email: 'patrick.martinez@example.com', department: 'Engineering', salary: 99000, startDate: '2019-08-25', status: 'active' },
  { id: '17', firstName: 'Quinn', lastName: 'Robinson', email: 'quinn.robinson@example.com', department: 'HR', salary: 67000, startDate: '2022-11-14', status: 'active' },
  { id: '18', firstName: 'Rachel', lastName: 'Clark', email: 'rachel.clark@example.com', department: 'Sales', salary: 73000, startDate: '2021-02-07', status: 'active' },
];
```


## Fuzzy search

Pass `fuzzyFilter` exported from `@mantine/data-grid` as `globalFilterFn` to `useDataGrid`
for typo-tolerant global search. Use `fuzzySort` to sort rows by their match rank:

```tsx
// Demo.tsx
import { DataGrid, fuzzyFilter, useDataGrid } from '@mantine/data-grid';
import { TextInput } from '@mantine/core';
import { employees } from './data';

function Demo() {
  const store = useDataGrid({
    data: employees,
    columns: [
      { accessorKey: 'firstName', header: 'First Name' },
      { accessorKey: 'lastName', header: 'Last Name' },
      { accessorKey: 'email', header: 'Email', size: 220 },
      { accessorKey: 'department', header: 'Department' },
      { accessorKey: 'salary', header: 'Salary' },
    ],
    withGlobalFilter: true,
    globalFilterFn: fuzzyFilter,
  });

  return (
    <>
      <TextInput
        placeholder="Search..."
        value={store.getGlobalFilter() ?? ''}
        onChange={(event) => store.setGlobalFilter(event.currentTarget.value)}
        mb="md"
      />
      <DataGrid store={store} />
    </>
  );
}

// data.ts
export const employees = [
  { id: '1', firstName: 'Alice', lastName: 'Johnson', email: 'alice.johnson@example.com', department: 'Engineering', salary: 95000, startDate: '2021-03-15', status: 'active' },
  { id: '2', firstName: 'Bob', lastName: 'Smith', email: 'bob.smith@example.com', department: 'Marketing', salary: 72000, startDate: '2020-07-01', status: 'active' },
  { id: '3', firstName: 'Carol', lastName: 'Williams', email: 'carol.williams@example.com', department: 'Sales', salary: 68000, startDate: '2022-01-10', status: 'active' },
  { id: '4', firstName: 'David', lastName: 'Brown', email: 'david.brown@example.com', department: 'HR', salary: 65000, startDate: '2019-11-20', status: 'inactive' },
  { id: '5', firstName: 'Eva', lastName: 'Davis', email: 'eva.davis@example.com', department: 'Finance', salary: 88000, startDate: '2021-06-05', status: 'active' },
  { id: '6', firstName: 'Frank', lastName: 'Miller', email: 'frank.miller@example.com', department: 'Engineering', salary: 102000, startDate: '2018-09-12', status: 'active' },
  { id: '7', firstName: 'Grace', lastName: 'Wilson', email: 'grace.wilson@example.com', department: 'Marketing', salary: 76000, startDate: '2022-04-18', status: 'active' },
  { id: '8', firstName: 'Henry', lastName: 'Taylor', email: 'henry.taylor@example.com', department: 'Sales', salary: 71000, startDate: '2020-02-28', status: 'inactive' },
  { id: '9', firstName: 'Irene', lastName: 'Anderson', email: 'irene.anderson@example.com', department: 'Engineering', salary: 97000, startDate: '2021-08-30', status: 'active' },
  { id: '10', firstName: 'James', lastName: 'Thomas', email: 'james.thomas@example.com', department: 'Finance', salary: 91000, startDate: '2019-05-14', status: 'active' },
  { id: '11', firstName: 'Karen', lastName: 'Jackson', email: 'karen.jackson@example.com', department: 'HR', salary: 63000, startDate: '2023-01-09', status: 'active' },
  { id: '12', firstName: 'Leo', lastName: 'White', email: 'leo.white@example.com', department: 'Engineering', salary: 110000, startDate: '2017-12-01', status: 'active' },
  { id: '13', firstName: 'Mia', lastName: 'Harris', email: 'mia.harris@example.com', department: 'Sales', salary: 74000, startDate: '2022-07-22', status: 'active' },
  { id: '14', firstName: 'Nathan', lastName: 'Martin', email: 'nathan.martin@example.com', department: 'Marketing', salary: 69000, startDate: '2021-10-03', status: 'inactive' },
  { id: '15', firstName: 'Olivia', lastName: 'Garcia', email: 'olivia.garcia@example.com', department: 'Finance', salary: 85000, startDate: '2020-04-11', status: 'active' },
  { id: '16', firstName: 'Patrick', lastName: 'Martinez', email: 'patrick.martinez@example.com', department: 'Engineering', salary: 99000, startDate: '2019-08-25', status: 'active' },
  { id: '17', firstName: 'Quinn', lastName: 'Robinson', email: 'quinn.robinson@example.com', department: 'HR', salary: 67000, startDate: '2022-11-14', status: 'active' },
  { id: '18', firstName: 'Rachel', lastName: 'Clark', email: 'rachel.clark@example.com', department: 'Sales', salary: 73000, startDate: '2021-02-07', status: 'active' },
];
```


## Debounced and server-side filtering

For server-side filtering, set `manualFiltering: true`, keep the filter state controlled and
debounce it with `useDebouncedValue` before sending a request:

```tsx
import { useState } from 'react';
import { ColumnFiltersState } from '@tanstack/react-table';
import { TextInput } from '@mantine/core';
import { useDebouncedValue } from '@mantine/hooks';
import { DataGrid, useDataGrid } from '@mantine/data-grid';

function Demo() {
  const [columnFilters, setColumnFilters] = useState<ColumnFiltersState>([]);
  const [debouncedFilters] = useDebouncedValue(columnFilters, 300);

  // Use debouncedFilters in your data fetching logic
  const data = useQuery(['employees', debouncedFilters], () =>
    fetchEmployees(debouncedFilters)
  );

  const store = useDataGrid({
    data: data ?? [],
    columns: [
      { accessorKey: 'firstName', header: 'First Name' },
      { accessorKey: 'lastName', header: 'Last Name' },
      { accessorKey: 'department', header: 'Department' },
    ],
    withFiltering: true,
    manualFiltering: true,
    columnFilters,
    onColumnFiltersChange: setColumnFilters,
  });

  return (
    <DataGrid store={store}>
      <DataGrid.Toolbar>
        <TextInput
          size={store.getControlSize()}
          placeholder="First name"
          value={(store.getColumnFilterValue('firstName') as string) ?? ''}
          onChange={(event) => store.setColumnFilter('firstName', event.currentTarget.value)}
        />
      </DataGrid.Toolbar>
    </DataGrid>
  );
}
```

See the [Server-side](https://alpha.mantine.dev/llms/data-grid-server-side.md) page for a complete example.

## Empty results

When all rows are filtered out, `emptyState` is displayed. Use `isFiltered` from its payload
to offer a "Clear filters" action, see [States](https://alpha.mantine.dev/llms/data-grid-states.md).
