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
All of the standard tables in Monolith have several features to help users find and export data quickly.
To sort rows within a Monolith table, click the column header. Monolith will then sort the data based on that column.
Filtering a table is handled by the Monolith Query Filter, which is discussed here.
Table columns can be resized by hovering over the edge of the column that you wish to resize. Then just click and drag the column to the desired width.
Columns can be reordered by clic and dragging the column header to the desired position in the table.
Columns can be hidden or shown by using the "Column Selector" which is a button that is typically located in the top right menu of a table. This button has an icon that looks like 3 vertical columns.
Most tables in Monolith are "paginated" which means that only a certain number of records are loaded at one time. The default is 20, but you can use the page size selector to increase that amount to 100.
The table may also have a Page Selector that allows you to navigate to specific pages within the table data.
Table data may be searched if there is a search box associated with it. To search the table data, just enter your search string into the text box and press enter.
Most tables can be exported to a Microsoft Excel document. to export the table data, use the table export button which is usually located in the top right table menu.
The table export is a "What you see is what you get" export, which means that the only columns and rows included in the export are based on the filters and table orientation.
All pages are included with the export.
