Dataviews
A dataview is a configurable report that surfaces data from the Docwize database or external sources. Dataviews are accessed from the Reports & Interfaces tab in the Explorer sidebar. Each dataview opens as a tab in the main content area.
Dataviews can be configured to show editable columns, apply colour rules, and link to underlying documents via drilldowns. Custom dataviews are built using the Query Builder.
What you can do
- View and filter tabular data from the Docwize database or external sources
- Sort by one or more columns
- Search across visible columns
- Export data to Excel
- Drill down into underlying documents
Opening a dataview
In Explorer, switch to the Reports & Interfaces tab. Dataviews are listed under named groups. Click the arrow-out icon (↗) next to a dataview name to open it as a tab.
Dataview toolbar
When a dataview is open, the following controls appear:
| Control | Description |
|---|---|
| Export | Exports the dataview data. |
| Detach Previews | Detaches the document preview panel from the dataview. |
| Grid view icon | Switches the dataview to a compact grid layout. |
| List view icon | Switches the dataview to a list layout. |
| Filter icon | Opens the filter panel for the dataview. |
| ⋮ (more options) | Opens a menu with additional options. Currently includes Export to Excel. |
| Search | Filters rows by keyword across visible columns. |
Column headers
Each column header shows the column name and two controls:
| Control | Description |
|---|---|
| ▼ (filter icon) | Opens a filter for that column. |
| :: (sort icon) | Sorts the dataview by that column. Click once for ascending, click again for descending. Hold Shift and click a second column header to sort by multiple columns simultaneously. |
Rows
Each row in a dataview shows:
| Element | Description |
|---|---|
| :: (drag handle) | Appears on the left of each row. |
| Checkbox | Selects the row. Use row checkboxes for multi-select actions. |
| Document type icon | Shows the file type of the linked document (for example, PDF or Word). |
| Data cells | The values for each configured column. |
| Orange link (drilldown) | Where configured, clicking an orange number or link opens a filtered view of the underlying documents for that row. |
Row count is shown at the bottom right of the dataview and reflects the total number of rows returned.
Drilldowns
Dataviews can be configured to allow users to drill into underlying documents. Where a column contains an orange link (typically a number), clicking it opens a filtered view of the documents that contribute to that value.
Example: dataview with drilldown links
Dataview settings
Users with the appropriate permissions can access dataview settings via the gear icon (⚙) next to the dataview name in the Explorer sidebar, or within the dataview itself.
Dataview Settings dialog
| Category | Setting | Description |
|---|---|---|
| Settings | Notes | Adds a description to the dataview — for example, its purpose or when it was created. |
| Add Order By | Configures default sort order (ascending or descending on a specified field). | |
| Cache Settings | Sets whether the dataview is cacheable, and the cache duration in seconds. | |
| Column Formatting | Customises column display. Click + to add formatting rules. | |
| Coloring Rules | Applies colour coding based on conditions — for example, Status = Complete shows green. Click Add Color Config to create a rule. |
Creating dataviews
Dataviews are built by administrators using the Query Builder.
Related pages
- Explorer — overview of the Explorer module
- Interfaces — multi-component views that can include dataview-style grids alongside charts
- Query Builder — how administrators build and configure dataviews