---
sourceDocument: Zurich ServiceNow AI Platform Administration
sourceDocumentLink: https://www.servicenow.com/docs/r/zurich/platform-administration

 Release :

    - zurich

ft:locale :

    - en-US

ft:publication_title :

    - Zurich ServiceNow AI Platform Administration

ft:clusterId :

    - platadm

bundleId :

    - platadm

workflow :

    - Platform


---

# Specify field to return

# Specify a field to return {#ariaid-title1}

* Release version: Zurich
* 
* Updated July 31, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

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 AllSystem DefinitionDatabase 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](https://www.servicenow.com/docs/HH8B11LOCaP6NtNoePZL3w "Verify that the database view works correctly.").
**Previous topic:** [Example left join in creating a database view](https://www.servicenow.com/docs/wIoDcZumS3GEIC3d3ccHYQ "This example shows the proper settings when using left-joins to add tables to a database view.")  
**Next topic:** [Relabel a column](https://www.servicenow.com/docs/6r3HiPnxhocZUG2Q5GAzWg "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.")

*[\>]: and then