# Query Filter

The Query Filter is a system used throughout Monolith that allows you to create complex queries for data using a simple user interface.

The filter uses conditional logic to construct a query that will result in records that match the filter.

Example:

<figure><img src="https://2683670198-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCD1iskOdIm8E2TpCd9iZ%2Fuploads%2FplcKxQKl70B1n5tT0RAI%2FQuery%20Filter.png?alt=media&#x26;token=c8477ea7-4332-4f9e-92a6-1b8649e6d219" alt=""><figcaption></figcaption></figure>

The above filter has three conditions:

* 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:

<mark style="color:green;">"Show me all cases</mark> \ <mark style="color:green;">**WHERE**</mark> <mark style="color:green;"></mark><mark style="color:green;">the open date is after January 1, 2023</mark> \ <mark style="color:green;">**AND**</mark> <mark style="color:green;"></mark><mark style="color:green;">the case lead is Matt Danner</mark> \ <mark style="color:green;">**AND**</mark> <mark style="color:green;"></mark><mark style="color:green;">the case type is Consultation."</mark>

The query filter options are defined based on the type of records that your are filtering.  So case data will have different filter options from evidence data.

Each condition within the filter may have different options as well.

The following condition filters are available"

* Date filters
* Text Filters
* Multi-select Filters