DB query to use the database views

Create a database query to use the database views.

1. On the DB query action dialog box of a form, click Configure.
   The DBQuery dialog box is displayed.
2. To specify the database connection string that holds the details of the relational database, select either Database connection.

   • Local (Default): Select a global variable or click  to manually enter the connection string.

   • External: To use the database connection from external storage, enter the secret name for the connection secret stored in the configured external storage.

   By default, the Type list displays Tables and all tables within the selected database appear on the Tables list.

3. On the database Type list, select Views. (Default: Tables)

   All existing views appear on the Views list.

4. On the Views list, select the view for which to retrieve records.
5. Configure the query in the same way as for viewing a table. See DB query to get records in a table.
6. Click OK.

   The DB query action dialog box displays the Query.

7. Click Save.