When connecting to data sources that returned data structured as documents (typically JSON or BSON), there are several ways to view the data. Instead of the regular grid, you get a panel that contains three different views, where you can choose the one that serves your purpose best.
TODO: Extend/replace screenshots
We should first settle on what sample data to use - current screenshots are placeholders.
Click the nested view button (A) to show a view that organizes data in expandable column header groups based on the data structure. You can expand/collapse headers (B) to focus on the data you are interested in, either by double-clicking the header or via the popup menu (right-click the header). Select a cell in the grid (C) to show the details as a key-value tree representation in the right-hand panel. Click any cell in the tree to show its details in the text panel below (D).
Choose how to show the details in the tree view:
- Collapsed Rows (E)
Choose to see collapsed rows as the number of elements it contains, the JSON representation (abridged), or nothing (blank).
- Scope (F)
Choose if you want to see the entire row, all columns belonging to the same root column group, or all columns belonging to the closest singular column group. If you choose the closest group, the actual group varies with the structure; the root of the tree will be the closest column group that is not part of an array.
- Auto Expand (F)
Choose to automatically expand the tree to show the level of the cell you selected.
- Auto Filter (G)
Choose to filter on the selected cell, the tree will only show the cell you selected. If the cell is part of an array, you will see all occurrences of the cell.
In the text panel (D), a leaf cell is presented as plain text and you can choose to word-wrap the text to make it readable, whereas a container cell (a JSON structure) is automatically formatted based on the JSON syntax. You cannot word-wrap the formatted data.
In both cases, you can view the hexadecimal representation of the data.
Showing complex structures in the nested view may be slow since it places a heavy load on the algorithm for calculating row and column sizes.
You may have to confirm the action before opening this view on some data.
Click the tree view button (A) to show the data in a vertical fashion where each row represents an element. This view is the most efficient way to browse complex data since the structure adapts to each row. Like the details tree in the nested view, you can expand/collapse the rows (B), choose how to present collapsed rows (C), and select a cell in the tree to show the contents of the cell in the text panel to the right (D).
The text view shows the raw data as returned by the database, one row for each document. You can choose to format the data based on JSON syntax.
A document data set is often larger than an average relational table; loading a complete data set may consume a lot of memory, and formatting/unformatting a large data set may be slow.