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

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

In the database view record, select a view table, and then select New in the View Fields related list. 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
View Field form

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.

In the previous 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.

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