立即与支持人员聊天
与支持团队交流

Identity Manager 8.1.4 - API Designer User and Development Guide

API Designer Basic principles of API development Examples and help – Software Development Kit Quick start – Creating an API Working with the API Designer
Starting the API Designer Project types User interface Global settings Database objects Labeling changes Find and replace Multilingual captions Managing database queries Managing tabs Managing layouts Displaying the change history (command list) Bookmarks Compiling an API Managing versions (compilation branches) Testing an API Linking C# projects to the API Designer
API projects API files API Server ImxClient command line program

Displaying database queries

You can edit all existing database queries at any time.

To show all database queries

  • Click Edit | Edit database queries on the menu bar.

Related topics

Creating a database query

You can create new database queries at any time.

To create a database query

  1. Click Edit | Edit database queries on the menu bar.

  2. Click Add in the Edit database queries dialog.

  3. Enter a unique name for the database query in the Identifier field.

  4. (Optional) In the Description field, enter a description for the database query that describes the database query and its function.

  5. Enter the query as a SQL code in the SQL expression field.

  6. 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.

  7. (Optional) Click Test statement to test the SQL statement with different values. For more information, see Testing a database query.

  8. Click Save.

  9. Click Close.

Related topics

Editing a database query

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

  1. Click Edit | Edit database queries on the menu bar.

  2. Click the database query you would like to edit in the Edit database queries dialog.

  3. Enter a unique name for the database query in the Identifier field.

  4. (Optional) In the Description field, enter a description for the database query that describes the database query and its function.

  5. Enter the query as a SQL code in the SQL expression field.

  6. 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.

  7. (Optional) Click Test statement to test the SQL statement with different values. For more information, see Testing a database query.

  8. Click Save.

  9. Click Close.

Related topics

Testing a database query

You can test database queries at any time.

To test a database query

  1. Click Edit | Edit database queries on the menu bar.

  2. In the Edit database queries dialog, click the database query you would like to test.

  3. Click Test statement.

  4. In the Test statement dialog, enable the check box next to the SQL statement parameters that you would like to include in the test.

  5. Enter the values for each parameter in the Value column.

  6. Click Test statement.

  7. Click Close.

  8. Click Close in the Edit database queries dialog.

Related topics
相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级