Skip to main content

Columns

Introduction to columns​

This chapter contains the options for a column in the Subjects tab.

Columns tab on the Subjects screen* Overview of the Columns tab on the Subjects tab

Model settings​

Case type​

menu User interface > Subjects > tab Default/Variant > tab Columns > tab Form > tab Column

The Case type setting determines the capitalization of the text entered in this field. The available options are:

  • None
  • Upper case
  • Lower case
  • Initial caps
  • Proper case.

>Oracle and DB2 Indicium applies an UPPER function when sorting alphanumeric columns. This ensures consistent sorting results on case-sensitive data platforms but can slow down sorting on indexed columns. To speed up sorting, set the Case type of columns with uppercase data to Upper case. This skips Indicium's unnecessary UPPER function.

Type of column​

menu User interface > Subjects > tab Default/Variant > tab Columns > tab Form > tab Column

The Column type determines whether the field is presented as:

  • Editable
  • Readonly
  • Hidden.

The type can be defined differently in the grid and the form. However, the column defines the most unrestricted level.

note

The field added_by is set to readonly. It is possible to hide this in the grid. It is, however, not possible to make this normal in the form.

Copy​

Include in insert​

It is possible to configure a column so that a newly added row contains copied or consecutive information from the selected row. The following rules apply:

  • The column must be marked as Include in insert.
  • At least one marked column must be part of the current subject sorting.
  • Only the columns that are marked and part of the sorting are automatically filled in the new record.
  • The new record is inserted near the selected row.

The value is transferred from the selected row to the default procedure that determines the value in the new row.

Examples:

  • To add a new record to the same parent as the selected record, you must mark the column parent_node_id as Include in insert. The grid must be sorted by parent.
  • To add a new record with a successive order number, you must mark the column order_no as Include in insert. The grid must be sorted by order number.

To mark a column as Inlcude in insert:

menu User interface > Subjects > tab Default/Variant > tab Columns > tab Form > tab Column

  1. Select the checkbox Include in insert.

Include in copy​

menu User interface > Subjects > tab Default/Variant > tab Columns > tab Form > tab Column

A record can be copied easily with [Ctrl]+[Alt]+[Plus], but this shouldn't always be possible for all fields. For example, for identity fields, status fields, and trace columns. With Include in copy, you can indicate if a field needs to be transferred when copying a row.

Copy to clipboard​

menu User interface > Subjects > tab Default/Variant > tab Columns > tab Form > tab Column

If Copy to clipboard is selected, it is possible to copy rows from the grid with Ctrl + C.

In a data export, only columns for which Copy to clipboard is selected will be exported.

Exclude columns from logic​

Logic concepts are added to or removed from a subject in the menu User interface > Subjects > tab Default/Variants > tab Settings > tab Performance. For certain logic concepts, all columns are automatically added as parameters.

It is possible to exclude columns that are not required for specific logic concepts. The primary reason for excluding columns is to enhance performance. You can, for example, exclude HTML, RTF, or binary columns that may contain a lot of data but are not necessary in your code. Validations are in place to alert you to this situation.

To exclude columns from a logic concept:

menu User interface > Subjects > tab Default/Variants > tab Columns > tab Form > tab Performance

  1. Exclude columns that are not required for the following logic concepts:

See also: An overview of the available logic concepts.

note

In each default, the Modified by field is filled with the current user. However, for some tables, the default is empty. You cannot turn off the default because then, Modified by will no longer be filled, but you can turn off the unused fields. Fewer data will be transmitted during the execution, so the performance will increase.

Performance settings with Columns Performance settings for columns

Look-up​

For each field you can indicate whether a look-up has to be displayed and which reference it should use.

menu User interface > Subjects > tab Default/Variants > tab Columns > tab Look-up

  1. Select the Show look-up box to make the required fields available.

  2. It is indicated, as default with the look-up table, how this has to be presented. You can deviate from this for each column in field Reference.

  3. In field Look-up control you can indicate for each field whether the look-up presentation field has to be displayed with a combo box, a pop-up window or both. If the look-up table is displayed with a pop-up window, this can be the standard, but a variant can also be displayed.

note

When Show look-up is selected, but no Reference ID filled, then two (or more) references are created. Select the correct table or reference.

Look-up settings for the Tables Overview of the Look-up settings for the Tables

Was this article helpful?