Using the QueryWithView and QueryEx Methods

How to:

For Business Components, the iWay Application Adapter for Siebel enables the following Query methods:

The Query method performs a standard query function using the Document Object Model (DOM).

The QueryRPC method performs a standard query function using a simple Remote Procedure Call (RPC).

The QueryWithView method allows you to specify a Siebel view mode as a parameter. The API parameters allow different presentations of data depending on the Siebel environment that you configured. If you want to enable a user to retrieve records based on different view modes, using the QueryWithView method is recommended.

The following view levels are available:

The QueryEx method allows you to create the request schema and response schema, and choose specific input and output fields from the Siebel system.
Top of page
x
Procedure: How to Create a Simple Query Using the QueryEx Method

To create a simple query using the QueryEx method:

  1. In the left pane, expand the Business Object or the Business Service node.

  2. Expand a Business Component, for example Account.
  3. Right-click queryEx and select Add Simple Query from the context menu, as shown in the following image.

    The Add Simple Query dialog box opens, as shown in the following image.

  4. Perform the following steps:
    1. In the Query Name field, type a name for the query you want to create, for example, SampleQuery
    2. In the Input Fields Count field, type the number of input fields you want in your query, for example, 1.
    3. In the Input Fields Count field, type the number of output fields you want in your query, for example, 1.
  5. Click Continue.

    The following Add Simple Query dialog box opens, which prompts you for the input and output fields you want to query.

    Note: Since this example is using only 1 input field and 1 output field, the Add Simple Query dialog box is configured accordingly.

  6. Perform the following steps:
    1. In the Field Select column for the input field, select the input field you want to use from the drop-down list, for example, Account_spcMarkets.

    2. In the Field Select column for the output field, select the output field you want to use from the drop-down list, for example, Account_spcRole.
  7. Click Create.

    The new simple query, for example, SampleQuery is added below the queryEx method node, as shown in the following image.

    The request and response schemas for the new simple query (SampleQuery) are available in the right pane, as shown in the following image.

  8. Click the Request Schema tab to view the XML request schema.

  9. Click the Response Schema tab to view the XML response schema.

    You can also create an iWay Business Service for the new simple query. For more information, see Creating iWay Business Services.
Top of page
x
Procedure: How to Delete a Simple Query Using the QueryEx Method

To delete a simple query using the QueryEx method:

  1. Expand the queryEx node in the left pane.

  2. Right-click the query you want to delete, for example, SampleQuery, and select Remove Simple Query from the context menu.

    The Remove Simple Query dialog box opens, as shown in the following image.

  3. In the Query Name field, type the name of the query you want to delete, for example, SampleQuery.
  4. Click Remove.

    The simple query node, for example, SampleQuery, is removed from the left pane, as shown in the following image.

iWay Software