Build it Yourself

Query tables support task and process list queries on data that is contained in the Business Process Choreographer database. This includes human task data and business process data that is managed by Business Process Choreographer, and external business data. Query tables provide an abstraction on the data of Business Process Choreographer that can be used by client applications. In this way, client applications become independent of the actual implementation of the query table.

Business categories and work baskets make extensive use of query tables. Therefore the Support Pack PA71: WebSphere Process Server - Query Table Builder must be installed as pre-requisite in WID. 

1. Verify the pre-req's for the Support Pack
2. Download the Support Pack
   
3. Install it according to the PA71_GettingStarted.pdf - Installation Instructions
   
4. Wait for installation to complete, including automatic restart of WID.

Verify system-level Java EE roles for the administration of business categories and work baskets. Access the settings for the Business Category System Administrator as well as the Work Basket System Administrator.

1. Log in to the Admin Console of WebSphere Application server. Either right-click on the server in WID and select Administration > Run administrative console or 
   open a web browser, enter URL http://yourhost:yourport/admin.
   Note: Replace yourhost with your server's internet address and replace yourport with the port of your server's HTTP transport, for example
   
   
2. Select the submenu Applications > Application Types = Enterprise Applications.
   Double-click your TaskContainer, here TaskContainer_qnode_server1.

   

   
   The configuration window opens.
   
   
3. Select Detail Properties > Security role to user/group mapping.
   The corresponding window opens. Verify the settings for the Business Category System Administrator as well as the Work Basket System Administrator. Both roles are assigned to with the userid admin.
   

   
   
   Note:
   Use the Map Users ... button to specify further users as domain administrators. However, in this scenario we stay the userid admin.
   

1. You are still under Business Integration > Business Process Choreographer > Human Task Manager and herein Additional Properties > Custom Properties.
   

1. Double-click BusinessCategoryEnabled. The settings page opens.

   

2. BusinessCategoryEnabled set to true.

   

3. Click OK. Click Save.

A project has been prepared, which serves as the basis to build this sample. The project contains the BPEL process and human task implementations when executing the process using Business Space. To import the prepared project interchange file, perform the following steps:

1. Click on the link InquiryRequest_Start process model to save the zip file to a directory of your choice, for example C:\tempWBSample\.
2. In WebSphere Integration Developer, click File > Import. The Import window opens.



3. Select Other > Project Interchange.
4. Click Next. The Import Project Interchange Contents window opens.



5. Click Browse next to the From zip file field.
6. Browse and navigate to the directory that you have used before to save the zip file.
7. Click Open.
8. Select your workspace directory as your Project location root.
9. Click Select All.
10. Click Finish.
11. Wait until the automatic build process has finished.
    

You may notice that there are problems indicated. We will fix those in the following steps.

Create a query table (QT)

Query tables support task and process list queries on data that is contained in the Business Process Choreographer database. This includes human task data and business process data that is managed by Business Process Choreographer, and external business data. Query tables provide an abstraction on the data that can be used by client applications. For further information refer to the document  PA71 Getting Started with the Query Table Builder, to the section in the Information Center Query tables in Business Process Choreographer, as well as to a Query Table Sample for reference.

In this sample we use query tables to include the business category, the work basket identifier, and the customer name as task properties. Refer to section familiarize with the process were the custom property CustomerName was enabled in the process model. The query table properties will be used further on to configure the task list / work basket widget in Business Space to support filtering, sorting, and grouping.

Note:
When you are familiar with query tables switch to Run the sample to just deploy the provided query table. Afterwards continue on with the next section on Creation of Business Categories in Business Space.  

1. In WID Business Integration Perspective select Window > Open Perspective > Other ... > Query Tables
2. In the navigation tree right-click in the WbBCSample project.  Select File > New > Composite Query Table for Business Space.
   
   
   

   The Composite Query Table Definition for Business Space opens.

3. Select module WbBcSample and enter for the Query Table Name: - everything in capital letters - the name PREFIX.WB_INQUIRY_CREDITCARD

   

   Click Next.
   The Create a composite query table definition for Business Space window opens.
   
   

