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.