DataSpell 2021.3 Help

Cells

You can find all basic actions for working with cells under the context menu. To call the context menu, right-click the cell that you want to modify. The following table lists all the actions.

Action

Shortcut

Description

Edit

F2

Edit a cell value. Alternatively, select a cell and start typing a new value. To confirm your changes, press Enter.

Maximize

Shift+Enter

Open a separate value editor where you can edit data that is stored in the cell. Also, you can enable soft wrap in the editor by clicking the Toggle Soft-Wrap button the Toggle Soft-Wrap button.

If you store one-line JSON in a cell, you can click the Toggle Formatting icon. This action formats one-line XML and JSON strings.

Expand a cell for editing

Also, you can preview images in the value editor.

Note that to leverage the performance issues, the default LOB size is limited to 1024 bytes. It means that only 1024 bytes are loaded to the table editor. To increase this size and view larger images, open settings by pressing Ctrl+Alt+S, navigate to Tools | | Data Editor and Viewer, and change the value of the Maximum number of bytes loaded per value option.

preview images in the value editor

Show Aggregate View

Open the aggregate view. In the aggregate view, you can select values of multiple cells and get a single summary value.

Console.TableResult.AggregateView

Click the gear icon on the toolbar of the Aggregates tab to view, enable, and disable aggregates. Also, you can create your own aggregate scripts. Bundled scripts are located in Scratches and Consoles | Extensions | data | aggregators. To add your own aggregator, place your script to the aggregators directory.

Aggregate scripts and extractors

Revert Selected

Ctrl+Alt+Z

Restore the previous cell value.

Set Highlighting Language

Select a language that the IDE should use to highlight data in a cell.

Change Display Type

Select how the IDE should display binary data in the column. 16-byte data is displayed as UUID by default.

Set DEFAULT

Ctrl+Alt+D

Set the current cell value to the default value. For more information about how to set a default value, see Set default values for a cell.

Set the default value

Set NULL

Ctrl+Alt+N

Set the current cell value to the NULL value. For more information about how to set a default value, see Set default values for a cell.

Set the NULL value

Load File…

Upload a file into the field. Right-click a cell and select Load File….

Save LOB…

Save content of a cell into a file. Works on cells with binary and text data.

Copy

Ctrl+C

Copy a cell value to the clipboard.

Copy Aggregation Result

Copy a summary value for a range of cells. By default, DataSpell copies the SUM aggregation result. To change the default, right-click the status bar and ensure that the Aggregator option is selected. Click the aggregator widget on the status bar and select the aggregator to use as default.

grid.aggregator.widget.display.name

Paste

Ctrl+V

Paste copied contents from the clipboard.

Add Row

Add a row to the end of a table.

Delete Row

Alt+Delete

Delete selected rows.

Clone Row

Create a duplicate of the selected row and adds the duplicate to the end of a table.

Quick Documentation

Ctrl+Q

Show information about selected objects. For different database objects, Quick Documentation shows corresponding information. For example, for a group of cells, you will see a summary for the selection. You can preview it in a regular or in a transposed view.

Go To

Show a navigation submenu. From this submenu, you can navigate to the following entities:

  • Navigation Bar: jump to a navigation bar.

  • Data:

  • Database: open the selected object in the Database tool window.

  • Related Symbol…: open an object definition (DDL).

  • DDL: open an object definition (DDL).

  • Row…: specify a row number and go to this row.

  • All Related Rows: display both referenced and referencing rows. You can select a row to which you want to navigate.

    All Related Rows
  • Referenced Rows: go to rows that are referenced by the current object.

  • Referencing Rows: go to rows that are referencing the current object.

Filter by

Select a filter that you want to a column.

Full-Text Search…

Ctrl+Alt+Shift+F

Open a search window where you can search for data in your database or a group of databases.

Search for data in databases

Export Table to Clipboard

Copy the whole table to the clipboard. This action does not depend on Limit page size to setting.

Switch Session (your_current_session_name)

Open a window to select another session or create a new one. For more information about sessions, see Managing connection sessions.

Using the quick documentation view

The quick documentation view provides details about values in the selected cell or cells. For example, if a cell contains long text, you will see the whole text. If a cell contains an image, you will see a preview of the image. Also, you can see records that are referenced in the current record as well as the records that reference the current one.

Object

Documentation view

Long text

If a cell contains long text, you will see the whole text.

Quick documentation view for long texts

Image

If a cell contains an image, you will see a preview of the image.

Quick documentation view for images

Also, you can

Records

The quick documentation view for records displays records that are referenced in the current record and records that reference the current one.

Quick documentation view for an image

You can switch to a transposed view. In the transposed view, rows and columns are interchanged.

To switch to the transposed view, click Transposed View. For more information about the transposed view in tables, see Transpose a table.

Transposed view for records

Productivity tips

Set default values for a cell

When a new row is created and no values are specified for some of the cells, those cells are filled with their respective default Ctrl+Alt+D or NULL (Ctrl+Alt+N) values.

When you set default values for a cell, you can use corresponding actions from the context menu (Set DEFAULT and Set NULL).

  1. In the Database tool window (View | Tool Windows | Database), expand a data source tree.

  2. Right-click the table and select Modify Table Ctrl+F6.

  3. On the Columns tab, double-click the column that you want to edit.

  4. In the Default field, specify the default value of the cell in the column. To allow NULL values, clear the Not null checkbox.

Edit multiple cell values simultaneously

  1. Select a range of cells that you want to edit.

  2. Start typing a new value. The changes are applied to all the selected cells.

  3. To confirm the value, press Enter. To cancel editing, press Escape.

Saving a LOB into a file

You can save a binary large object (BLOB or LOB) from a cell into a file.

  1. Right-click the cell that contains the LOB and select Save LOB.

  2. In the save dialog, specify the name and location of the file and click OK.

Copy and paste cells between tables

  • You can copy Ctrl+C and paste Ctrl+V selected cells and ranges of cells - within the same table or from one table to another one. When pasting, DataSpell converts data types automatically if and as necessary.

Last modified: 29 September 2021