You can edit all existing database queries at any time.
To show all database queries
-
Click Edit | Edit database queries on the menu bar.
You can edit all existing database queries at any time.
To show all database queries
Click Edit | Edit database queries on the menu bar.
You can create new database queries at any time.
To create a database query
Click Edit | Edit database queries on the menu bar.
Click Add 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.
Double-click the dialog groups that may use the database query in the Dialog groups pane.
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.
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
Click Edit | Edit database queries on the menu bar.
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.
You can test database queries at any time.
To test a database query
Click Edit | Edit database queries on the menu bar.
In the Edit database queries dialog, click the database query you would like to test.
Click Test statement.
In the Test statement dialog, enable the check box next to the SQL statement parameters that you would like to include in the test.
Enter the values for each parameter in the Value column.
Click Test statement.
Click Close.
Click Close in the Edit database queries dialog.
© ALL RIGHTS RESERVED. Feedback Termini di utilizzo Privacy Cookie Preference Center