Override functionality allows 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.
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 a column override
Navigate to System Definition → Column Overrides.
Click New and fill in the fields
Click Save or Save and Exit to apply changes.
Column Override form fields
Field
Description
Base Table
In this dictionary field, you can select the uppermost (in terms of inheritance) table containing the field to override.
Table
In this dictionary field, you can select the child table that will be affected by overriding.
Column
In this dictionary field, you can select a column to be overridden.
Display by ref override
Select this checkbox if you need to override the Display by ref setting which is responsible for what column will be displayed instead of reference ids.
Default value override
Select this checkbox to display theDefault Valuefield, which overrides the default value for the field on the extended table.
After selecting this checkbox, the Default Value field appears. Enter the default value that will override the original one.
Reference qualifier override
Select the checkbox to display theReference Qualifiers fieldset, which overrides thereference qualifierfor the field on the extended table.
Reference - in this field, select a table to which the overriding column is referenced to.
Reference qualifier type - choose your reference qualifier type, is it Simple or Dynamic.
Reference qualifier condition - build a reference filter that will fit 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
Select the checkbox to display theMandatoryfield, which overrides whether the field on the extended table must contain a value to save a record.
Read-only override
Select this checkbox to display theRead-onlyfield, which overrides whether a user can change the field value on the extended table.
Dependent on column ID override
Select this checkbox to display theDependent on columnfield, which overrides the field on which the current field depends.
