Relabel a column

Sometimes, two different tables may have fields of the same name that are both important (such as two tables with a sys_updated_on field). For clarity, relabel one of the fields.

Before you begin

Role required: admin.

About this task

To create clear reports, relabel the fields on the Database View [sys_db_view] table without changing the names of the fields.

Procedure

1. Navigate to All > System Definition > Language File.

2. Select New.

3. Fill in the form as follows:

   Name	Description
   Table	Name of the database view
   Label	Display label
   Plural	Plural form of the display label
   Element	Name of the field on the database view in the format variable prefix_fieldname. For example, you may enter inc_name to indicate the Name field on the Incident table. Variable prefix is a required field when you define the tables in a database view.

4. Select Submit.

Parent Topic:Joining tables using database views

Previous topic:Specify a field to return

Next topic:Configuring the number of records to return