Editing Data

Top  Previous  Next

If the Data Table Editor is in the editable mode, the values within the table may be changed.

Renderer and editor used to display and modify value in each cell depends to several factors.

Field type
Editor/Renderer specified in field declaration (that is a part of Table Format)
Availability of Selection Values declared for this field in Table Format
Whether the field value is NULL

Special Renderers/Editors

There are some special cases when non-standard editors are used:

NULL value renderer

If the field is declared as Nullable and its value is NULL, it is shown as <Not Set> in DTE. Click the cell to start editing and set a non-null default value for it.

note_warning-wt

You can reset the value back to NULL using the Remove value operation in the cell context menu.

ls_wd_dte_null

Selection Values Editor

If a field format contains selection values, editing is performed using a drop-down box:

ls_wd_dte_drop_down

If Extendable Selection Values flag is set in Field Format, any custom value can be typed in the text field next to the combo box if Other option is selected in it:

ls_wd_dte_drop_down_extended

Standard Renderers/Editor

String/Integer/Long/Float Fields

Integer, Long, String and Float values are edited in a normal text field:

ls_wd_dte_text_field

Boolean Fields

Boolean values are edited using checkboxes and are represented by Yes (for TRUE) or No (for FALSE) in read-only mode:

ls_wd_dte_boolean

Date Fields

Date and Date/Time values are edited using a Date Picker:

ls_wd_dte_date

Color Fields

Colors are selected using a Color Picker:

ls_wd_dte_color

Data Table Fields

Data Table fields (i.e. fields whose values are actually entire data tables) are edited by a nested Data Table Editor that appears on a separate page. The page opens when you click [...] button in the cell containing the embedded Data Table:

ls_wd_dte_datatable

Data Block Fields

Default Data Block editor allows to choose and save a file of any type from/to AggreGate Client's local file system:

ls_wd_dte_datablock

Additional Renderers/Editors

Date-only Editor

Date-only editor allows to specify a date using Date Picker, but time specification is not allowed:

ls_wd_dte_date

Time-only Editor

Time-only editor allows to specify a time in string form, but date cannot be selected:

ls_wd_dte_time_only

Bar Renderer

Bar renderer shows Integer, Long, Float and String values as percentages of maximum defined by Editor Options:

ls_wd_dte_bar_renderer

String values are converted to numbers on the best effort basis.

Period Editor

Period editor allows to specify a time period as a certain number of selected time units:

ls_wd_dte_period_editor

Password Editor

Password editor is very similar to the usual text area, but types characters are now shown:

ls_wd_dte_password_editor

Values cannot be copied from cells that use this editor.

Reference Renderer

Reference editor displays clickable references in blue underlined font:

ls_wd_dte_reference_renderer

Clicking on a reference initiates a server action.

Text Area

Long String values can be alternatively viewed and edited in a Text Area editor:

ls_wd_dte_text_area

Context and Context Mask Editors

String values corresponding to Context paths and context masks are specified using a Context Mask Selector component. It looks like a usual text field with a button on the right:

ls_wd_dte_context_mask

Pressing the [...] button opens an Entity Selector component to allow building the mask by pointing and clicking.

Sound/Image/File Editors

Data Block fields may contain images, sounds or generic files.

Files, sound and images are inserted into the cells using a File Selector:

ls_wd_dte_file

Images contained into the Data Table are displayed as a thumbnail (see previous screenshot). Clicking on a thumbnail opens a full-size image view.

Sounds can be played back by clicking on the Play button.