Skip to main content

Filter and sort Retool Database table rows

You can search Retool Database table data, apply filters, and customize sort options in the editor.

Search records

Click Find in view Find in view or press , then enter a search term to search through all records in the current table. Any results are highlighted and you can move between results using the search box.

Search table data.

Filter records

Click Filter Filter to define filter conditions and show only records that match all of them. For example, you can show only records with a quantity field value less than 9000 and contain the in the name field value.

You can add multiple field filters from the Field options menu. Click the field name in the header and select Filter by this field.

Filter table data.

Click Apply filter to filter records. The Filter Filter popup remains active while filters are applied and displays the number of filter conditions in use. To disable the filter, remove all filters and click Apply filter again.

Sort records

You can sort rows by columns in either ascending or descending order, and sort by multiple columns. Click Field options Field options in the field header and select the sort mode you want to use. You can also click Sort Sort in the toolbar to open sorting options.

Sort table records.