---
title: "Multi-Select Tree filters with checkboxes"
slug: "multi-select-tree-filters-with-checkboxes"
description: "Let end users tick several Tree Filter items at once to load a combined selection of rows. Available in SQL Spreads Pro and above."
updated: 2025-04-09T14:25:20Z
published: 2025-04-09T14:25:20Z
canonical: "sqlspreads.com/multi-select-tree-filters-with-checkboxes"
---

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

# Create multi-select Tree filters

## Intro to Multi-Select Tree Filters

---

> ![SQLSpreadsProLogo.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/SQLSpreadsProLogo.png) Tree Filters are available in **SQL Spreads Pro** and above

---

Multi-Select Tree-Filters allow you to select multiple items in a Tree filter using checkboxes: ![Multi select tree filters enabled](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/SQL%20Spreads%207.6.3%20Multi%20select%20tree%20filters%20enabled.png)

[![](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/WatchVideoButtonWhite%202%20-%20Red.svg)](https://www.youtube.com/watch?v=HjxlJuqDRb8&start=140)

---

## Create a Multi-Select Tree filter

To create a Multi-Select Tree-Filter, open Design mode and click Setup Tree Filters. ![SQL Spreads Click on Setup Tree Filters button](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/SQL%20Spreads%207.6.3%20Click%20on%20Setup%20Tree%20Filters%20button.png)

You will find the checkbox to enable Multi-Select filters at the bottom of the Setup Tree Filters dialog: ![image.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/image%28232%29.png)

When checked, you will get checkboxes for all items in the Tree Filter.

### Update the Designer filter to load all rows for all selected items

To load only the rows for the selected filter items, you will have to update your Designer Filter.

When using Multi-select Tree filters, the filter parameters will contain a comma separated list of the selected values asin this example:

- **@[FilterName]_Code** contains **‘23’,’26’,’29’**
- **@[FilterName]_Text** contains **‘Item 1,’Item 2’,Item 3’**

To load the rows forthe selected items we will use the **IN** operation in the SQL filter in the SQL Spreads Designer:

```
[TableColumn] IN(@FilterName_Code)
```

You can now either select a single checkbox at the bottom level, or select/deselect the parent checkbox to select/deselect all items below: ![image.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/image%28238%29.png)

### Combine several filters

To combine several filters, you can now decide if the user needs to select one item in each filter, or if each separate filter should load the rows by either use an AND, or an OR in the filter condition: ![image.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/image%28237%29.png)