Custom Queries that have been configured with display columns can be configured to allow a user to filter the Custom Query results set by criteria in various display columns.
Custom Written SQL Custom Queries cannot be configured for column filtering.
To configure Custom Query column filtering:
- Select a Custom Query in the OnBase Configuration module's Custom Query dialog box.
- Click Filter Columns.
The Query Results
Filter Columns dialog box is displayed:
- Double-click a column in the Available Columns list, or select it and click Add.
The Filter Type Configuration dialog box is displayed:
Select one of the following Filter Types:
This filter is displayed as a list of values with the number of instances of that value.Tip:
Use an instance filter for any data which has a narrow range of discrete values, such as a Keyword Data Set.Note:
Instance filters are only available for alphanumeric Keyword Type Data Types, as well as the Document Name, Author, Document Type, Workflow Queue, Note Contents, and Note Type columns.
This filter is displayed as a text box.Note:
Text filters are available for all Keyword Type Data Types and columns.
This filter is displayed as a slider, with two thumbs beneath a sparkline.Tip:
Use a pinch filter for values with a moderate to large range, or when the user is unsure of specific range boundaries. Pinch filters should not be used for high precision or a small range of values.Note:
Pinch filters are only available for non-alphanumeric Keyword Type Data Types, as well as the Document Date, Date Stored, Document Handle, Author ID, Arrival Time, and Note Count columns.
- Click Save.
- The selected column is displayed in the Selected Columns list.
- Repeat steps 4 and 8 to add additional columns.
Order the filters in the Selected Columns list by selecting them and using the Move Up and Move Down buttons.
The order in which filters appear in the Selected Columns list is the order in which they will appear in the Unity Client 's Custom Queries pane.
- Click Save.