> For the complete documentation index, see [llms.txt](https://docs.hesh.app/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.hesh.app/manuals/materials/filters-sorting-and-searching-materials.md).

# Filters, sorting and searching Materials

The Materials page allows you to quickly find the items you need using interactive filters, sorting, and search. All changes are applied instantly, so the table updates automatically based on the selected parameters.

This guide explains how to work with search, sorting, filters, and infinite scroll on the Materials page.

### General Rules and Information

* Filters, sorting, and searching are available in the Materials table.
* The table updates interactively when you apply filters, sorting, or search queries.
* The page uses infinite scroll.
* Sorting is enabled for all columns.
* Default sorting:
  * Material name → A to Z
  * Status → A to Z
* You can sort by:
  * clicking the column header
  * selecting sorting options in the More actions menu (⋯)
* Search is enabled only for columns that have input field under the title of the column.
* If a column has no search field, it cannot be searched directly.
* Columns with active sorting or filtering are visually marked with ascending/descending arrows or dot in the right corner of filter vector.
* “Columns” sidebar shows markers for columns where filters or search are applied, including for collapsed groups.

## Searching 🔎

Searching is available only for columns where the search field is enabled.

#### How to use search

1. Open the Materials page.
2. Find a column that supports search (a search input is visible under the title of column).
3. Enter your search query in the search field.
4. The system updates the table and displays only the rows that match your query.

{% hint style="info" %}
If no materials match the search value, the table will simply show an empty table with **“No results”**.
{% endhint %}

To clear the search value, click **Clear filters** - this resets the search input and restores the full list of materials.

{% @arcade/embed flowId="NRI5XjGuNPpxa0ICe1yX" url="<https://app.arcade.software/share/NRI5XjGuNPpxa0ICe1yX>" %}

## Sorting ↕️

Sorting can be applied in two ways: by clicking the column header or through the More Actions menu.

### Sorting by clicking on the column header

1. Open the Materials page.
2. Navigate to a column that supports sorting.
3. Click the column name.

*The system*:

* sorts the data according to the column’s sorting order
* switches between **Ascending** (A → Z) and **Descending** (Z → A)
* shows an arrow indicator next to the column header

{% @arcade/embed flowId="sgxuEa3n7XWKW0W7IWR8" url="<https://app.arcade.software/share/sgxuEa3n7XWKW0W7IWR8>" %}

### Sorting from the More Actions menu

1. Click the ⋯ (More actions) icon in the column header.
2. A menu appears with sorting options:
   * Sort Ascending
   * Sort Descending
3. Select the desired option.

*The system:*

* applies sorting
* updates the sorting arrow indicator
* closes the menu

<figure><img src="/files/ZoG4e2EMMYJ7h0mnAvL6" alt=""><figcaption></figcaption></figure>

#### Clearing Sort

1. Open the More Actions menu of the same column.
2. Select Clear Sort.
3. The system:
   * removes sorting
   * restores the table to the previous state before sorting was applied

<figure><img src="/files/Nes3DxFSfy2avG5xHsor" alt=""><figcaption></figcaption></figure>

## Filtering ☰

Different filter types are available depending on the column: text filters, set filters, auto-suggest filters.

### Filters with auto-suggest (String Text filter + search)

1. Open the Materials page.
2. Click the filter icon on a column that supports auto-suggest.
3. A drop-down with filter options appears.
4. Start typing in the field to narrow the list.
5. Select one or more items.
6. *The system:*
   * filters the table based on the selected value(s)
   * shows only exact matches
   * displays a dot indicator on the filter icon

{% @arcade/embed flowId="UYZ52JT3jZYuUNqpAmxH" url="<https://app.arcade.software/share/UYZ52JT3jZYuUNqpAmxH>" %}

### Set Filter (multi-select filter)

1. Click the filter icon in a column with a set filter.
2. The filter panel appears with:
   * Search input
   * Select all checkbox
   * Checkbox for empty cells
   * List of values
   * *Reset* button

#### Applying the filter

* Choose specific values.
* The table updates immediately.

{% @arcade/embed flowId="Ju8PP8K1Dd4rRqa8sMNi" url="<https://app.arcade.software/share/Ju8PP8K1Dd4rRqa8sMNi>" %}

### Resetting the filters

#### **1. Clearing a filter for a specific column**

Use this method when you want to remove filtering only from one column.

1. Open the **filter menu** for the column where the filter is applied.
2. Click **Reset**.
3. *The system*:
   * removes the filter for that column
   * updates the table immediately
   * keeps all other filters active

<figure><img src="/files/WzGQ1zzvmpxGOn9uXyMX" alt=""><figcaption></figcaption></figure>

#### **2. Clearing all filters in the table**

Use this option when you want to remove **every active filter** at once.

1. Make sure at least one filter is currently applied.
2. Click **Clear filters** at the top of the panel.
3. The system:
   * resets **all** filters across all columns
   * refreshes the table to show the full list of materials
   * disables the **Clear filters** button until a new filter is applied

{% @arcade/embed flowId="N5iPgSXbTXzMCuvi8un1" url="<https://app.arcade.software/share/N5iPgSXbTXzMCuvi8un1>" %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.hesh.app/manuals/materials/filters-sorting-and-searching-materials.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.