Filters

The filter system allows you to select the exact rows you need from a data table. You can create and combine as many filters as required.

To use filters, click the Filters button on the data table. The filters panel will appear, allowing you to create filters. Click Apply once you have finished.

INFO

The filter system works alongside other data table filters, such as search, date ranges, and status filters. If you are not seeing the results you expect, check whether another filter is affecting the results.

Filters

A filter has three parts:

• Column - The data you want to filter.
• Operator - How the value should be compared.
• Value - The value to compare against.

The available operators depend on the type of data in the selected column.

Comparison Operators

Operator	Description
Is	Matches the value exactly.
Is not	Excludes values that match exactly.
Matches	Matches values using wildcards. Use % to represent any number of characters. For example, %apple% will match any value containing "apple".
Does not match	Excludes values that match using wildcards.
In	Matches if the column value is one of the values provided.
Not in	Matches if the column value is not one of the values provided.
Greater than	Matches values greater than the provided value.
Less than	Matches values less than the provided value.
Greater than or equal to	Matches values greater than or equal to the provided value.
Less than or equal to	Matches values less than or equal to the provided value.
Is null	Matches rows where the column has no value.
Is not null	Matches rows where the column has a value.

Combining Filters

Filters can be combined using either the AND or OR operators.

By default, filters use AND, but this can be changed to OR by clicking the operator between filters.

Each filter evaluates to either true or false for each row. A row is displayed only when the final result of the combined filters is true.

For example, if we have two filters called A and B:

AND

Both filters must be true for the row to be displayed.

true AND true = display row
true AND false = hide row
false AND true = hide row
false AND false = hide row

OR

At least one filter must be true for the row to be displayed.

true OR true = display row
true OR false = display row
false OR true = display row
false OR false = hide row

Evaluation Order

When using multiple filters, it is important to consider the order they are evaluated.

Filters are evaluated from left to right. This can sometimes produce a different result than expected.

For example:

Filter A AND Filter B OR Filter C

This will evaluate as:

(Filter A AND Filter B) OR Filter C

However, you may have intended:

Filter A AND (Filter B OR Filter C)

These two combinations can produce different results.

To control the evaluation order, use groups. Groups act like brackets and ensure the filters inside the group are evaluated together before being combined with other filters.

Groups

You can create groups by clicking the Groups button.

Filters and groups can be created inside existing groups or dragged into them.

Groups can also be given an optional name to help identify their purpose when creating complex filters.

Disabling Filters and Groups

You can temporarily disable a filter or group using the toggle.

This allows you to test different filter combinations without needing to recreate filters.

Rearranging Filters and Groups

You can move filters and groups by clicking the handle icon and dragging them to your desired location.