Display function results in a database view

  • Release version: Washingtondc
  • Updated February 1, 2024
  • 1 minute to read

    • Add a function field to the output of a database view to see function results.

    Before you begin

    Role required: admin

    Procedure

    1. Navigate to All > System Definition > Database Views.
    2. Select a database view.
    3. Select the Try it related link.
    4. Add the function field to the database view output.
      See Configure items on forms or in lists using a list collector.
    5. Review the function definition if the expected value is not returned or a returned value indicates the function definition is invalid.
      • If the message Invalid function is returned, the function definition is invalid for string field types.
      • If an empty value is returned, the function definition is invalid for other field types.
      • If an unexpected value is returned, review the field definition in the function definition.

    Result

    The function field operation is executed and the results appear in the database view output.