Versions Compared

Old Version 16

changes.mady.by.user Igor Shakhbazyan

Saved on

compared with

New Version Current

changes.mady.by.user Dina Baksheeva

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Override The override functionality allows you to change the overriding column value and attributes in the child tables extended from the base table.   For example, a column override changes the default value of the Impact field from Low in the Task table to Medium in the Incident table.

Tip
Note

Please keep in mind that column override is available only for tables having the is_extendable property equal to TRUE.

Role required: admin.

How to define

To create a column override, complete the following steps:

  1. Navigate to to System Definition → Settings → Column Overrides.
  2. Click New and fill in the fields.
  3. Click Save or Save and Exitexit to apply the changes.

Column Override form fields

Select this checkbox to display the Dependent on column field, which overrides the field on which the current field depends.
FieldMandatoryDescription
Base TabletableY

Select a In this dictionary field, you can select the uppermost (in terms of inheritance) table containing the field to override.

TableYSelect In this dictionary field, you can select the child table that will be affected by overriding.
ColumnYSelect In this dictionary field, you can select a column to be overridden.
Display by ref overrideNSelect this checkbox if you need to override the Display by ref setting which is responsible for what column will be displayed instead of reference idsto use the values of the Column as the Display Name in Reference fields that refer to the Table.

Default value override

N

Select this checkbox to display

the Default Value field, which overrides the default value for the field on the extended table.After selecting this checkbox, the Default Value field appears. 

the Default value field.

FieldMandatoryDescription
Default ValueN

Enter the default value that will override the original one

. 

.


Note

Note that using the override functionality for read-only fields that have the dynamic default value may cause validation errors.

As a workaround, you can set a read-only attribute for these fields with a client script using the SimpleForm methods.


Dependent on column overrideN

Select this checkbox to display the Dependent on column field.

FieldMandatoryDescription
Dependent on column NDefine the column on which the current field depends.


Reference qualifier overrideN

Select the checkbox to display the the Reference Qualifiers fieldset field set, which overrides the reference qualifier for the the reference qualifier for the field on the extended table.

Reference - in this field, select a table to which
FieldMandatoryDescription
ReferenceYSelect a table that the overriding column
is referenced
refers to.
Reference qualifier type
- choose your
N

Select the reference qualifier type

, is it Simple or Dynamic.

. Available options:

  • Simple
  • Dynamic
Reference qualifier condition
- build
NBuild a reference filter that will
fit
meet the necessary conditions.
Dynamic reference qualifier
- if you have chosen the Dynamic type from the choice menu above, then select the appropriate one from the dictionary.
Mandatory override
N

Select the reference qualifier type from the table.

This field appears when the Reference qualifier type field value is Dynamic.


Title overrideN

Select the checkbox to display the Title field, which overrides the field title in the extended table. That is, a child table will inherit the properties of the parent table's column, but the title will be different.

FieldMandatoryDescription
TitleNEnter a new title of the column.


Mandatory overrideNSelect the checkbox to display the the Mandatory field, which overrides whether checkbox that overrides the behavior when the field on the extended table must contain a value to save a record.
Read - only overrideN

Select this checkbox to display the the Read -only field, which overrides whether only checkbox that overrides the behavior when a user can change the field value on in the extended table.

Dependent on column ID override

Override example

For example, you need to override the Email field in the User (user) table. The field should be non-mandatory and have a new title Work mail in the Employee (employee) table. At the same time, the Email field on the User form must remain mandatory with the same title.

To create the appropriate override, complete the following steps:

  1. Create an override entry via the navigator menu or the Related List of the Email column record.
  2. In the Table field, select the level at which the override will be performed. All tables containing the column are available for the selection.
  3. Select the Mandatory override checkbox and specify a new mandatory value. In this case, leave the Mandatory checkbox clear.
  4. Select the Title override checkbox and enter a new title value in the Title field.
  5. Save the record.
Warning

When doing so, keep in mind that incorrect changes may harm your system, so double-check the changes and verify them on a test instance if possible.


Table of Contents
absoluteUrltrue
classfixedPosition