Want to skip to the implementation? Check out these React examples:
import { useTable, tableFeatures, columnFilteringFeature, globalFilteringFeature, rowSortingFeature, createFilteredRowModel, createSortedRowModel, filterFns, sortFns } from '@tanstack/react-table'
const features = tableFeatures({
columnFilteringFeature,
globalFilteringFeature,
rowSortingFeature,
})
const table = useTable({
features,
rowModels: {
filteredRowModel: createFilteredRowModel(filterFns),
sortedRowModel: createSortedRowModel(sortFns),
},
columns,
data,
})import { useTable, tableFeatures, columnFilteringFeature, globalFilteringFeature, rowSortingFeature, createFilteredRowModel, createSortedRowModel, filterFns, sortFns } from '@tanstack/react-table'
const features = tableFeatures({
columnFilteringFeature,
globalFilteringFeature,
rowSortingFeature,
})
const table = useTable({
features,
rowModels: {
filteredRowModel: createFilteredRowModel(filterFns),
sortedRowModel: createSortedRowModel(sortFns),
},
columns,
data,
})Fuzzy filtering is a technique that allows you to filter data based on approximate matches. This can be useful when you want to search for data that is similar to a given value, rather than an exact match.
You can implement a client side fuzzy filtering by defining a custom filter function. This function should take in the row, columnId, and filter value, and return a boolean indicating whether the row should be included in the filtered data.
Fuzzy filtering is mostly used with global filtering, but you can also apply it to individual columns. We will discuss how to implement fuzzy filtering for both cases.
Note: You will need to install the @tanstack/match-sorter-utils library to use fuzzy filtering. TanStack Match Sorter Utils is a fork of match-sorter by Kent C. Dodds. It was forked in order to work better with TanStack Table's row by row filtering approach.
Using the match-sorter libraries is optional, but the TanStack Match Sorter Utils library provides a great way to both fuzzy filter and sort by the rank information it returns, so that rows can be sorted by their closest matches to the search query.
Here's an example of a custom fuzzy filter function:
import { rankItem } from '@tanstack/match-sorter-utils'
import type { RankingInfo } from '@tanstack/match-sorter-utils'
import type { FilterFn, RowData } from '@tanstack/react-table'
const fuzzyFilter: FilterFn<typeof features, RowData> = (
row,
columnId,
value,
addMeta,
) => {
// Rank the item
const itemRank = rankItem(row.getValue(columnId), value)
// Store the itemRank info
addMeta?.({ itemRank })
// Return if the item should be filtered in/out
return itemRank.passed
}import { rankItem } from '@tanstack/match-sorter-utils'
import type { RankingInfo } from '@tanstack/match-sorter-utils'
import type { FilterFn, RowData } from '@tanstack/react-table'
const fuzzyFilter: FilterFn<typeof features, RowData> = (
row,
columnId,
value,
addMeta,
) => {
// Rank the item
const itemRank = rankItem(row.getValue(columnId), value)
// Store the itemRank info
addMeta?.({ itemRank })
// Return if the item should be filtered in/out
return itemRank.passed
}In this function, we're using the rankItem function from the @tanstack/match-sorter-utils library to rank the item. We then store the ranking information in the filter meta of the row (the addMeta callback is optional, so call it with optional chaining), and return whether the item passed the ranking criteria.
To reference this filter function by the string name 'fuzzy' (and to type the stored filter meta), augment the FilterFns and FilterMeta interfaces with a declare module block:
declare module '@tanstack/react-table' {
// add the fuzzy filter to the filterFns registry types
interface FilterFns {
fuzzy: FilterFn<typeof features, RowData>
}
interface FilterMeta {
itemRank?: RankingInfo
}
}declare module '@tanstack/react-table' {
// add the fuzzy filter to the filterFns registry types
interface FilterFns {
fuzzy: FilterFn<typeof features, RowData>
}
interface FilterMeta {
itemRank?: RankingInfo
}
}To use fuzzy filtering with global filtering, register the fuzzy filter function in the registry passed to createFilteredRowModel and reference it in the globalFilterFn option of the table:
import {
useTable,
tableFeatures,
columnFilteringFeature,
globalFilteringFeature,
rowSortingFeature,
createFilteredRowModel,
createSortedRowModel,
filterFns,
sortFns,
} from '@tanstack/react-table'
const features = tableFeatures({
columnFilteringFeature,
globalFilteringFeature,
rowSortingFeature,
})
const table = useTable({
features,
rowModels: {
filteredRowModel: createFilteredRowModel({
...filterFns,
fuzzy: fuzzyFilter,
}),
sortedRowModel: createSortedRowModel(sortFns), // needed if you want sorting with fuzzy rank
},
columns,
data,
globalFilterFn: 'fuzzy',
})import {
useTable,
tableFeatures,
columnFilteringFeature,
globalFilteringFeature,
rowSortingFeature,
createFilteredRowModel,
createSortedRowModel,
filterFns,
sortFns,
} from '@tanstack/react-table'
const features = tableFeatures({
columnFilteringFeature,
globalFilteringFeature,
rowSortingFeature,
})
const table = useTable({
features,
rowModels: {
filteredRowModel: createFilteredRowModel({
...filterFns,
fuzzy: fuzzyFilter,
}),
sortedRowModel: createSortedRowModel(sortFns), // needed if you want sorting with fuzzy rank
},
columns,
data,
globalFilterFn: 'fuzzy',
})To use fuzzy filtering with column filtering, pass your fuzzy filter function to createFilteredRowModel (merging it with the built-in filterFns). You can then specify the fuzzy filter by name in the filterFn option of the column definition:
const column = [
{
accessorFn: row => `${row.firstName} ${row.lastName}`,
id: 'fullName',
header: 'Full Name',
cell: info => info.getValue(),
filterFn: 'fuzzy', //using our custom fuzzy filter function
},
// other columns...
];const column = [
{
accessorFn: row => `${row.firstName} ${row.lastName}`,
id: 'fullName',
header: 'Full Name',
cell: info => info.getValue(),
filterFn: 'fuzzy', //using our custom fuzzy filter function
},
// other columns...
];In this example, we're applying the fuzzy filter to a column that combines the firstName and lastName fields of the data.
When using fuzzy filtering with column filtering, you might also want to sort the data based on the ranking information. You can do this by defining a custom sorting function:
import { compareItems } from '@tanstack/match-sorter-utils'
import { sortFns } from '@tanstack/react-table'
import type { SortFn } from '@tanstack/react-table'
const fuzzySort: SortFn<typeof features, Person> = (rowA, rowB, columnId) => {
let dir = 0
// Only sort by rank if the column has ranking information
if (rowA.columnFiltersMeta[columnId]) {
dir = compareItems(
rowA.columnFiltersMeta[columnId].itemRank!,
rowB.columnFiltersMeta[columnId].itemRank!,
)
}
// Provide an alphanumeric fallback for when the item ranks are equal
return dir === 0 ? sortFns.alphanumeric(rowA, rowB, columnId) : dir
}import { compareItems } from '@tanstack/match-sorter-utils'
import { sortFns } from '@tanstack/react-table'
import type { SortFn } from '@tanstack/react-table'
const fuzzySort: SortFn<typeof features, Person> = (rowA, rowB, columnId) => {
let dir = 0
// Only sort by rank if the column has ranking information
if (rowA.columnFiltersMeta[columnId]) {
dir = compareItems(
rowA.columnFiltersMeta[columnId].itemRank!,
rowB.columnFiltersMeta[columnId].itemRank!,
)
}
// Provide an alphanumeric fallback for when the item ranks are equal
return dir === 0 ? sortFns.alphanumeric(rowA, rowB, columnId) : dir
}In this function, we're comparing the ranking information of the two rows. If the ranks are equal, we fall back to alphanumeric sorting.
You can then pass this sorting function directly to the sortFn option of the column definition:
{
accessorFn: row => `${row.firstName} ${row.lastName}`,
id: 'fullName',
header: 'Full Name',
cell: info => info.getValue(),
filterFn: 'fuzzy', // using our custom fuzzy filter function (registered above)
sortFn: fuzzySort, // pass our custom fuzzy sort function directly
}{
accessorFn: row => `${row.firstName} ${row.lastName}`,
id: 'fullName',
header: 'Full Name',
cell: info => info.getValue(),
filterFn: 'fuzzy', // using our custom fuzzy filter function (registered above)
sortFn: fuzzySort, // pass our custom fuzzy sort function directly
}Note: Unlike filterFn: 'fuzzy' above, fuzzySort is passed as a function rather than a string. A string reference like sortFn: 'fuzzySort' would only work if you also registered the function in the registry passed to createSortedRowModel (e.g. createSortedRowModel({ ...sortFns, fuzzySort })) and augmented the SortFns interface the same way as FilterFns. Passing the function directly skips both steps.