NOTE: You cannot edit any database queries that have been predefined by the API Designer.
You can edit existing database queries at any time.
To edit a database query
-
In the menu bar, click Edit > Edit database queries.
-
Click the database query you would like to edit in the Edit database queries dialog.
-
Enter a unique name for the database query in the Identifier field.
-
(Optional) In the Description field, enter a description for the database query that describes the database query and its function.
-
Enter the query as a SQL code in the SQL expression field.
-
In the Dialog groups section, double-click the dialog groups for which access permissions are to be changed.
TIP: Click Select all or Deselect all to quickly select or deselect all dialog groups.
-
(Optional) Click Test statement to test the SQL statement with different values. For more information, see Testing a database query.
-
Click (Save).
-
Click Close.