---
title: Filters and Selections
slug: en/filters-and-selections
docTags: 
createdAt: 2024-08-12T12:01:00.665Z
---

*How can I combine filters and save them as a selection?*

***

# Filter functionality

In the *Contacts, Orders, Events, Tickets in Events, Individual Tickets*, and *Waitlist* views, it is possible to create selections using an extensive filtering system. You can combine various arguments/filters to achieve the desired result.

You can always find the available filters on the left side of your tab. Want to add extra filters? Just contact support.

::Image[]{src="https://api.archbee.com/api/optimize/zGnEynQy6cgPdn1J1kZsn/fd1luTLd2zozrwUIoC1QE_schermafbeelding-2024-10-15-om-132210.png" size="20" width="418" height="1670" position="center" showCaption="false"}

::Image[]{src="https://api.archbee.com/api/optimize/zGnEynQy6cgPdn1J1kZsn/UMXtiQdUuaBVoPeLWtQ4z_image.png" size="76" width="611" height="210" position="center" showCaption="false"}

Filters can be individually edited or removed. Click the pencil icon or the cross next to the applied filter.

::Image[]{src="https://api.archbee.com/api/optimize/zGnEynQy6cgPdn1J1kZsn/bNVvvsMFJEpc9eOOCj-O-_image.png" size="66" width="452" height="229" position="center" showCaption="false"}

# Refine, Add, and Remove

Your selection can consist of multiple combined filters. Each added filter can be used to refine (blue), add (green), or remove (red) from your selection. These actions have the following effects:

::Image[]{src="https://api.archbee.com/api/optimize/zGnEynQy6cgPdn1J1kZsn/IWssA_nI8qMwZt_SRd1_5_image.png" size="50" width="425" height="288" position="center" showCaption="false"}

## Examples

**Refine**: If I first filter all contacts who bought tickets for Bruce Springsteen and then apply the filter "Country: Belgium" using '**refine**', I will get a list of all contacts who have a ticket for Bruce Springsteen **and** have Belgium as their country in their contact details.

Result: All Belgians who have tickets for Bruce Springsteen.

**Add**: If I first filter all contacts who bought tickets for Bruce Springsteen and then apply the filter "Country: Belgium" using '**add**', I will get a list of all contacts who have a ticket for Bruce Springsteen **plus** all contacts who have Belgium as their country in their contact details.

Result: All Belgians in your entire contact database + everyone who has tickets for Bruce Springsteen (including non-Belgians).

**Remove**: If I first filter all contacts who bought tickets for Bruce Springsteen and then apply the filter "Country: Belgium" using '**remove**', I will get a list of all contacts who have a ticket for Bruce Springsteen excluding those who have Belgium as their country.

Result: All non-Belgians who have tickets for Bruce Springsteen.

Removing filters is possible in *almost all cases*. If a second added filter depends on the first filter, you won’t be able to remove it.
In the example below, you cannot remove the 'Last year' filter because otherwise there would be no data left to filter by 'Payment status incomplete'.

::Image[]{src="https://api.archbee.com/api/optimize/zGnEynQy6cgPdn1J1kZsn/X0bwrde6-eoCK_vNxWS3Y_image.png" size="70" width="584" height="46" position="center" showCaption="false"}

:::hint{type="info"}
You can assign a specific relation type to certain contact selections. For example, you could give all contacts who purchased more than 10 tickets in 2023 the relation type 'Big spender 2023'.
:::

# Selections

If you frequently use the same combination of filters, you can save them as a **selection**. Selections reflect the current state of the arguments/filters you have applied.

::Image[]{src="https://api.archbee.com/api/optimize/zGnEynQy6cgPdn1J1kZsn/_15yblf5J8JrfKgLJSozI_image.png" size="46" width="256" height="94" position="center" showCaption="false"}

Your saved selections appear **below** the standard filters and can be *managed*, *deleted*, or *shared*.

Click *Manage* next to *Saved selections* to modify your selections.

::Image[]{src="https://api.archbee.com/api/optimize/zGnEynQy6cgPdn1J1kZsn/avwGjFfb6D2URh2OfdRBe_image.png" size="34" width="204" height="105" position="center" showCaption="false"}

To edit, click the pencil icon. To delete, click the trash bin icon.

::Image[]{src="https://api.archbee.com/api/optimize/zGnEynQy6cgPdn1J1kZsn/OKajofNVkpqAzsC6dtopd_image.png" size="90" width="591" height="266" position="center" showCaption="false"}

You can, for example, change the *name* of your selection or adjust the applied arguments/filters:

![](https://api.archbee.com/api/optimize/zGnEynQy6cgPdn1J1kZsn/HvGhV-E0MtN6olnQnCQHJ_image.png)

You can easily share your selection using the download button. Once you download a selection, a file is generated that you can forward. The recipient can then import this file into their own environment under saved selections.

To import a file, click **Manage** and then **Import**. Upload the file, give it a name of your choice, and the selection will appear under your saved selections.

::Image[]{src="https://api.archbee.com/api/optimize/zGnEynQy6cgPdn1J1kZsn/msb5rIcxoZYzoFPLcRTrC_image.png" size="66" width="591" height="266" position="center" showCaption="false"}

You can also export your selection to Excel. Check the orders you want to export and then click 'Open in Excel'. The selected data will then open in an Excel file.
