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.
How to define a column override
- Navigate to {your_instance_url}/record/sys_db_column_override;
- Click New, fill in the fields, and click Save.
Column Override form fields
| Field | Description |
|---|---|
| Base Table | Select the uppermost (in terms of inheritance) table that contains the field to override. To browse the tables, please navigate to System Definition → All Tables. |
| Table | Select the table to which the override applies. |
| Column | 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 column displaying on lists. |
Default value override | Select this checkbox to display the Default Value field, which overrides the default value for the field on the extended table. |
| Default value | Enter the default value that will override the original one. This field appears if the Default value override checkbox was selected. |
| Reference qualifier override | Select the checkbox to display the Reference qualifier fieldset, which overrides the reference qualifier for the field on the extended table.
|
| Mandatory override | Select the checkbox to display the Mandatory field, 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 the Read-only field, which overrides whether a user can change the field value on the extended table. |
| Dependent on column ID override | Select this checkbox to display the Dependent on column field, which overrides the field on which the current field depends. |
