Versions Compared

Old Version 47

changes.mady.by.user Dina Baksheeva

Saved on

compared with

New Version 48

changes.mady.by.user Dina Baksheeva

Saved on

Key

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

The override functionality allows you to change the 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

Role required: admin.

Define a column override


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

Column Override form fields

FieldMandatoryDescription
Base TableY

Select a table containing the field to override.

TableYIn this dictionary field, you can select the child table that will be affected by overriding.
ColumnYIn 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 defines the column to be displayed instead of reference IDs.

Default Value Override

N

Select this checkbox to display 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 Reference Qualifiers field set, which overrides the reference qualifier for the field on the extended table.

FieldMandatoryDescription
ReferenceYSelect a table to which that the overriding column is refers to.
Reference Qualifier TypeN

Choose your Select the reference qualifier type. Available options:

  • Simple
  • Dynamic
Reference Qualifier ConditionNBuild a reference filter that will meet the necessary conditions.
Dynamic Reference QualifierN

Select the reference qualifier type from the dictionary.

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 Mandatory 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 Read Only checkbox that overrides the behavior when a user can change the field value in the extended table.

Override example

As an example, you may need to override a column for which the base table and the child table are the same. This can help as a workaround in case if you need to change some protected column options before they are changed correctly.

Warning

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

To perform such an override, fill in the fields in the column override form as described below:

  1. Base Table – select a base table.
  2. Table – select the same table.
  3. Column – select a column you need to override.
  4. Specify an attribute you are going to override. These column attributes can be overridden:
    1. Mandatory
    2. Read Only
    3. Display by Ref
    4. Reference Qualifier
    5. Dependent on Column
    6. Default Value
  5. Specify the new attribute value.
  6. Click Save or Save and Exit to apply the changes.

To be more specific, have a look at the The screenshot below . It shows how the Mandatory attribute , belonging that belongs to the IT Service column, related to the Agreement table, is overridden.

Define an override for choice fields

When creating a choice-like field, for example, Choice, it is recommended to set text values in the Value field to increase code readability. For example, it can be Incoming, or Active, or Failed values.

Regarding For task states, it is recommended to make values numericalnumeral. This can help with selection construction.

Table of Contents
absoluteUrltrue
classfixedPosition