DataSpell
 
2023.2
Shortcuts: Windows
Get DataSpell
You are viewing the documentation for an earlier version of DataSpell.
  1. Database Tools and SQL
  2. Data editor and viewer
  3. Cells

Cells

Last modified: 20 September 2023

Quick documentation

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

Object

Quick documentation view

Long text

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

Quick documentation view for long texts

Records

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

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

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

Quick documentation view for an image

Productivity tips

Manage default and NULL 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 CtrlAlt0D or NULL (CtrlAlt0N) 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 ( Window | Tool Windows | Database) , expand a data source tree.

  2. Right-click the table and select Modify Table CtrlF6.

  3. In the table structure tree, expand the columns node and double-click the column that you want to edit.

  4. In the Default Expression 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 Esc.

    Edit multiple cell values

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.

    Saving a LOB into a file

Copy and paste cells between tables

  • You can copy Ctrl0C and paste Ctrl0V 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.

Context menu

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.

Context menu of a cell in data editor

Action

Shortcut

Description

Edit

F2

Edit a value in the selected cell or cells. Alternatively, you can double-click the cell and start typing a value. The Edit command is unavailable for read-only values.

  • To open the auto-completion list, press CtrlSpace.

  • To confirm your changes, press Enter.

  • To cancel editing, press Esc.

the Open in Value Editor icon Open in Value Editor

ShiftEnter

Open in a separate value editor where you can edit data that is stored in the cell.

For more information about the editor, refer to Value editor.

the Show Aggregate View icon Show Aggregate View

Open the aggregate view where

For more information about the view, refer to Aggregate view.

the Revert Selected button Revert Selected

CtrlAlt0Z

Revert changes that you made to a cell value. You can select a scope of different cells and revert values in this scope.

For more information about reverting changes, refer to Submit changes to a database.

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

CtrlAlt0D

Set the current cell value to the default value or the value that you specified for the column.

For more information about viewing or set a default value, refer to Manage default and NULL values for a cell.

Set NULL

CtrlAlt0N

Set the current cell value to NULL.

For more information about allowing a NULL value, refer to Manage default and NULL values for a cell.

Load File...

Load a file into the field.

Save LOB…

For the cells that contain a binary large object (LOB). Save content of a cell into a file.

the Copy icon Copy

Ctrl0C

Copy selection to the clipboard.

the Copy Aggregation Result (SUM) icon Copy Aggregation Result (SUM)

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.

the Paste icon Paste

Ctrl0V

Paste the contents of clipboard into the table.

App general add Add Row

Add a row to the end of a table.

App general remove Delete Row

AltDelete

Delete selected rows.

App actions copy Clone Row

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

Go To

Navigation Bar

Jump to a navigation bar.

Database

Open the selected object in the Database tool window.

Related Symbol

Navigate to one of the related objects.

DDL

Open an object definition (DDL).

Row...

Ctrl0G

Jump to a specified row.

In the Go to Row dialog, specify the column and row number (use the column:row pattern).

All Related Rows

F4

Jump to a related record.

The command options are a combination of those for Go To | Referenced Rows and Go To | Referencing Rows. Read more about related data in Navigate between related data.

The command is not available if there are no related records.

Referenced Rows

Ctrl0B

Switch to a record that the current record references. If more than one record is referenced, select the target record in the popup that appears.

Read more about related data in Navigate between related data.

The command is not available if there are no referenced records.

Referencing Rows

AltF7

Use this command or shortcut to see the records that reference the current record. Read more about related data in Navigate between related data. In the popup that appears there are two categories for the target records:

  • First Referencing Row: all the rows in the corresponding table are shown, and the first of the rows that references the current row is selected.

  • Referencing Rows Only: only the rows that reference the current row are shown.

The command is not available if there are no records that reference the current one.

Filter by

Select a filter that you want to a column.

App actions search Full-Text Search…

CtrlAltShift0F

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

App client expui general download 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, refer to Sessions.

Quick Documentation

Ctrl0Q

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 and also see the related records by their foreign keys.