Specify a field to return

Restrict or specify a field that you want returned by the joined table.

Before you begin

Role required: admin

About this task

You can restrict the fields displayed in the database view output by adding fields to the View Tables related list.

When you restrict fields, you must create a View Field record for the join field from the Where clause in the parent record. If you omit a record for this field, it cannot be returned, and the join fails.

Procedure

1. Navigate to All > System Definition > Database Views.
2. Select the database view you want to add a field to return to.
3. In the database view record, select a view table, and then select New in the View Fields related list.
4. In the View Field form, select the field you want to display in the database view output.
   If no fields are defined in the View Fields related list, all fields are returned. If any fields are defined, then only those fields are returned. For example, you can restrict the display if there are fields that should not be viewable to all users.

   Figure 1. View Field form

   

   In this example, the Where clause uses the sys_id field from the Incident table to establish the join. For the join to succeed with a restricted field list, you must include a record for the sys_id field in the View Fields related list.

What to do next

Verify your changes using the Try It related link in the database view record. See Test the database view.

Previous topic: Example left join in creating a database view

Next topic: Relabel a column