Data Editor preferences
You can fully customize how data is displayed and edited in the Data Editor.
Use these settings to change the appearance, behavior, formatting, and handling of different data types.
Tip
You can configure Data Editor preferences directly in the configuration file, without starting the application. For details, see how to manage preferences via config files.
All preferences are available at Window -> Preferences -> Editors -> Data Editor.
Customize general behavior of the Data Editor::
| Setting | Description |
|---|---|
| ResultSet fetch size | Number of rows fetched from the database in one batch. Affects performance |
| Auto-fetch next segment | Automatically loads the next data segment when the current one is fully processed or viewed |
| Refresh data on next page reading | Refreshes the data when moving to the next page |
| Use SQL to limit fetch size | Modifies the source SQL query to scroll through or limit results. This is typically achieved using the LIMIT/OFFSET SQL clause |
| Automatic Row Count | Counts the number of rows only once when you first open the data viewer. It doesn't update automatically after that. |
| Ordering mode | Specifies how sorting is applied to query results: - Adaptive (default) chooses the best strategy depending on context;- Always on client sorts data after it's fetched;- Always on server enforces sorting in the SQL query |
| Default ordering | Specifies the default ordering of records. By default, the ordering is not changed, and the result set is displayed in the order in which it was fetched. Otherwise, this option has no effect if the table doesn't have a primary key. Please note that setting this option may result in an additional query to the database because information about constraints is unavailable beforehand |
| Query cancel timeout (ms) | Defines the duration (in milliseconds) the system waits before cancelling a non-responsive query |
| Always use subselect for filters | Forces the usage of subqueries when applying filters to the data |
| Use column names instead of column labels | Prioritizes column names over column labels when referencing data |
| Use fetch-size | Overrides the default JDBC fetch size. This is an advanced option and should only be changed if you know how the driver handles data fetching. |
| Use all table columns as a key upon saving | Forms a virtual composite key using all table columns for data saving. If set to true, this will determine the action taken if a key element is missing. If set to false, no action will be taken when a key element is missing |
| Disable data editing | Prevents data modification when a primary key is absent. This setting defines the action taken when the assumed primary key is missing |
| Keep open cursors in SQL editor | Closes the result set after a selection. To view a cursor column value, the option should be enabled |
| Insert new rows after current | Places newly inserted rows immediately following the currently selected row |
| Refresh after update | Automatically refreshes the data after making changes |
| Use navigator filters | Employs filters in the navigator to refine the displayed data |
| Activate advanced datetime editor | Enables the advanced datetime editor in the Data editor |
| Show confirmation before save | Displays a prompt asking for a confirmation before saving changes |
| Show errors in a dialog | Presents error messages in a separate dialog box |
| Mark occurrences of the selected cell's value | Highlights instances of the selected cell's value within the data set |
| Show images in web browser | Controls whether image data (e.g., PNG, JPEG stored as BLOBs) is displayed in the Value panel using an embedded browser. When disabled, images are shown as raw binary or hex. |
Appearance¶
Customize how data looks in different modes.
| Setting | Description |
|---|---|
| Switch to Record/Grid mode on single/multiple row(s) | Allow to switch between Record mode and Grid mode when dealing with single or multiple rows. When set to true, the system will automatically switch modes based on the number of rows selected (Record mode for a single row, Grid mode for multiple rows) |
| Show filters panel in single tab mode | Shows the filters panel when using a single-tab layout in the Data Editor |
| Show column description in header | Displays the description for each column in the header |
| Calculate column width by cell values | Adjusts the width of each column based on the content of its cells |
| Show connection name in status | Displays the name of the connection in the status section |
| Visualize complex columns | Enables the visualization of complex columns (such as objects, structures and arrays) |
| Right-justify numbers | Allows right-justify numbers |
| Right-justify date/time values | Aligns date and time values to the right side of their respective cells or columns |
| Enable auto-completion in data filter text | Activates the auto-completion feature in the data filter text field |
Grid¶
Configure Grid view options.
Grid appearance¶
| Setting | Description |
|---|---|
| Mark odd/even rows | Marks odd and even rows in the grid |
| Colorize data types | Colorizes data types in the grid |
| Show column type icons | Displays icons representing the data types of each column |
| Show attribute filters | Enables the display of attribute filters in the grid |
| Show attribute ordering | Shows asc/desc order icon in column header |
| Show booleans as checkboxes | Represents boolean values in the grid as checkboxes |
| Show whitespace characters | Displays whitespace characters within the grid |
| Show column ordering | Shows column order in the column headers |
| Value display format | Controls how values are shown in the Value panel: - Display (default) shows formatted read-only values,- Editable shows raw editable content- Database native shows the exact value as stored in the database. |
| Max auto size column % | Determines the maximum percentage of width a column can occupy |
Grid behavior¶
| Setting | Description |
|---|---|
| Highlight rows with selected cells | Enables the highlighting of entire rows when one or more cells are selected |
| Smooth scrolling | Enables smooth horizontal scrolling within the grid |
| Toggle boolean on click | Allows boolean values to be toggled with a single click |
| Select next cell after inline edit | After completing the inline edit, a cell on the next row will be selected, SHIFT+ENTER can be pressed to select the cell on the next column |
| Double-click behavior | Defines the action taken when a cell is double-clicked (None, Editor, Inline editor, Copy selected cell, Paste cell value into editor) |
| Row color batch size | Number of consequent rows with the same background color |
JSON¶
Collapse large JSON objects or arrays to simplify viewing.
| Setting | Description |
|---|---|
| Collapse objects that have more members than | Specifies the max amount of object members before collapsing |
| Collapse arrays that have more elements than | Determines the max amount of array element before collapsing |
| Collapse objects that have deeper nesting than | Determines the max nesting of an object before collapsing |
Info
Read more on working with JSON.
Plain text¶
Adjust text data formatting.
| Setting | Description |
|---|---|
| Tab size | Determines tab size |
| Maximum column length | Determines the maximum length of a column’s content |
| Value display format | Controls how values are shown in the Value panel: - Display (default) shows formatted read-only values,- Editable shows raw editable content- Database native shows the exact value as stored in the database. |
| Show NULLs | Enables the display of NULLs |
| Show line numbers | Enables the display of line numbers |
| Leading delimiter | Enables trailing delimiter |
| Trailing delimiter | Enables trailing delimiter |
| Top delimiter | Enables top delimiter |
| Bottom delimiter | Enables bottom delimiter |
| Extra spaces | Enables extra spaces |
Binary editor¶
Configure how binary and LOB data is handled.
| Setting | Description |
|---|---|
| Open in separate editor | Opens separate string editor instead of dialog |
| Binary data formatter | Determines the format in which binary data is displayed |
| Binary editor | Enables to change the binary Data Editor (EDITOR or PANEL) |
| Maximum length of binary strings | Determines the maximum length of binary strings |
| Maximum LOB length to keep in memory | Determines the maximum length of LOB (Large Object) data that will be kept in memory |
| String encoding | Allows to specify the character encoding used when interpreting binary data as strings |
| Cache CLOB values | Enables caching of CLOB (Character Large Object) values to reduce repeated reads |
| Cache BLOB values | Enables caching of BLOB (Binary Large Object) values for better performance |
| LOB cache max size | Sets the maximum total size of cached LOB data |
| Edit LONG columns as LOBs | Treats LONG column types (e.g. in Oracle) as LOBs for consistent editing |
Maximum text editor content length (KB) |
Limits the size of LOB content (in KB) shown in the text editor |
| Commit session on value edit apply | Automatically commits the transaction after applying edited scalar values |
| Commit session on content edit apply | Automatically commits the transaction after editing and saving LOB or large content fields |
Data formats¶
Change how numbers, dates, and times are formatted in the Data Editor.
Info
For details, see Managing data formats.
Dictionaries¶
Define how Team Edition recognizes description columns.
| Setting | Description |
|---|---|
| Keywords for dictionary description columns | Defines which column names are considered descriptive or label columns |
| Maximum amount of elements on a dictionary panel page | Determines how many dictionary values are shown per page |
GIS viewer¶
Adjust spatial data viewer settings.
| Setting | Description |
|---|---|
| Default SRID | Sets the default spatial reference system (e.g. 4326) |
| Maximum objects per viewer | Limits how many spatial objects are shown at once |
| Minimum zoom level | Prevents zooming too far out on spatial visualizations |