# Filter tables

> How to narrow down orders, customers, guest lists and other tables with several conditions.

Web page: https://staging.event-buddy.de/en/docs/filter-tables · Deutsch: https://staging.event-buddy.de/docs/tabellen-filtern.md

Every table in the admin has a filter bar above the list. Use it to build exactly the list you need right now, for example all orders over €50 that are not cancelled.

## Add a filter

1. **Click Filter**

   Click **Filter** above the table. You see a list of the fields you can filter by. Use **Filter by …** to search it.

2. **Choose a field and a condition**

   Pick a field, for example "Status" or "Amount", and then the condition. Which conditions exist depends on the field, see the table below.

3. **Enter a value**

   Enter the value. The table updates right away, there is nothing to confirm.

Click the cross on a chip to remove that condition. **Clear all** removes every condition at once.

## Which conditions exist

| Field type | Conditions |
| --- | --- |
| Choice, for example status or event | is any of, is none of |
| Text | contains, does not contain, is |
| Number, for example amount | `=`, `>`, `<`, between |
| Date | on, before, after, between |
| Yes or no | is |

## Several conditions

You can combine as many conditions as you like. They always all apply at once ("and"). There is no "or" between conditions. For "status paid or open", pick several values in one field with **is any of** instead.

> **Tip**
>
> If a list stays empty, first check whether a filter is too strict. Remove the chips one by one until entries appear again.

## Good to know

### Can I share a filtered list with my team?

Yes. The filtered view is stored in the page address. Copy the link and your team sees the same list. The filters also stay when you reload the page.

### Does the export respect my filters?

Yes. Exports contain exactly the rows you filtered.

## Related articles

- [Export data as CSV or Excel](https://staging.event-buddy.de/en/docs/export-data.md)
- [Schedule exports and deliver them automatically](https://staging.event-buddy.de/en/docs/schedule-exports.md)
- [Find and edit orders](https://staging.event-buddy.de/en/docs/find-and-edit-orders.md)

## Next step

[Request a test shop](https://staging.event-buddy.de/en/demo)

Request without the form: email [neukunde@eventbuddy.de](mailto:neukunde@eventbuddy.de?subject=Request%3A%20Filter%20tables) with your organization, date and price list.
