> For the complete documentation index, see [llms.txt](https://docs.monolithforensics.com/monolith/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.monolithforensics.com/monolith/using-monolith/monolith-ui-features/query-filter.md).
# Query Filter
Build field-based filters to narrow Monolith tables using dates, text, selections, and AND/OR logic.
The **Query Filter** is used throughout Monolith to narrow tables using field-based conditions.
Filters use conditional logic to return only the records that match the criteria you define. Available fields and filter options depend on the type of records being viewed.
### Example:
This filter uses **AND** logic, which means a record must match all three conditions to appear in the results.
* Open Date is sometime after January 1, 2023
* The Case Lead is Matt Danner
* The Case Type is Consultation
This filter combines those three conditions into an "exclusive" filter, which means that a record must match all three conditions. This can also be referred to as an "AND" statement:
"Show me all cases \ **WHERE** the open date is after January 1, 2023 \ **AND** the case lead is Matt Danner \ **AND** the case type is Consultation."
Available filter fields depend on the type of records being viewed. For example, Cases have different filter options from Evidence Items.
The operators available for each condition also depend on the field type.
Common filter types include:
* Date filters
* Text filters
* Multi-select filters
### Video Walkthrough
{% embed url="" %}
If the video does not render, [watch the Query Filter walkthrough on YouTube](https://www.youtube.com/watch?v=4QuM9crOmoQ).
{% endembed %}
### Adding a Filter
To add a filter, click on the "Add Filter" button above the table. This opens a searchable list of the fields you can filter on. Start typing to narrow the list to a specific field, or scroll to browse the available options.
Once you select a field, the filter displays an operator between the field and its value. This operator sets the parameters for the condition and changes based on the type of field selected.
The available operators are:
* **Date filters**: is after, is before, is between
* **Text filters**: contains, does not contain, is, is not
* **Multi-select filters**: is any of, is none of
You can add multiple conditions to narrow the data further.
### Filter Persistence
Filters in Monolith are persistent. If you navigate away from a table and return later, Monolith remembers the filters you previously applied.
Filters also carry through to table exports, so exported data reflects the active filters.
If a table appears to be missing records you expect to see, check whether a previous filter is still applied.
### Clearing Filters
To remove an individual filter, click the **X** on that condition.
Removing all conditions returns the table to its unfiltered view.
### AND/OR Logic on the Evidence Table
The Evidence Items table supports both **AND** and **OR** logic.
The default is **AND**. Use the filter logic control to switch between the two options.
The two options return different results:
* "AND" returns records that match every condition. A filter for case name and evidence type returns only the evidence items that match both.
* "OR" returns records that match any condition. A filter across two case names returns the evidence items from both cases in a single view.
Here is an example of an "OR" filter on the evidence table:
The above filter has two conditions:
* The Case Name is Smith Fraud Case
* The Case Name is Smith Agency
Because the filter uses "OR" logic, a record only needs to match one of the conditions to appear in the results:
"Show me all evidence items\ **WHERE** the case name is Smith Fraud Case\ **OR** the case name is Smith Agency."
{% hint style="info" %}
The selected **AND/OR** logic is persistent along with the filter conditions, so remember to clear or change it when you are finished with that view.
{% endhint %}
### Related Documentation
* [**Monolith UI Features**](/monolith/using-monolith/monolith-ui-features.md)
* [**Tables**](/monolith/using-monolith/monolith-ui-features/tables.md)
* [**Global Search**](/monolith/using-monolith/monolith-ui-features/global-search.md)
