---
title: "Data Grids"
slug: "smarteru-basics-data-grids"
updated: 2023-10-10T20:34:17Z
published: 2023-10-10T20:34:17Z
canonical: "support.smarteru.com/smarteru-basics-data-grids"
---

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

# Data Grids

Many of SmarterU's dashboards use grids to display records. For example the [Groups Dashboard](/v1/docs/groups-dashboard) displays the groups in your account.

![Interface gráfica do usuário, Gráfico, Aplicativo, Tabela, Gráfico de mapa de árvore Descrição gerada automaticamente](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/smarteru-basics---data-grids-image-uk6k1q12.png)

Each grid consists of rows and columns. The first row displays headings that identify the contents of the column. In some cases, there may be a secondary heading when the column contains a subset of records. For example, the Enrollments column in the Groups Dashboard has a secondary heading for each enrollment status (i.e., Active, Warn, ODue, Cmpl).

![Calendário Descrição gerada automaticamente com confiança baixa](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/smarteru-basics---data-grids-image-zaib20q4.png)

In some cases, you can click the data in the grid to drill down and view more information about the data. Refer to the specific [dashboard pages](/v1/docs/dashboards-guide) for details.

## **Page Controls**

The controls for scrolling through the data are located below the grid.

![Tela de celular Descrição gerada automaticamente](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/smarteru-basics---data-grids-image-btn66bi1.png)

## **Sorting**

By default, rows in the data grids are sorted alphabetically by name. To sort on a different column in the grid, do one of the following:

- Click the column header you want to sort by the rows by. You can click the header again to change the sort direction.
- Click the ![](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/smarteru-basics---data-grids-image-ocfahvos.png) to the right of the column header, the select **Sort Ascending** or **Sort Descending**.

![Interface gráfica do usuário, Aplicativo, Tabela Descrição gerada automaticamente](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/smarteru-basics---data-grids-image-q75u01k6.png)

The column is sorted using the order you selected. An arrow displays beside the column name to indicate the sort order.

![Linha do tempo Descrição gerada automaticamente](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/smarteru-basics---data-grids-image-lu9x8l91.png)

## **Filtering**

Filters enable you to search for records that meet your criteria. For example, you could apply a filter to the [Users Dashboard](/v1/docs/users-dashboard) to search for users that have a name containing "Rob".

![Interface gráfica do usuário, Texto, Aplicativo, Email Descrição gerada automaticamente](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/smarteru-basics---data-grids-image-qx7mgc45.png)

To search for a value in the grid:

1. Click the ![](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/smarteru-basics---data-grids-image-u7lwxwah.png) to the right of the column header.
2. Click **Filter**.
3. Select the condition from the list.
4. Enter the value for the condition in the field.

![Interface gráfica do usuário, Aplicativo Descrição gerada automaticamente](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/smarteru-basics---data-grids-image-kiwmz0aw.png)

1. If you would like to specify another filter, select [**And** or **Or**](/v1/docs/understanding-and-vs-or-filter) from the dropdown.

- **And**: The row is included only if both filters are met.
- **Or**: If the row meets either filter, it will be included.

1. Click **Filter**.

The filter is applied.

## **Removing Filters**

To remove a filter:

1. Click the ![](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/smarteru-basics---data-grids-image-lfrcn0at.png) to the right of the column header.
2. Click **Filter**.
3. Click **Clear**.

## Related

- [Understanding AND vs. OR Filter](/understanding-and-vs-or-filter.md)