Page History

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

How to define

To create a column override, complete the following steps:

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

Column Override form fields

Field	Mandatory	Description
Base

Table

table	Y	Select a table containing the field to override.
Table	Y

In this dictionary field, you can select

Select the child table that will be affected by overriding.
Column	Y

In this dictionary field, you can select

Select a column to be overridden.

Display by

Ref Override

ref override

N

Select

the

this checkbox

if you need to override the Display by Ref setting, which defines the column to be displayed instead of reference IDs.

to use the values of the Column as the Display Name in Reference fields that refer to the Table.

Default value override

Default Value Override

N

Select

the

this checkbox to display

the

the Default

Value

value field.

Field	Mandatory	Description
Default Value	N	Enter the default value that will override the original one.

Note

Please note

Note that using

overriding

the override functionality for read-only fields

having

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 ID Override

column override

N

Select

the

this checkbox to display

the

the Dependent on

Column

column field.

Field	Mandatory	Description
Dependent on

Column

column

N

Define the column on which the current field depends.

Reference

Qualifier Override

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.

Field	Mandatory	Description
Reference	Y	Select a table

to which

that the overriding column

is referenced

refers to.

Reference

Qualifier Type

qualifier type

N

Choose your

Select the reference qualifier type. Available options:

Simple
Dynamic

.

Reference

Qualifier Condition

qualifier condition

N

Build a reference filter

with

that will meet the necessary conditions.

Dynamic

Reference Qualifier

reference qualifier

N

Select the

dynamic

reference qualifier type from the

dictionary

table.

This field appears when the Reference

Qualifier Type

qualifier type field value is Dynamic.

Title

Override

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.

Field	Mandatory	Description
Title	N	Enter a new title of the column.

Mandatory

Override

override

N

Select the checkbox to display the Mandatory checkbox

, which overrides whether

that overrides the behavior when the field on the extended table must contain a value to save a record.

Read

Only Override

only override

N

Select

the

this checkbox to display

the Read Only checkbox, which overrides whether

the Read only checkbox that overrides the behavior when a user can change the field value in the extended table.

Override example

As an For 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 if you need to change some protected column options before they are changed correctly.

Warning
When doing this, please keep in mind that inaccurate changes may harm your system, so check twice, and verify on some testing instance firstly if possible.

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

Base Table – select a base table.
Table – select the same table.
Column – select a column you need to override.
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.
Specify new attribute value.
Click Save or Save and Exit to apply changes.

To be more specific, have a look at the screenshot below. It shows the Mandatory attribute overriding of the IT Service column related to the Agreement table.

Image Removed

Defining an override for choice fields

When creating a field of the Choice 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, or Active, or Failed values.

Regarding task states, it makes sense to make values numerical. This can help with selection construction

the Email field in the User (user) table. The field should be non-mandatory and have a new title Work mail in the Employee (employee) table. At the same time, the Email field on the User form must remain mandatory with the same title.

To create the appropriate override, complete the following steps:

Create an override entry via the navigator menu or the Related List of the Email column record.
In the Table field, select the level at which the override will be performed. All tables containing the column are available for the selection.
Select the Mandatory override checkbox and specify a new mandatory value. In this case, leave the Mandatory checkbox clear.
Select the Title override checkbox and enter a new title value in the Title field.
Save the record.

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

Table of Contents

absoluteUrl	true
class	fixedPosition

Page tree

Versions Compared

Old Version 34

New Version Current

Key

Override example

Defining an override for choice fields