Specify a field to return

Use the View Field form to restrict or specify a field that you want returned by the joined table.

If no fields are defined in the View Fields list, all fields are returned. If any fields are defined, then only those fields are returned.

Figure 1. View Fields list
View Fields list

When you restrict the fields returned by creating View Field records, you must create a 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.