Table Property Editor

Certain properties in the system are Table Properties that can be modified in DataStudio using the Table Property Editor. These properties are identified and can be configured in DataStudio with the icon grid view32 icon.

For example, the Data Store Sets property on the Core object in the Object Properties panel:

Data Store Sets Table Property
Figure 1. Data Store Sets Table Property

Also, the Table Data property on the Table Holder object in the Create Object wizard:

Table Data Property - Create Object Wizard
Figure 2. Table Data Property - Create Object Wizard

Clicking on the icon grid view32 icon opens the Table Property Editor.

Table Data - Table Property Editor

In all Table Property Editors, the column contents can be filtered and the columns displayed can be selected.

Table Properties properties can be either Schema-less or Schema-defined type, these terms are described in more detail below.

  • Schema-less - the table is user defined (number of columns and rows etc.) and does not have requirements for specific column data types or names. This type is listed as "TableSchemaLess" on the corresponding property page. For example, the Table Data property property.

  • Schema-defined - the table is defined by the system and must match a defined schema with requirements for certain columns and the data types present in those columns (columns can therefore not be added or removed in the Table Property Editor). This type is listed as "TableSchemaBound" on the corresponding property page. For example, the Data Store Sets property.

In Schema-less table properties it is possible to add and delete columns and name/rename the columns as you wish. In Schema-bound table properties, the columns and column names are fixed by the schema.

Table Property Editor Menu Bar

The icons present in the menu bar of the Table Property Editor are described below.

The icons present may vary depending on the type of table property that is being edited (Schema-bound or Schema-less) and other factors (for example if Audit Trail is enabled).
Table 1. Table Property Editor Menu Bar Items
Element Shortcut Action

icon delete

-

Empty Grid

icon tablepaste 64

-

Paste without headers

icon dashboard insert row

-

Add row

icon dashboard delete row

-

Delete row

icon dashboard insert column

-

Add column (only available for Schema-less table properties)

icon dashboard delete column

-

Delete column (only available for Schema-less table properties)

icon mass config import

-

File import

icon export

-

File export

icon refresh 02

F5

Refresh

Object

-

The object to which the table property belongs

Config version

-

Version number for the property

Context Menu options

Right clicking in the table section of the editor offers different options from the context menu depending on whether it is a Schema-less or Schema-bound table property.

Table 2. Table Property Editor Menu Bar Items
Context Menu option Sub-option Description

Cut

-

Cut the selected element(s) and put it on clipboard (not available for Schema-bound table properties).

Copy

-

Copy the selected element and put it on clipboard.

Copy with headers

-

Copy the selected element, including headers, and put it on clipboard.

Paste

-

Paste the clipboard content to the selected element(s).

Set null

-

Sets the selected element value to null (not available for Schema-bound table properties).

Move

To Top

Moves the selected row to the top of table.

Move

Up

Moves the selected row up one row in the table.

Move

Down

Moves the selected row down one row in the table.

Move

To Bottom

Moves the selected row to the bottom of table.

Insert

Above

Insert a new row above the currently selected row.

Insert

Below

Insert a new row below the currently selected row.

JSON Viewer

-

Opens the selected element in the JSON Viewer.

Show as ISO 8601 Date/Time

-

Displays the selected element number value (for example, a POSIX/UNIX epoch timestamp) to a ISO 8601 Date/Time format that can be copied to the clipboard