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:

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:

"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."

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