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

Identity Manager 8.2.1 - API Development Guide

Basic principles of API development Examples and help – Software Development Kit API configuration Implementing your own APIs API Designer Quick start – Creating an API with the API Designer 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 methods ImxClient command line program

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. In the menu bar, click Edit > Edit database queries.

  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. In the menu bar, click Edit > Edit database queries.

  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, select 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

Deleting a database query

NOTE: You cannot delete any database queries that have been predefined by the API Designer. The Delete button is disabled for such database queries.

You can delete existing database queries at any time.

To delete a query

  1. In the menu bar, click Edit > Edit database queries.

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

  3. Click (Delete).

  4. Confirm the prompt with Yes in the dialog.

  5. Click Close in the Edit database queries dialog.

Related topics

Managing tabs

Use the Tabs dialog to enable opened tabs, close tabs, or save changes that you have made in tabs.

To manage tabs

  1. In the menu bar, click View > Tabs.

  2. In the Tabs dialog, click or more tabs (while holding down the Ctrl key).

  3. Perform one of the following tasks:

    • Click Enable to enable the tab.

    • Click Save to save tab changes.

    • Click Close tabs to close the tab.

  4. Click Close.

Related topics
相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级