Specify a field to return

  • Versão de lançamento: Australia
  • Atualizado 12 de mar. de 2026
  • 1 min. de leitura

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

    Antes de Iniciar

    Role required: admin

    Por Que e Quando Desempenhar Esta Tarefa

    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.

    Procedimento

    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.
      Figura 1. View Field form
      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.

    O que Fazer Depois

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