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

# Database Views

> Database Views are used to save filtering, sorting, and search options in your tables so that you can quickly return later.

## ❓ What are Database Views?

In your database, you can search, filter, and sort your records to view exactly the data you're looking for. Database Views allow you to save those settings in a view for easy access or sharing.

## 📷 Using Database Views

<Frame>
  <iframe src="https://demo.arcade.software/tvroJu3cJw0QvKbIKWaT?embed" title="https://demo.arcade.software/tvroJu3cJw0QvKbIKWaT?embed" allowFullScreen allow="clipboard-write" class="contentkit-webframe" />
</Frame>

<Steps>
  <Step title="Use the 'Search, Filter, Sort, Hide Fields' options.">
    Search, filter, sort, and/or hide fields to get exactly the view you want.

    <Frame>
      <img src="https://mintcdn.com/xano-997cb9ee/RVHCrB1RJjFkWEmQ/images/106b69a4-image.jpeg?fit=max&auto=format&n=RVHCrB1RJjFkWEmQ&q=85&s=524b779ffc56db9aa7cadb0e23f2a6b2" width="1096" height="515" data-path="images/106b69a4-image.jpeg" />
    </Frame>
  </Step>

  <Step title="Once you're ready, click the 'Save View' button.">
    Give your view a name and, if desired, an <Tooltip tip="An alias is used in advanced scenarios, when you are running direct database queries or external connections to your Xano database.">alias</Tooltip>.

    <Frame>
      <img src="https://mintcdn.com/xano-997cb9ee/p57kHPQ04p_0aEqF/images/b406da64-image.jpeg?fit=max&auto=format&n=p57kHPQ04p_0aEqF&q=85&s=55e1c3e2b36f62de776cf9b30860a098" width="443" height="412" data-path="images/b406da64-image.jpeg" />
    </Frame>

    Take note of how the button in the control bar has changed. You'll now see the name of your view.

    <Frame>
      <img src="https://mintcdn.com/xano-997cb9ee/pz6e9Ndbn8i3u8Zz/images/6c9fe7be-image.jpeg?fit=max&auto=format&n=pz6e9Ndbn8i3u8Zz&q=85&s=d47aa8abbc22399d3a7ba2fde504c81b" width="590" height="239" data-path="images/6c9fe7be-image.jpeg" />
    </Frame>
  </Step>

  <Step title="Click the View button again to see a list of your views and switch between them.">
    <Frame>
      <img src="https://mintcdn.com/xano-997cb9ee/nsvdyKK4Dg7VUAZs/images/9064bd01-image.jpeg?fit=max&auto=format&n=nsvdyKK4Dg7VUAZs&q=85&s=c1b9e4be9f5f5b88e53a7ca604933e99" width="445" height="264" data-path="images/9064bd01-image.jpeg" />
    </Frame>
  </Step>
</Steps>

<Warning>
  Some complex data types, like filtering by arrays, is not currently possible. If you're trying to filter something and not receiving the expected results, please reach out to support or use a [function stack](/the-function-stack/functions/database-requests/query-all-records) instead.
</Warning>
