Skip to content

Filters

About

A Filter allows you to reduce the amount of data displayed in a Table or a View based on specified criteria.

Example

Imagine this table containing movies.

ID Title Release Year Watched?
1 Dante’s Peak 1997 TRUE
2 The Bourne Identity 2002 TRUE
3 The Karate Kid 1984 TRUE
4 Full Metal Jacket 1987 TRUE
5 The French Dispatch 2021 FALSE
6 雨月物語 1953 FALSE
7 Big Trouble 2002 TRUE

You might want to only see movies you’ve watched. You could apply the filter "Watched?" is TRUE and then you’d only see these rows:

ID Title Release Year Watched?
1 Dante’s Peak 1997 TRUE
2 The Bourne Identity 2002 TRUE
3 The Karate Kid 1984 TRUE
4 Full Metal Jacket 1987 TRUE
7 Big Trouble 2002 TRUE

Then you might want to see movies released after 1990 that you’ve watched, so you’d apply an additional filter of Release Year > 1990 and see:

ID Title Release Year Watched?
1 Dante’s Peak 1997 TRUE
2 The Bourne Identity 2002 TRUE
7 Big Trouble 2002 TRUE

Filters in Mathesar

You can filter data in a Table or a View in Mathesar using either the “Filters” button or each column’s menu.

Further Reading