> ## Documentation Index
> Fetch the complete documentation index at: https://zite.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Manage database views

> Sort, filter, hide, and customize how records appear in your Zite database.

## Overview

Zite Database gives you tools to organize and manage your data in a table. **Sort**, **Hide Fields**, **Filter**, and **Grid View** let you customize how your data is displayed without changing the actual records.

## Sort records

Arrange records in a specific order based on selected fields. This helps you quickly find and compare information.

<img src="https://mintcdn.com/zite/Uiw9erZHDYZ-GaoE/images/Screenshot-2026-05-05-at-5.22.49-PM.png?fit=max&auto=format&n=Uiw9erZHDYZ-GaoE&q=85&s=e64348cb8ad1c8355328527fbc8fb10f" alt="Screenshot 2026 05 05 At 5 22 49 PM" width="1853" height="946" data-path="images/Screenshot-2026-05-05-at-5.22.49-PM.png" />

Hover over a column header and click the `inverted triangle icon` <Icon icon="caret-down" iconType="solid" color="#000000" size={18} />. Then, choose between `Sort ascending` and `Sort descending`. For example, we'll sort the Amount based from the highest to lowest.

## Hide fields

Temporarily remove fields from your current view without deleting them. This keeps your table clean and focused on what matters.

<img src="https://mintcdn.com/zite/Uiw9erZHDYZ-GaoE/images/Screenshot-2026-05-05-at-5.34.13-PM.png?fit=max&auto=format&n=Uiw9erZHDYZ-GaoE&q=85&s=702595f8f7f2f6ecb974632c8f977dfb" alt="Screenshot 2026 05 05 At 5 34 13 PM" title="Screenshot 2026 05 05 At 5 34 13 PM" style={{ width:"38%" }} width="666" height="682" data-path="images/Screenshot-2026-05-05-at-5.34.13-PM.png" />

Click `Hide fields` on top and **untoggle columns** you'd like to hide. For example, let's hide Admin Notes.

<Note>
  If you have multiple views, hidden fields are only hidden in the current view you are using.
</Note>

## Filter fields

Display only the records that meet certain conditions in the current view. This makes it easier to focus on relevant data.

<img src="https://mintcdn.com/zite/Uiw9erZHDYZ-GaoE/images/Screenshot-2026-05-05-at-5.40.00-PM.png?fit=max&auto=format&n=Uiw9erZHDYZ-GaoE&q=85&s=be596dab3996afae5cab952595e24d8c" alt="Screenshot 2026 05 05 At 5 40 00 PM" width="1852" height="763" data-path="images/Screenshot-2026-05-05-at-5.40.00-PM.png" />

Click `Filter` on top followed by `+ Condition` or `+ Condition group`. Set a column field on the left, a qualifier in the middle, and a value on the right. For example, let's only show records of expenses filed that are greater than \$75.

## Create views

You can create and manage different views of the same data. Each view can show the same records in different ways depending on your needs.

<img src="https://mintcdn.com/zite/Uiw9erZHDYZ-GaoE/images/Screenshot-2026-05-05-at-5.43.47-PM.png?fit=max&auto=format&n=Uiw9erZHDYZ-GaoE&q=85&s=dfa1bba40b61ebe0584527ca7b547465" alt="Screenshot 2026 05 05 At 5 43 47 PM" title="Screenshot 2026 05 05 At 5 43 47 PM" style={{ width:"44%" }} width="735" height="334" data-path="images/Screenshot-2026-05-05-at-5.43.47-PM.png" />

Click `Grid view` on top followed by `+ Create view`. A duplicate view will be added in the same table you're in. You can then sort, filter, or hide fields as needed. These changes will only apply to the current view and will not affect other views.

<Warning>
  Deleting records in one view will delete them in all other views. To work around this, [duplicate the database](https://www.zite.com/help/database/manage-data/duplicate#duplicate-an-entire-database) and delete records in the copy.
</Warning>
