Querying views for Domino documents

The Query Views activity is used to query views from the database in the Lotus® Domino® server that matches the values that are specified in the document fields that are present in the view.

Using the Query Document activity
  1. Right-click Orchestration in the Project pane and click New Orchestration to create or open an orchestration. The orchestration pane is displayed.
  2. Select the Activities tab and expand the Domino folder.
  3. Drag Query Views from the Domino® folder onto the orchestration. A graphical representation of the orchestration along with the Checklist is displayed.
  4. Click Pick Endpoint, and then select a Domino endpoint.

    For instructions on creating or editing a Domino endpoint, see Creating or editing an endpoint for a Domino activity.

  5. Click Configure from the Checklist. The Configure pane is displayed.
    Note: The Next button is enabled only after you have selected the database name.
    • Click Browse to select an existing database from the Browse Domino Database pane. The Browse Domino databases display all the databases for the selected endpoint.
    • Click Browse to select an existing view from the Browse Domino Views pane. The Browse Domino Views display all the views for the selected endpoint and in the selected database.
    • Click Next to select an existing form from the Browse Domino Forms pane. The Browse Domino Forms displays all the forms related to the documents in that view.

  6. Select the Map Inputs in the Checklist. The XML schemas generated from the selected object of the Query Views activity are displayed as nodes under the request input parameter in the To Activity panel.

    For Form Types that are same across multiple databases, you can specify the database name as part of the optional parameters in map inputs, wherein the same orchestration can be used to perform outbound operations on different databases. To do this, you must specify the database name in the databaseName optional parameter (described in Table 1). If the databaseName parameter is populated with a value, the outbound operation is performed on the database that is specified in the databaseName parameter. If there is no value specified, the database name that is specified during configuration is used to perform the outbound operation.

    The optional input parameter is described in the following table:

    Table 1. Database name optional parameter
    Parameter Name Description
    databaseName Specifies the database name that can be dynamically added in map inputs to enable a single orchestration to perform outbound operations across multiple databases that have the same Form Type.
    The Domino connector also supports dynamic endpoint connection to a different Domino server. During run time, if you want to dynamically connect to a Domino server other than the one that is configured in the endpoint panel, add the new optional parameters in dominoConnectionProperties of map inputs. The parameters for dominoConnectionProperties are described in the following table:
    Table 2. Optional connection parameters
    Parameters Description
    dominoConnectionProperties parameters
    hostName Specifies the host name or IP address of the machine on which the Domino server is running.
    diiopPort Specifies the Domino Internet Inter-ORB Protocol (DIIOP) port that allows Java™ applets or applications to access Domino data remotely using CORBA. The default value is 63148.
    username Specifies the user name to connect to the Domino server.
    password Specifies the password that is associated with the user name to connect to the Domino server.
    connectionPool parameters
    minimumConnections Specifies the lowest number of Domino server connections that the Integration Appliance keeps open in the connection pool. Entering 0 (zero) is supported. The default value is 5.
    maximumConnections Specifies the maximum number of Domino server connections that the Integration Appliance can keep open in the connection pool. Entering 0 (zero) means the maximum number of connections is unbounded. The default value is 25.
    maxIdleTime Specifies the amount of time in minutes that a Domino server connection can be open in an idle state before being closed by the Integration Appliance. Entering 0 (zero) means that the connections are closed when they are returned to the pool —no idle time. The default value is 120 minutes.
    maxWait Specifies the amount of time in seconds that the Integration Appliance waits for a connection when all the connections in the pool are exhausted. If no connection is obtained after the wait time, an exception is thrown. The default value is 300 seconds.
    reclaimConnections Specifies the interval at which the connector checks for idle connections. Idle connections are reclaimed until the minimum number of connections is reached, as specified in the Minimum Connections parameter. The default value is 5 minute.
  7. Map the orchestration variables and the input parameter of the activity.
    Note: Values must be provided at run time for any mandatory elements of the input structure. A value can be provided by specifying a default value for element or by linking the element with an input node. During run time if no value is provided for a mandatory element, the activity throws an exception, which is reported by the Web Management Console. If a value is not provided at run time for an optional input parameter, no exception is thrown during run time.
  8. Specify the values as described in Table 3:
    Table 3. Search type
    Parameter Name Description
    KeyValues Specify the value for which you want to run a search.
    ExactMatch Specify the value as False to return all possible values related to the search term. For an exact match to be returned, specify the value as True.
    SearchFormula Specify a formula for a detailed search as per your requirement.
  9. Select the Map Outputs in the checklist. The XML schema generated to hold the response of the activity is displayed as nodes under the response output parameter in the From Activity panel.
    Note: Dynamically added fields present in the Domino document and not generated in the map input/output structures are handled by the Domino connector. While retrieving documents using this activity, the data for these fields are available in the map outputs section under AdditionalFields.
  10. Create a mapping between the output parameters and orchestration variables.
You have configured the Domino Query Views activity.



Feedback | Notices


Timestamp icon Last updated: Thursday, December 17, 2015


http://pic.dhe.ibm.com/infocenter/wci/v7r0m0/topic/com.ibm.wci.doc/Domino_query_views_activity.html