# Filter, sort and search

> Find records with filters (including relative dates), sorting and search across a database.

Source: https://docs.formclick.io/databases/database-filter-sort-search

Each table opens in its **Table** view, where you can filter, sort and search its records.

## Filters

- Combine conditions with **and** / **or**, and group them.
- Text: is, is not, contains, does not contain, is empty, is not empty.
- Numbers: equal, not equal, greater or less than, between.
- Selects: is any of, has all of, has none of.
- Dates: before, after, on or before, on or after, and relative dates such as past week, this month or next year.

## Sorting

Sort by any field, ascending or descending.

## Search

Search a whole database at once: table names, field names and record values.