Custom Queries that have been configured with display columns can be configured to automatically group results by a display column.
Custom Written SQL Custom Queries cannot be configured for column grouping.
To configure Custom Query column grouping:
- Select a Custom Query in the OnBase Configuration module's Custom Query dialog box.
Click Group Columns. The Query Results Group Columns dialog box is displayed:
- Double-click a column in the Available Columns list, or select it and click Add.The selected column is displayed in the Selected Columns list.
- Repeat the previous step to add additional columns.
- Order the columns in the Selected Columns list by selecting them and using the Move Up and Move Down buttons.
- Click Save.