4. Select the radio button for Task List as you specify the the Task List columns for the inquiry work baskets.
   Press Finish.
   

   
   
   The Query Table specification page with the primary query table opens.

   
   
   Note:
   Query tables that will be used in Business Space have to fulfill certain criteria. Query tables for the widget Tasks List require:
   

   1. The primary query table has to be TASK.
   2. The attributes KIND and STATE of the primary query table TASK have to be added to the query table.
      To enable drill down scenarios that include the tasks associated with a process instance, add the attributes CONTAINMENT_CTX_ID and TKTID. Additionally, for displaying details in the Tasks List it is recommended to add IS_WAIT_FOR_SUB_TK.
      
      
   3. Press the help button to learn more about the predefined Business Process Choreographer database views.
      
      
5. Drag the task attributes you want to use or display in a task list / work basket from the Task table and drop it right at the beginning of the table at the bottom of the editor. Perform this step for the PRIORITY, WORK_BASKET and TYPE attribute, where the later one stores the Business Category name.
   
   
   
6. Add the Task display name as additional parameter to the primary query table.
   Select the TAID (TASK_TEMPL_DESC) table from the navigation bar (Palette)  under Human Task (predefined). Drag and drop  it on the canvas. This supplemental query property in blue gets joined / linked with the primary query table.
   

   
   
   Drag and drop the DISPLAY_NAME attribute from the TAID supplemental table and move it right in front of the Priority column in the lower part of this editor.
   

7. Change new query table attribute via Properties > Details > Name from DISPLAY_NAME to TASK_NAME.
   
   

   

8. Modify the Selection Criteria for the join. Select the connection LOCALE='default'. Under Properties > Details > Selection Criteria use the drop down menu on the far right and select LOCALE=$LOCALE_BEST_MATCH.

   

   The chosen selection criteria is displayed.
   

   

9. Add the customer name as an additional parameter to the primary query table.
   Select the QUERY_PROPERTY table from the navigation bar under Business Processes (predefined). Drag and drop in on the canvas. This supplemental query property gets joined / linked with the primary query table.
   Select the STRING_VALUE in the QP (QUERY_PROPERTY) table. Drag and drop it to the lower part in front of the PRIORITY column.



10. In the defined query table double-click on STRING_VALUE
    Under Properties > Details > Name change STRING_VALUE to CUSTOMER_NAME.

    

11. Modify the Selection Criteria for the join. Select the connection NAME='aName'. Under Properties > Details > Selection Criteria replace aName by CustomerName.

    

12. Specify a primary query table filter.
    In the editor, select the primary query table TA (Task). The property window opens.
    Under Details specify the Filter: entering WORK_BASKET='WB_Inquiry_CreditCard'.

    

13. Define the QT Display Name.
    Click on the canvas. The property window opens. Select the Description tab. For the Display Name enter QT_Inquiry_CreditCard.

    

14. Press Ctrl+S to save your work.

1. Right click the PREFIX.WB_INQUIRY_CREDITCARD and select Test on local WebSphere Process Server.

   
   
   The Test on local WebSphere Process Server Window opens.
   

2. Specify the settings for the test.
   Under WPS profile directory open the selection window and navigate to your profile directory. Press OK.
   For the WPS user ID: enter admin and Password: admin.

   

3. Press Deploy.
   The Console indicates successful deployment of the query table.
   Wait until successful deployment is returned.
   
4. Press Query as Admin.
   The Query Result shows the columns specified for the new Task query table, in this case with one task instance already available.
   

   

5. Close the Test window.
   

The association of this query table with a Task List (work basket) in Business Space is explained in the following section to create and configure work baskets and distributions in Business Space.

Define and update the settings of the business category using the Business Category Information Widget.

1. In WebSphere Integration Developer, switch to the Server view.
In the table, right-click WebSphere Process Server V7.0.
From the pop-up menu, select Launch > Business Space.



Optionally start the Business Space on WebSphere Process Server, perform the following steps:

1. In a web browser supported by Business Space, open URL http://yourhost:yourport/mum/resources/bootstrap/login.jsp.

Note: Replace yourhost with your server's internet address and replace yourport with the port of your server's HTTP transport, for example

The login screen is displayed.
2. Enter the BusinessCategory- / WorkBasketSystemAdminstrator User ID admin and Password admin.
   Click Login.



3. Create a new space
   Click Manage Spaces. Click Create Space.

   

   The Create Space window opens.
