Override functionality allows you to change column values and attributes in child tables extended from base tables. 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.

Role required: admin.

How to define a column override


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



FieldMandatoryDescription
Base TableY

Select a table containing the field to override.

TableYSelect the child table that will be affected by overriding.
ColumnYSelect a column to be overridden.
Display by Ref OverrideNSelect the 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 the checkbox to display the Default Value field.

FieldMandatoryDescription
Default ValueN

Enter the default value that will override the original one.


Note that using overriding for read-only fields having dynamic default value may cause validation errors.


Dependent on Column ID OverrideN

Select the 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. To override the reference qualifier for the field on the extended table, fill in the fields appeared.

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

Choose your reference qualifier type. Available options:

  • Simple
  • Dynamic.
Reference Qualifier ConditionNBuild a reference filter with necessary conditions.
Dynamic Reference QualifierN

Select the dynamic reference qualifier 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. To override the field title in the extended table, define the new title. 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 OverrideN

Select the checkbox to display the Mandatory attribute.

FieldMandatoryDescription
MandatoryNSelect the checkbox, so the field on the extended table must contain a value to save a record.


Read Only OverrideN

Select the checkbox to display the Read Only attribute, which overrides whether a user can change the field value in the extended table.

FieldMandatoryDescription
Read Only NSelect the checkbox, so the field value cannot be changed in the extended table.  



Override example


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

When doing this, keep in mind that inaccurate changes can harm your system, so double-check, and, if possible, verify first on some testing instance.

To perform such override, fill in the fields 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. The following 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 new attribute value.
  6. Click Save or Save and Exit to apply changes.

The screenshot below shows the Mandatory attribute overriding of the IT Service column related to the Agreement table.

Defining an override for choice fields


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

As for task states, it makes sense to make values numeric; this can help with selection construction in code.