To run this sample, the Business Process Choreographer Explorer will be used to start processes and work with the human tasks, and the Query Table Builder will be used to deploy and test the query table.
Note:
In order to be able to use the Query Table Builder to deploy and test the query, a local WebSphere® Process Server 7.0 has to exist and must be running.
To start the BPC Explorer on WebSphere Process Server, perform the following steps:
http://yourhost:yourport/bpc.
Note:
Replace yourhost with your server's internet address and replace yourport with the port of your server's HTTP transport,
for example
If security is enabled, the BPC Explorer opens with a login screen:

The BPC Explorer opens:

To start the insurance claim process, complete the following steps:
The Currently Valid Process Templates view is displayed:

The Process Input Message view opens:

ClaimProcess_1.123456.John.Doe.Ferrari Car Crash.125000.
The My To-dos view is displayed:

The new task ReviewHumanTask has been started and is in the state ready.
To deploy the query table that has been created in the Build it Yourself section on a local WebSphere Process Server, follow these steps:

The Test on local WebSphere Process Server window opens:

Troubleshooting:
If the window does not open but instead a message box is shown, please refer to the Troubleshooting section.
button next to the WPS profile directory field. The Select Profile Directory window opens.

Troubleshooting:
If the deployment was not successful, please refer to the Troubleshooting section.
Hint:
The output in the Console always includes the command that has been used to execute the selected operation.
In this case, the Console includes the command that has been used to deploy the query table:
To list all composite query tables that are deployed on the local WebSphere Process Server, perform the following steps:

Troubleshooting:
If the list does not contain the composite query table MYCOMPANY.REVIEWTASK, perform the steps described in the
section Deploy the query table
and make sure that the successful deployment of the query table is confirmed.
To test the deployed query table, follow these steps:


In this example, one result element was found, and the attributes are shown in the order in which they were specified in the query table definition.

Hint:
The output in the Console also includes the api call to execute the query.
To undeploy the query table once it is no longer needed, perform the following steps:

Once you are done testing the query table, remember to complete all human tasks so that the processes you have started can be finished. Refer to the Human interaction sample in the Getting started section for details.
Symptom:
When Test on local WebSphere process server is being selected in the context menu of
a query table definition file, the following message is being shown:

Possible Solution:
This message will be shown when the query table definition file you have selected has been modified and not saved.
You can now choose to save the file before testing it (Yes), test the file without the modifications that werde done since it was
last saved (No), or cancel the start of the test (Cancel).
Symptom:
The deployment of a query table definition was not successful.
Possible Solution:
A deployment can for example fail because of an invalid user name or password, or because
the query table that has to be deployed contains validation errors.
Please refer to the output on the Console for details: The Console
contains all status and error messages of the current operation, and will provide you with a
description of the problem.