The override functionality allows you to change 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.
Role required: admin.
Define a column override
- Navigate to System Settings → Column Overrides.
- Click New and fill in the fields.
- Click Save or Save and Exit to apply the changes.
Column Override form fields
| Field | Mandatory | Description | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Base Table | Y | Select a table containing the field to override. | |||||||||||||||
| Table | Y | In this dictionary field, you can select the child table that will be affected by overriding. | |||||||||||||||
| Column | Y | In this dictionary field, you can select a column to be overridden. | |||||||||||||||
| Display by Ref Override | N | Select 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.
Note that using overriding for read-only fields having dynamic default value may cause validation errors. As a workaround, you can set the read-only attribute for these fields with a client script using the SimpleForm methods. | |||||||||||||||
| Dependent on Column Override | N | Select this checkbox to display the Dependent on Column field.
| |||||||||||||||
| Reference Qualifier Override | N | Select the checkbox to display the Reference Qualifiers field set, which overrides the reference qualifier for the field on the extended table.
| |||||||||||||||
| Title Override | N | 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.
| |||||||||||||||
| Mandatory Override | N | Select the checkbox to display the Mandatory checkbox, which overrides whether the field on the extended table must contain a value to save a record. | |||||||||||||||
| Read Only Override | N | Select this checkbox to display the Read Only checkbox, which overrides whether a user can change the field value in the extended table. |
Override example
You need to override the Mandatory attribute for the Subject column in the Incident table. As the Incident table is a child one for the Task table, you need to specify the Task table in the Base Table field.
If you need to override some protected column options, specify one table as the base table and the child table. For example, the Task table has the protected Subject field. To override the Mandatory attribute, specify in the Base Table and Table fields the Task table, and select the Mandatory Override checkbox to make the Subject field optional.
When doing this, keep in mind that inaccurate changes may harm your system, so check twice, and verify on some testing instance firstly if possible.
Display by Ref Override
When the Display by Ref attribute is activated for a table column, it is deactivated for the other columns of this table. A column with the deactivated Display by Ref attribute can be protected, so it is not possible to roll back the "out-of-the-box" version.
To set Display by Ref for a custom field without affecting other columns, use the column override functionality. For example, you need to display a custom column Short information in the Incident table. By default, the display field on the Incident records is the inherited Display Name from the Task table. If you activate the Display by Ref attribute for the Short information column, the displayed field is configured only on the Incident records. For other Task tables (Problem, ITSM Task and etc.) there is no column with the active Display be Ref attribute.
To solve this problem, create an override record with the following values:
| Field | Value |
|---|---|
| Base Table | Incident |
| Table | Incident |
| Column | Short information |
| Display by Ref | true |