4. Create Space
   For Space name: enter Administer Work Baskets and Business Categories.
   For Create a new space using a template select the Administering Work Baskets and Business Categories template from the drop down list.

   

   Click Save. The new Administer Work Baskets and Business Categories space is created.
   Click Done.
   
5. Select Go to Spaces. Double-click on Administer Work Baskets and Business Categories.
6. Select the Business Category Administration tab. Select the Business Categories widget. Press Actions > Create.
   
   

   
   The Business Category Information Widget opens.
   

7. Specify the business category.
   For the Identifier as well as the Name enter CustomerService.
   Press the Look up Button for the Task list field and select the query table QT_Inquiry_CreditCard.
   Press OK.
   

   

8. Press Save.

The Work Baskets Administration page is where you administer work baskets. It includes Work Baskets List widget that displays the work baskets that you can administer. The second Work Basket Information widget displays information about a work basket that you selected in the Work Baskets List widget. This widget is the place where you define and update the settings for a work basket, e.g. to specify the content, roles, and distribution targets that are available to users. The work basket system administrator is responsible for defining work baskets and their distribution targets based on the needs of the line of business, and the available human resources that are defined in the corporate people directory.

The diagram below shows the work basket structure, names, and owners that need to be created in this section.

The following steps need to be applied:

1. You are still logged in as admin/admin to the Administer Work Baskets and Business Categories Space.
   
2. Select the Work Baskets Administration tab.
   Press Actions > Create.
   

   

   The Work Baskets Information Widget opens.
   
   
3. Specify the wok basket details.
   As the Identifier as well as Name enter WB_Inquiry.
   As Type select Group.
   As Owner enter bdaniel which resolves to Bonnie.
   Press the Look up Button for the Task list field and select the query table QT_Inquiry_CreditCard.
   Press OK.
   

   

4. Press Save.
   Switch to the Access page.     
   
5. Under User or group enter bdaniel. Press Add when the name is shown.
   

   

   A row to specify the technical roles for the user bdaniel is added.
   
6. Set the flag for the Work basket role Distributor and Task role Potential owner.

   

7. Press Save. Press Cancel.
   
   Note:
   Similar to staff assignments via staff verbs is it possible to use different People Directory Providers. These can be defined using the work basket APIs where for Business Space the default people directory provider is used. See Admin Console Application servers > server1 > Human Task Manager > Custom Properties > Staff.DefaultJNDINameOfStaffPluginProvider .
   No changes are required for this sample.
   

   

8. Repeat these steps using the WB_Inquiry work basket as the parent and create and configure following other work baskets.

Attribute Work basket identifier and name	General Type	Owner	Task List Query Table	Access User	Access
WB_Inquiry_CreditCard	Topic	bdaniel (Bonnie)	WB_Inquiry _CreditCard	bdaniel	Distributor Pot. Owner
WB_Inquiry_CustomerAccounts	Topic	bdaniel (Bonnie)	none	bdaniel	Distributor Pot. Owner
WB_Inquiry_Loans	Topic	dedwards (Doug)	none	dedwards	Distributor Pot. Owner
WB_Inquiry_NetBanking	Topic	dedwards (Doug)	none	dedwards	Distributor Pot. Owner
WB_Inquiry_Clearing	Clearance	dedwards (Doug)	none	dedwards	Appender Distributor Pot. Owner
WB_DCampbell	Individual	dcampbell (David)	none	dcampbell	Transfer-Initiator Pot. Owner
WB_DCampbell	-	-	-	dedwards	Transfer-Initiator
WB_JJames	Individual	jjames (Jeffrey)	none		Opener Pot. Owner

At the end of your definition eight work baskets are listed.



9. Specify distribution targets.
   Select the WB_Inquiry work basket. Press Edit work basket. The Work Basket Information widget opens. Switch to the Distribution targets window.
   
   

   

10. In the lower frame under Available distribution targets select the following five work baskets: WB_Inquiry_CreditCard, WB_Inquiry_CustomerAccounts, WB_Inquiry_Loans, WB_Inquiry_NetBanking, and WB_Inquiry_Clearing. Select the arrow which points upwards.
    

The selected work baskets show up under the Selected distribution targets.

11. Press Save. Press Cancel.

12. Repeat this step. Select and edit the WB_Inquiry_CreditCard work basket and specify the baskets WB_DCampbell and WB_JJames as distribution targets.
13. Press Save. Press Cancel.
14. Logout as user admin.